More Than 250
Developed through years of expertise, CPS HR teaches up-to-date skills applicable on the job.

Excel Pivot Tables


Excel Pivot Tables is a one-day instructor-led course that covers the powerful feature in Excel that enables you to manipulate data with simple dragging and dropping. Pivot tables allow you to sort, filter, group, count, summate, and format data easily and efficiently. Unlike our other Excel courses, this class focuses specifically on Pivot Tables. Students will work heavily on hands-on activities with an instructor to explore the variety of features within Pivot Tables and tackle different scenarios for when to use them.

Appropriate for all levels
  • Excel: Text Functions - How to Clean up Imported Data
  • Excel: Pivot Tables
  • Excel: Pivot Charts
  • Excel: Dashboards
  • Excel: VLOOKUP
  • Excel: IF Functions