Module 1: Using Pivot Tables

• Creating Pivot Tables
• Inserting Slicers
• Working with Pivot Tables
• Inserting Pivot Charts
• More Pivot Table Functionality
• Lab: Using Pivot Tables

Module 2: Auditing Worksheets

• Tracing Precedents
• Tracing Dependents
• Showing Formulas
• Lab: Auditing Worksheets

Module 3: Data Tools

• Converting Text to Columns
• Linking to External Data
• Controlling Calculation Options
• Data Validation
• Consolidating Data
• Goal Seek
• Lab: Data Tools

Module 4: Working with Others

• Protecting Worksheets and Workbooks
• Tracking Changes
• Marking a Workbook as Final
• Lab: Working with Others

Module 5: Recording and Using Macros

• Recording Macros
• Running Macros
• Editing Macros
• Adding Macros to the Quick Access Toolbar
• Lab: Recording and Using Macros

Module 6: Random Useful Items

• Sparklines
• Preparing a Workbook for Internationalization and Accessibility
• Importing and Exporting Files
• Lab: Random Useful Items

Module 7: Microsoft Excel Features that Were New in 2013

• Using Slicers to Filter Data
• Creating a PivotTable Timeline
• Creating a Standalone PivotChart
• Workspaces in Excel 2013
• Lab: Microsoft Excel Features that Were New in 2013

Module 8: Features New in 2016

• PivotTable Updates
• Ink Equations
• Multi-Select Option in Slicers
• Quick Shape Formatting
• Sharing with SharePoint or OneDrive