Module 1: Data Analysis

This module explains how to define alternative data sets, use Goal Seek and Solver, and analyze descriptive statistics.

Lessons

• Defining an Alternative Data Set
• Defining Multiple Alternative Data Sets
• Varying Your Data to Get a Desired Result by Using Goal Seek
• Finding Optimal Solutions by Using Solver
• Analyzing Data by Using Descriptive Statistics

Lab: Data Analysis

• Create a scenario to measure the impact of a rate increase.
• Create and summarize the results of two scenarios.
• Use Goal Seek to find a target value.
• Use Solver to determine the best values for multiple variables, given specific constraints.
• Generate descriptive statistics by using the Analysis ToolPak.

After completing this module, students will be able to:

Module 2: PivotTables and PivotCharts

This module explains how to work with PivotTables and PivotCharts.

Lessons

• Analyzing Data Dynamically by Using PivotTables
• Filtering, Showing, and Hiding PivotTable Data
• Editing PivotTables
• Formatting PivotTables
• Creating PivotTables from External Data
• Creating Dynamic Charts by Using PivotCharts

Lab: PivotTables and PivotCharts

• Create a PivotTable, add fields, and then pivot it.
• Filter a PivotTable, and show and hide levels of detail.
• Rename and edit a PivotTable, and then link to a PivotTable cell.
• Apply a number format, styles, banded rows, and a conditional format to a PivotTable.
• Use an imported text file as the basis for a PivotTable.
• Create, modify, and update a PivotChart.

After completing this module, students will be able to:

Module 3: Macros

This module explains how to create and run macros.

Lessons

• Introducing Macros
• Creating and Modifying Macros
• Running Macros When a Button Is Clicked
• Running Macros When a Workbook Is Opened

Lab: Macros

• Examine, step through, and run a macro.
• Record, save, and run a macro.
• Run macros from the Quick Access Toolbar and by clicking a workbook shape.
• Run a macro when someone opens a workbook.

After completing this module, students will be able to:

Module 4: Office Document Recycling

This module explains how to use Office documents in Excel workbooks and how to use Excel data in other Office programs.

Lessons

• Including Office Documents in Worksheets
• Storing Workbooks as Parts of Other Office Documents
• Creating Hyperlinks
• Pasting Charts into Other Documents

Lab: Office Document Recycling

• Link a presentation to a workbook, and edit the presentation.
• Embed a workbook in a presentation, and change the formatting of the workbook.
• Create two hyperlinks to different locations.
• Copy and paste a chart into a presentation.

After completing this module, students will be able to:

Module 5: Collaboration

This module explains how to collaborate on Excel files by sharing files, managing comments and changes, password-protect workbooks and worksheets, use digital signatures, save and publish Excel data.

Lessons

• Sharing Data Lists
• Managing Comments
• Tracking and Managing Colleagues