Demonstrate your advanced knowledge of Excel by becoming a Microsoft Office Specialist (MOS). This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Microsoft Office Specialist (MOS) Expert exam for Excel 2016, which focuses on managing workbook options and settings, applying custom data formats and layouts, creating advanced formulas, and creating advanced charts and tables.


The course begins with an overview of the certification program and its costs. Next, Jennifer walks you through all of the certification objectives, including hands-on experience with downloadable sample documents. She wraps up with a full-length practice test that emulates exam 77-728, together with solutions to each of the exam challenges.


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

lynda.com/Excel-tutorials/Cert-Prep-Excel-2016-Microsoft-Office-Expert-77-728/518167-2.h