Module 1: Using Pivot Tables
- Creating Pivot Tables
- Inserting Slicers
- Working with Pivot Tables
- Inserting Pivot Charts
- More Pivot Table Functionality
Module 2: Auditing Worksheets
- Tracing Precedents
- Tracing Dependents
- Showing Formulas
Mobile 3: Data Tools
- Converting Text to Columns
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Consolidating Data
- Goal Seek
Module 4: Working with Others
- Protecting Worksheets and Workbooks
- Tracking Changes
- Marking a Workbook as Final
Mobile 5: Recording and Using Macros
- Recording Macros
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
Module 6: Random Useful Items
- Sparklines
- Preparing a Workbook for Internationalization and Accessibility
- Importing and Exporting Files
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
Module 8: Features New in 2016
- PivotTable Updates
- Ink Equations
- Multi-Select Option in Slicers
- Quick Shape Formatting
- Sharing with SharePoint or OneDrive