Working with PivotTables

Creating a PivotTable

Specifying PivotTable Data

Changing a PivotTable’s Calculation

Filtering and Sorting a PivotTable

Working with PivotTable Layout

Grouping PivotTable Items

Updating a PivotTable

Formatting a PivotTable

Creating a PivotChart

Using Slicers

Sharing Slicers Between PivotTables

Analyzing Data

Creating Scenarios

Creating a Scenario Report

Working with Data Tables

Using Goal Seek

Using Solver

Using Text to Columns

Grouping and Outlining Data

Using Subtotals

Consolidating Data by Position or Category

Consolidating Data Using Formulas

Working with the Web and External Data

Inserting a Hyperlink

Importing Data from an Access Database or Text File

Importing Data from the Web and Other Sources

Working with Existing Data Connections

Working with Macros

Recording a Macro

Playing and Deleting a Macro

Adding a Macro to the Quick Access Toolbar

Editing a Macro’s Visual Basic Code

Inserting Copied Code in a Macro

Declaring Variables and Adding Remarks to VBA Code

Prompting for User Input

Using the If…Then…Else Statement

Customizing Excel

Customizing the Ribbon

Customizing the Quick Access Toolbar

Using and Customizing AutoCorrect

Changing Excel’s Default Options

Creating a Custom AutoFill List

Creating a Custom Number Format