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

After completing this module, students will be able to:

• Use pivot tables to analyze data.
• Edit pivot tables.
• Format pivot tables.
• Insert pivot charts.
• Use Slicers.

Auditing Worksheets

This module explains how to audit worksheets.

Lessons

• Tracing Precedents
• Tracing Dependents
• Showing Formulas

Lab : Auditing Worksheets

• Tracing Precedents
• Tracing Dependents

After completing this module, students will be able to:

• Audit formulas.
• Trace precedents to determine which cells impact a specific cell.
• Trace dependents to determine which cells are impacted by a specific cell.
• Remove precedent and dependent arrows.
• Show formulas.
• Check for errors frequently found in formulas.

Auditing Worksheets

This module explains how to audit worksheets.

Lessons

• Tracing Precedents
• Tracing Dependents
• Showing Formulas

Lab : Auditing Worksheets

• Tracing Precedents
• Tracing Dependents

After completing this module, students will be able to:

• Audit formulas.
• Trace precedents to determine which cells impact a specific cell.
• Trace dependents to determine which cells are impacted by a specific cell.
• Remove precedent and dependent arrows.
• Show formulas.
• Check for errors frequently found in formulas.

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

After completing this module, students will be able to:

• Convert text to columns.
• Use Data Validation to restrict the type of data that can be entered into a cell.
• Consolidate data from a number of different ranges into one new range.
• Use Goal Seek to figure out the value to input to obtain a specific result.