153
LESSONS
Int
SKILL LEVEL
11:04 hr
DURATION
ENGLISH
AUDIO
ENG
SUBTITLES
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.
This course builds on the skills learned in the Excel Beginner to Intermediate course and covers the requirements of the official Microsoft Excel Expert exam:
- Certificate 77-851 for Excel 2007 Expert
- Certificate 77-888 for Excel 2010 Expert
- Certificates 77-427 and 77-428 for Excel 2013 Expert
- Certificate 77-728 for Excel 2016 Expert
WHO IS THE COURSE FOR?
This course is ideal for those with an existing working knowledge of Excel to intermediate level who wish to take their skills to expert level. It is excellent preparation for those wanting to take the official Microsoft Office Specialist Expert Exam.
LEARNING PATH
WORKBOOKS. LOGICAL AND STATISTICAL FUNCTIONS
- Manage workbooks.
- Protect documents and manage workbook review.
- Using Logical and Statistical Functions.
PIVOTING. DATE/TIME AND FINANCIAL FUNCTIONS
- Creating PivotTables.
- Advanced formatting.
- Creating PivotCharts and advanced charts.
- Applying advanced date, time and financial functions.
FORMULAS, INCLUDING FORMULA ARRAYS
- Troubleshoot formulas.
- Prepare a workbook for internationalisation and accessibility.
- Manage and reference defined names.
- Formula arrays.
GET AND TRANSFORM. THE DATA MODEL. 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.
CONTROLS AND VBA
- Link form controls to cells.
- Visual Basic for Applications (VBA).
REVIEWS
“Extensive topics covered through in depth lessons from someone with a clear expertise.” Jack
“Excellent course. The instructor knows his stuff and it shows. Very in-depth – explains the little things that often go overlooked in other Excel courses I’ve done. Passed the Advanced Excel certification test first time with the skills I learned in this course!!! If you want to learn advanced Excel skills this is the course.” Steven
“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