PivotTables: Build, manipulate and chart data
Printer friendly

Course Overview
   In this course you will learn to understand, build, manipulate and chart data using PivotTables. It is common place in many business roles to be able to effectively and efficiently move through large amounts of data. This can be a cumbersome and intimidating process. However, with the use of PivotTables, this task becomes much more manageable. On top of being able to maneuver within data, you will also be able to manipulate, sort, filter and create calculations to gain insight into your data that previously wasn't as obvious.

This course is suited for those using Office 2007 or Office 2003. This course will be taught using MS Office Excel 2007.
Objectives
  Upon successful completion of this course, students will be able to:
  • Build and Manipulate PivotTables
  • Sort, Filter, and Group Data
  • Create Calculations
  • Build a PivotChart
  • Avoid PivotTable Problems

    • Audience
      This course is designed for people who are looking to be able to more effectively and efficiently work with their Excel data.

    Prerequisites
      Prior to starting this course, students are recommended to take Excel Level 1 or possess equivalent knowledge.
    Course Number
      NHEUEXCPivTbl
    Course Length
      1 Half Day
    Course Price
      $195.00
    Category
      2
    Topics
       Lesson 1: What is a Pivot Table?
    Lesson 2: PivotTable Pit Falls
    Lesson 3: Pivot the PivotTable
    Lesson 4: Group by Weeks
    Lesson 5: Group by Time Period
    Lesson 6: Drill Down to View Raw Data Behind PivotTable
    Lesson 7: Use the Page Field to Separate Data on Individual Sheets
    Lesson 8: Modify Summary Information
    Lesson 9: Add an Additional Summary Field
    Lesson 10: Calculate Percent Difference From
    Lesson 11: Use a Calculation/Formula on the PivotTable
    Lesson 12: Hide Subtotals
    Appendix: The PivotTable Options Dialog Box