2017
3:17
00 – Introduction
Welcome
What to know before watching this course
Using the exercise files
Using the challenge files
01 – Microsoft Office Specialist (MOS) Expert Exam Overview
Understand the different kinds of Microsoft Office Specialist certifications
Prepare for the test
Overview of the 2016 MOS Expert exam format and learning objective
02 – Manage Workbook Options and Settings
Manage workbooks
Reference data in another workbook
Reference data using structured references
Protect worksheets and workbooks
Challenge: Manage workbook options and settings
Solution: Manage workbook options and setting
03 – Apply Custom Data Formats and Layouts
Create custom formats (number, time, and date)
Populate cells by using advanced Fill Series options
Create custom conditional formatting rules using formulas
Manage conditional formatting rules
Create custom styles and themes
Insert and configure form controls
Challenge: Apply custom data formats and layouts
Solution: Apply custom data formats and layouts
04 – Create Advanced Formulas
Use AND/OR functions
Use IFS functions
Use the LOOKUP function
Use the MATCH and INDEX functions
Use date and time functions
Troubleshoot formulas
Use What-If Analysis
Define named ranges and objects
Challenge: Create advanced formulas
Solution: Create advanced formulas
05 – Create Advanced Charts and Tables
Use advanced chart formatting
Create and modify PivotTables and filter with slicers
Format PivotTables and use GETPIVOTDATA
Create and modify PivotCharts
Challenge: Create advanced charts and tables
Solution: Create advanced charts and tables
06 – Final Challenge
Challenge: Full-length MOS Expert sample exam for Excel 2016
Solution: Full-length MOS Expert sample exam for Excel 2016
07 – Conclusion
Next steps
Exercise Files
Related products
