Learn Excel for reporting in 2 hours

Tips revealed to easy manage your Excel databases
5.0 (6 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
246 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 23
  • Length 2 hours
  • Skill Level Intermediate Level
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2015 English Closed captions available

Course Description

This class will change the way you are working with Excel and makes you an expert in solving various problems in just a few minutes.

This course provides the information, tips and tricks that will help you save precious time working with all kind of database. Are you tired of copy from side to side? Use formulas and your data will be updated instantly. All you have to do is to write the formula, in only 1 minute. You will stop waste time with the calculation of dates, sums, bonuses, poundage and other.

Do you have Excel database with unformatted data, atypical writing format, commas, too many spaces or other symbols?

Do you have a lot of information that needs synthesizing but first your data has to be in the same format or you need to import an Excel database into a program and these require a specific format?

By learning the lessons from this course you will use formulas, the tips and tricks for an easy to manage database and finish your project in a few minutes. If you have periodical reports with the same format, from now on all you have to do is to copy the new base over a head table and you will have the information updated. You will learn tricks for copying information, mechanisms to have the same formulas in different sheets and will have the knowledge that helps you clean the database.

You have a lot of working files to practice all that you learn.

What are the requirements?

  • Have Excel installed on your PC

What am I going to get from this course?

  • Learn to use a formula in excel
  • Learn what does a formula contains
  • Learn how to use relative and absolute cell reference
  • Learn how to extract text using formulas
  • Learn how to edit formulas
  • Learn how to define a cell range or a table and then use it in formulas
  • Learn how to return a value from a different sheet or in the same sheet
  • Learn how to write formulas with the simple and fast formula-Autocomplete
  • Learn how to create simple and advanced calculations with Excel functions
  • Learn how to clean a database
  • Learn how to convert dates to be recognized by excel

What is the target audience?

  • The targeted audience is:
  • Beginner
  • Intermediate

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction: Learn to create, insert and modify a function
Course overview
Preview
05:12
02:53

In this lesson you will find out also about the parts of a formula.

Discover various methods to insert a function
Preview
06:48
02:28

In this lesson you will find out various methods for changing an excel formula. After watching this lesson please download these working files that will help you have the best practice.

Section 2: Excel formulas used in great and understandable projects
Take use of a smart tool Formula Autocomplete
01:58
Solve your tasks quicker with maths functions
14:02
See the big picture of your database using statistical functions
09:17
Define and use names in formulas
04:54
Date and time functions that update and extract your dates
Preview
08:50
Information functions to verify your database
04:12
Text functions to convert between Upper and Lower case
03:10
Text functions for a cleaner and more arranged database
05:51
If logical function in practice
05:18
Practicing absolute and relative cell reference in a logical project
08:07
Vlookup your data in the same sheet
05:39
Vlookup your data in a different sheet
04:40
Have a result depending on multiple formulas with nested functions
10:20
Section 3: Excel tips and tricks for interactive dashboards
Add your formulas and formats in the same time in different sheets
02:55
Copying data, sheets and formats for different rows
Preview
08:20
Easy synthesize your data with great tips on using pivot table
05:30
Tips of copying data, rows and columns
03:01
Transform your text using text to columns
04:01
Review
10 questions
Congratulations!
Preview
01:01

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andries Crina, Excel Master Trainer and Project Manager at Coface

I am Excel Instructor, Project manager at Coface and General Manager of the Lucrasium Learn Company

My education includes a bachelor degree at the Academy of Economic Studies – Faculty of Finance, Insurance, Banking and Stock Exchange and a Master at the University of Political, Science and Public Administration and I am a project leader at Coface (multinational company, present in over 98 countries) and the owner of the Lucrasium Learn Company.

I always had an attraction for numbers and logical thinking and from the age of 10 I was sure that finance is my life. If you ask a friend of mine what my nickname is, the answer will be “Count”. With an experience of more than 12 years in working with Excel, I can say that is a passion of mine. During this period I learned all the secrets of probably the most used program in the business sector. Due to the high volume of work, I looked for the most efficient solutions and managed to provide courses for students and working class people. I helped and trained numerous individuals that managed to increase their working productivity. As a comparison, if a person had to provide a report that was being done in a half a day, after learning the course from me, the job was ready in just a half an hour. I also provided over 52 courses in Excel, Access, Word, Powerpoint, Business Administration, Finance, Efficient Working, Time Management and Personal Development.

Ready to start learning?
Take This Course