Microsoft Excel: Excel PivotTables & PivotCharts

Microsoft Excel ClassMicrosoft Excel PivotTables and PivotCharts are amazing tools to help you analyze large amounts of data. Instead of wasting valuable time with standard Excel look-up features, PivotTables allow you to do quick, easy grouping, summarizing, and filtering of your data. In addition, the formatting features turn a boring report into a professional one in seconds. PivotTables are a must for anyone who is looking to save time in data analysis.

Our hands-on training will help you master Microsoft Excel PivotTables and PivotCharts, and you will leave our classes confident in creating an advanced PivotTable. Extend your Excel training to be more productive at work and save time by utilizing PivotTables, PivotCharts, and much more.

Class Objective: You will learn all the features of PivotTables and PivotCharts, from basic to advanced.

Target Student: This course is designed for students who desire to analyze large amounts of data using PivotTables and PivotCharts.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • Analyze large amounts of data using PivotTables and PivotCharts
  • Create a basic PivotTable
  • Group and summarize your data in creative ways
  • File and sort your PivotTable
  • Use advanced features of PivotTables
  • Format PivotTables easily
  • Use conditional formatting within PivotTables

Pre-requisite: Microsoft Excel Level 1

Training Type: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.  Available for Private or Group Sessions.

Class Includes:

  • Professional Textbook
  • Download materials with practice examples
  • Free access to CoWorking space on class days (FC Only)
  • One month of technical support
  • One year for a free re-take (for attended students of public classes only)
  • Certificate of Completion

Class Info

  • Classroom equipped with computers and software
  • 6 hours of training
  • Breaks are taken throughout each session
  • Class size limited
  • Target Audience: Advanced

Financial Aid

Click here to learn more about financial aid options including DWC’s 6-month payment plan, WIOA Workforce Funding, and more.

Terms and Conditions

Please read our Terms and Conditions before you register.

Available Classes


Dates/Times InformationONLINE
Mon 7-10-2017
   1:30pm - 4:30pm
Wed 7-12-2017
   1:30pm - 4:30pm

Price: $239.00
Space Available: 15 seat(s)
Course Closing Date: 7-03-2017
Location: Online
Instructor(s): Jonathan Bodell

Dates/Times Information
Mon 7-10-2017
   1:30pm - 4:30pm
Wed 7-12-2017
   1:30pm - 4:30pm

Price: $229.00
Space Available: 15 seat(s)
Course Closing Date: 7-03-2017
Location: Digital Workshop Center - Ft. Collins - View Map
Classroom: Classroom
Instructor(s): Jonathan Bodell

Dates/Times InformationONLINE
Mon 8-07-2017
   9:00am - 12:00pm
Fri 8-11-2017
   9:00am - 12:00pm

Price: $239.00
Space Available: 16 seat(s)
Course Closing Date: 7-31-2017
Location: Online
Instructor(s): Jonathan Bodell

Dates/Times Information
Mon 8-07-2017
   9:00am - 12:00pm
Fri 8-11-2017
   9:00am - 12:00pm

Price: $229.00
Space Available: 16 seat(s)
Course Closing Date: 8-05-2017
Location: Digital Workshop Center - Ft. Collins - View Map
Classroom: Classroom
Instructor(s): Jonathan Bodell
Interested in scheduling a private training session? If the public class schedule above does not meet your availability, please contact us.

Other 1-ON-1 and Group Training Options

Private Class - Contact us for pricing and scheduling

Custom, Hourly Training - Submit a Consulting Request