Excel Pivot Tables

Class length: 1 day
Hours: 10:00 am - 5:30 pm
Cost: $350



Xpress Workout: Excel Pivot tables

Course Description:

Next Scheduled Class:

Click here to request a
specific date for this class.

Onsite Training:

This class is available for
onsite training
. For more
information or to book
an onsite class, please
click here.

The objective of this Workout is to learn how to use Microsoft Excel's powerful PivotTable feature
to analyze and summarize large amounts of data from a data source.

 

Workout Outline:

 

  • What is a PivotTable?
  • Creating a PivotTable
  • Pivoting a PivotTable
  • Refreshing a PivotTable
  • Selecting elements of a PivotTable
  • Formatting a PivotTable
  • Using multiple data fields
  • Renaming Fields and Items
  • Sorting Items
  • Showing the top or bottom Items in a Field
  • Hiding and showing Inner Field Items
  • Displaying the details behind a data value
  • Grouping and ungrouping data
  • Using grand totals and subtotals
  • Changing a PivotTable's calculation
  • Creating a PivotTable from external data