Learn Excel for reporting in 2 hours
4.8 (4 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.
251 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Excel for reporting in 2 hours to your Wishlist.

Add to Wishlist

Learn Excel for reporting in 2 hours

Tips revealed to easy manage your Excel databases
4.8 (4 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.
251 students enrolled
Created by Andries Crina
Last updated 1/2015
English
English
Learn Fest Sale
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Have Excel installed on your PC
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.

Who is the target audience?
  • The targeted audience is:
  • Beginner
  • Intermediate
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 23 Lectures Collapse All 23 Lectures 02:08:27
+
Introduction: Learn to create, insert and modify a function
4 Lectures 17:21

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

First thing first: What is a formula and what can contain?
02:53


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.

Ways of changing your formula
02:28
+
Excel formulas used in great and understandable projects
13 Lectures 01:26:18
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


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
+
Excel tips and tricks for interactive dashboards
6 Lectures 24:48
Add your formulas and formats in the same time in different sheets
02:55


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

About the Instructor
Andries Crina
4.8 Average rating
4 Reviews
251 Students
1 Course
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.