MOS 2016 Study Guide for Microsoft Excel Expert

Chapter 1 - Manage and share workbooks
1.1 Manage workbooks
1.2 Manage workbook review
Chapter 2 - Apply custom formats and layouts
2.1 Apply custom data formats
2.2 Apply advanced conditional formatting and filtering
2.3 Apply custom styles and templates
2.4 Prepare workbooks for internationalization and accessibility
Chapter 3 - Create advanced formulas
3.1 Apply functions in formulas
3.2 Look up data by using functions
3.3 Apply advanced date and time functions
3.4 Perform data analysis and business intelligence
3.5 Troubleshoot formulas
3.6 Define named ranges and objects
Chapter 4 - Create advanced charts and tables
4.1 Create advanced chart elements
4.2 Create and manage PivotTables
4.3 Create and manage PivotCharts