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

Excel Pivot Tables

1-DAY COURSE

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.

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