The best way to learn Excel is by doing practical exercises.

Description

The best way to learn Excel is by doing practical exercises.

Do you have little or no experience with Microsoft Excel? We will go through more than 40 practical exercises, where you will learn everything you need to know to use Microsoft Excel as an effective tool!

We will start with 10 basic exercises, where you will learn the fundamentals of how to use Excel. Then you will learn how to make reports and dashboards, use PivotTables and PivotCharts, analyze datasets and how to use the 30 most used formulas and functions in Excel.

Each module in the course is divided into two parts, one theory part and one practice part where you use what you have learned. All exercises have video solutions.

This course is for you, if you want to:

• stop struggling with Excel formulas that are not working!

• easier understand other people's Excel worksheets!

• easier find the formula you should use!

• build your own Excel sheets, instead of asking other people to make them for you!

• easily analyze important parameters and become one of the management's most important assets!

• impress colleagues with your Excel new skills!

• Self-thought and beginners with little prior experience.
• If your looking to take your Excel skills from beginner to Great, then this course is for you.
• If you like learning by doing, then this course is for you.

Course content

• The fundamentals (10 exercises)
  • Download exercises
  • The Fundamentals
  • Formulas and Charts
  • Budget and Tables
  • Absolute Cell Reference and Goal Seek
  • The IF Function
• Reporting and Practical functions
  • Introduction to Reporting and Practical Functions
  • Exercise 1-4 (video solution)
• Data Analysis
  • Introduction to Data Analysis
  • Exercise 1-6 (video solution)
  • Exercise 7 (video solution)
• Analysis of Big Datasets
  • Introduction to Analysis of Big Datasets
  • Exercise 1-6 (video solution)
  • Exercise 7-9 (video solution)
• PivotTables and PivotCharts
  • Introduction to PivotTables and PivotCharts
  • Exercise 1-6 (video solution)
• Repetition - more exercises
  • Exercise 1-3 (video solution)
  • Exercise 4-8 (video solution)

Microsoft_Excel_-_40_Exercises_for_beginners._Learn_by_doing.part1.rar

Microsoft_Excel_-_40_Exercises_for_beginners._Learn_by_doing.part2.rar

Microsoft_Excel_-_40_Exercises_for_beginners._Learn_by_doing.part3.rar