Excel 2010: PivotTables & PivotCharts


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.



Expected Duration (hours)
1.0

Lesson Objectives

Excel 2010: PivotTables & PivotCharts

  • Creating a PivotTable
  • Editing your PivotTable
  • Formatting your PivotTable
  • Comparing values in a PivotTable
  • Copying & reusing your PivotTable
  • Inserting a calculation in your PivotTable
  • Sorting data in your PivotTable
  • Filtering your PivotTable data
  • Grouping data in your PivotTable
  • Inserting a slicer
  • Customizing a slicer
  • Inserting a PivotChart
  • Modifying your PivotChart
  • Analyzing your database tables in a PivotChart
  • Course Number:
    ds_msex2010_12_enus

    Expertise Level
    Intermediate