Excel in Microsoft Excel 2: Intermediate to Expert advanced

Back To All Courses

153 Lessons

All

Skill Level

11:04h

course Duration

English

Audio

Eng

Subtitles

Share This Class:

Overview

This course series has been recorded on Excel 2016 and Excel 2010, but the content also covers Excel 2013 and 2019.

There are two separate courses, one for Excel for PC and one for Excel for Mac.

Building on the skills learnt in “Excel in Microsoft Excel 1”, here’s levels 6-10. By the end of this course, you will have the skills needed for the official Microsoft Excel Expert exam. How would that look on your resume?

Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 10?

This course teaches all the skills that Microsoft want you to know for the Expert exams. Specifically, they are the skills required to undertake the Microsoft Certificate 77-851 (for Excel 2007 Expert), 77-888 (for Excel 2010 Expert), 77-427 and 77-428 (for Excel 2013 Expert) and 77-728 (for Excel 2016 Expert) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

Completing this course will help you:

Manage workbooks and workbook review
Create and manage PivotTables
Present data visually, using PivotCharts and advanced charts
Perform data analysis and business intelligence (only usable in the PC version)
Troubleshoot formulas
Manage and reference defined names and custom workbook elements
And learn lots of formulas, including VLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT

Who is the course for?

This is for you if you want to develop your Excel skills to an Expert level.

This is also for you if you want to take the Microsoft Office Specialist Expert Exams.

This may not be for you if you are not already at least at an Intermediate level (already done levels 1-5 or equivalent).

Learning Path

Level 6 – Workbooks and Logical and Statistical Functions

Manage workbooks
Protect documents and Manage workbook review
Using Logical and Statistical Functions

Level 7 – Pivoting and date/time and financial functions

Creating PivotTables
Advanced Formatting
Creating PivotCharts and advanced charts
Apply advanced date and time and financial functions

Level 8 – About Formulas, including Formula Arrays

Troubleshoot formulas
Prepare a workbook for internationalisation + accessibility
Manage and reference defined names
Formula Arrays

Level 9 – Get and Transform and the Data Model, and advanced elements

Perform data analysis and business intelligence (PC only)
The Data Model and PowerPivot (PC only)
Create and modify custom workbook elements
Create advanced formulas

Level 10 – Controls and VBA

Link form controls to cells
Visual Basic for Applications (VBA)

What people are saying

“Thank you very much: simply, you took us deeply in all the points Microsoft mentioned to pass the expert exam. The recordings quality is perfect.”
Hatem
“highly recommend this well structured course made simple by the one and only Mr.burton himself ,thank you for an experience par excellence.cheers”
Haider
“This was just a substance filled, ever-learning course! As one of my resource training courses, I sat my Excel Expert Exam and passed. Big thanks to you Sir.”
Roderick
“Wonderful course!! There is everything you need to know for the Microsoft Excel Expert Exam (I’ve just passed it!), and it’s all well explained! I highly recommend it for everyone who wants to take and pass the test or to understand better the Excel world. Great job Phillip!”
Antonio
Previous
Next

Excel in Microsoft Excel 2: Intermediate to Expert advanced

153

Lessons

All