Description

Target Audience

Objectives

After completing this course, students will be able to:

• Understand the benefits of PivotTable Reports.
• Convert raw data in an Excel worksheet into meaningful PivotTables and PivotCharts.
• Manipulate the PivotTable layout.
• Use grouping.
• Create custom calculations.
• Use formulas and create formulas outside of a report.
• Create a PivotChart and publish it to a Web site.

Outline

• Lesson 1: Make Your Data Work for You
  • Maximize the Power of PivotTable
  • Ask the Questions
  • Get the Answers
  • Review
• Lesson 2: A Quick Tour
  • Determine What You Need to Know
  • The Source is Important
  • Ready, Set, Go
  • The PivotTable Layout
  • What Goes Where
  • Result of Our PivotTable
  • Viewing Our Data Differently
• Lesson 3: Manipulating the PivotTable
  • Rearrange the Layout
  • What We Get
  • Add a New Field
  • Remove a Field
  • Add or Remove a Field Using the Wizard
  • Rename a Field
  • Format Numbers
  • Change the Sort Order and Top 10 AutoShow
  • Refresh Data
• Lesson 4: Digging Deeper
  • Create a Quarterly Group
  • Group Data Manually
  • Display Subtotals
  • Hide/Display Grand Total
  • Format a PivotTable Report
• Lesson 5: Beyond the Basics
  • Creating a Second Data Field
  • Use Count to Summarize Data
  • Display Numerical Data as a Percentage of the Total
  • Create a Custom Calculation
  • More Functions in Custom Calculation
• Lesson 6: More PivotTable Calculations
  • Using Formulas
  • Create a Calculated Field
  • Create a Calculated Item
  • Use PivotTable Data Outside the Report
  • Use the GETPIVOTDATA Function
  • Turn Off the GETPIVOTDATA Function
• Lesson 7: Optional Topics
  • Create a PivotChart Report
  • Publish PivotTable Reports to the Web
  • Add Fields to a PivotTable Browser
  • Use a PivotTable List
  • Use Multiple Ranges as Source Data