Module 1: Using Pivot Tables
This module explains how to use Pivot Tables.
- Lessons:
- Creating Pivot Tables
- Inserting Slicers
- Working with Pivot Tables
- Inserting Pivot Charts
- More Pivot Table Functionality
- Lab : Using Pivot Tables
- Working with Pivot Tables
Module 2: Auditing Worksheets
This module explains how to audit worksheets.
- Lessons:
- Tracing Precedents
- Tracing Dependents
- Showing Formulas
- Lab : Auditing Worksheets
- Tracing Precedents
- Tracing Dependents
Module 3: Data Tools
This module explains how to work with data tools.
- Lessons:
- Converting Text to Columns
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Consolidating Data
- Goal Seek
- Lab : Data Tools
- Converting Text to Columns
- Using Data Validation
- Consolidating Data
- Using Goal Seek
Module 4: Working with Others
This module explains how to do various tasks associated with working with others in Excel.
- Lessons:
- Protecting Worksheets and Workbooks
- Tracking Changes
- Marking a Workbook as Final
- Lab : Working with Others
- Password Protecting a Workbook
- Password Protecting a Worksheet
- Password Protecting Ranges in a Worksheet
- Tracking Changes
Module 5: Recording and Using Macros
This module explains how to record and use macros.
- Lessons:
- Recording Macros
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
- Lab : Recording and Using Macros
- Recording a Macro
- Adding a Macro to the Quick Access Toolbar
Module 6: Random Useful Items
This module explains how to do some random useful tasks in Excel.
- Lessons:
- Spark lines
- Preparing a Workbook for Internationalization and Accessibility
- Importing and Exporting Files
- Lab : Random Useful Items
- Inserting and Customizing Spark lines
- Importing Text Files
- Copying Data from Excel to Word
- Copying Charts from Excel to Word
Module 7: Microsoft Excel Features that Were New in 2013
This module explains how to use some new features that were new in 2013.
- Lessons:
- Using Slicers to Filter Data
- Creating a Pivot Table Timeline
- Creating a Standalone Pivot Chart
- Work spaces in Excel 2013
- Lab : Microsoft Excel Features that Were New in 2013
- Filtering Data with Slicers
- Creating a Timeline
Module 8: Features New in 2016
This module explains how to some new features new in 2016.
- Lessons:
- Pivot Table Updates
- Ink Equations
- Multi-Select Option in Slicers
- Quick Shape Formatting
- Sharing with SharePoint or One Drive
