PivotTables and PivotCharts in Excel 2010


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
One of the most powerful tools that Excel 2010 provides is a PivotTable that allows you to dynamically reorganize and display your data. PivotTables can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. PivotTables also allow you to choose and change what you want to summarize, quickly and easily. This course will introduce you to PivotTables and show you the many benefits they provide.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
1.0

Lesson Objectives

PivotTables and PivotCharts in Excel 2010

  • create a PivotTable report
  • rearranging data in PivotTable reports
  • customize PivotTable reports
  • modify a PivotTable report's design
  • create a PivotChart
  • modify a PivotChart report
  • create a PivotTable report
  • customize a PivotTable report
  • create a PivotChart report
  • Course Number:
    mo_aexl_a07_dt_enus

    Expertise Level
    Intermediate