You are now in the main content area

Excel Pivot Tables

Date: Thursday, March 19, 2020 at 9 a.m. to 12 p.m.
Location: KHW 177B
Registration: Registration is closed.
Cost: Free
No Show Fee: $50
Manager Approval: Required

This is an Intermediate to Advanced level course that focuses solely on working with PivotTables and Pivot Charts. It is very useful for anyone who has to manage large sets of data.

  • Create a Pivot Table
  • Using Tables for Creating Pivot Table
  • Adding & Removing Fields
  • Rearrange Data
  • Grand Totals
  • Report Layout
  • Pivot Table Options
  • Field Settings
  • Calculated Field
  • Change Data Source of a Pivot Table
  • Grouping Data
  • Field Calculations
  • Sort Pivot Table Data
  • Top 10 Filter
  • Hiding Data
  • Display Data Details
  • Refresh Pivot Table
  • Building a PivotChart