Microsoft Excel Analytics - Data Analysis Essentials

Course details

Learn the essentials of Microsoft Excel Analytics through this step-by-step course. The Data Analytics with Microsoft Excel  course takes you through the basics of Excel Analytics, but also introduces some more advanced topics like advanced filters, pivot charts and pivot tables. The course also learns you some, shortcuts, tips and tricks for improving your productivity in working with Excel.

Learn to build a dashboard from scratch!

Shorcuts can boost your productivity up to 5X.. and improve improve your efficiency in building dashboards!

The course contains training materials, where you can practice, apply your knowledge and build a dashboard from scratch. The training materials are provided in an Excel file that you can download to your computer. Each module also ends with a short quiz and there is a final quiz at the end of the course.

Good luck and hope you enjoy the course.

Pre-requisites:

• Some basic knowledge of Microsoft Excel Analytics

Course content:

The course consists of the following modules:

• Introduction, shortcuts, tips & tricks!
• Excel Basic Formulas: COUNT, COUNTIF(S), SUM, SUMIF(S), AVERAGE, VLOOKUP, IF(S), INDEX/MATCH, CONCATENATE, TRIM
• Conditional Formatting and Cell Formatting
• Charts and Tables
• Sorting and Filtering
• Pivot Charts and Pivot Tables
• Final Quiz

Who should follow this course?

• You should take this course if you want to learn the essentials of Microsoft Excel from scratch.
• This is not a course for advanced Excel users, but for novice users that would like to broaden their knowledge of Excel.
• This is an ideal course for novice Excel users that would like to take their Excel skills to the next level.
• Professionals that would like to get a good knowledge of Excel, as part of their employers learning program.