Course Content
Excel 2016 - Expert - Advanced Charting and Data Analysis (Excel 2016 – Expert – Level 1)
This course covers topics included in the MOS Expert exam 77-728. This includes using Advanced Chart features, PivotTables, Cube Functions and PivotCharts. You will also learn how to create Scenarios, Data Tables and use Goal Seek.
The estimated time to complete this course is 2 hours and 57 minutes
Excel 2016 - Expert - Advanced Functions, Tracking and Auditing (Excel 2016 – Expert – Level 2)
This course covers topics included in the MOS Expert exam 77-728. This includes Tracking changes, using Logical, Informational, Time, Mathematical and Lookup Functions. You will also learn how to Consolidate workbooks, Share and Protect workbooks and use Auditing tools.
The estimated time to complete this course is 3 hours and 10 minutes
Excel 2016 - Expert - Advanced Formulas, Macros and External Data (Excel 2016 – Expert – Level 3)
This course covers topics included in the MOS Excel Expert exam 77-728. This includes Internationalizing workbooks, custom templates, data formats and copying macros. You will also get external data, use macros and form controls, evaluate formulas and use the MATCH and INDEX functions.
The estimated time to complete this course is 3 hours and 28 minutes
