Overview

Microsoft Excel business person analyzing tables
PDT-ComDP-22

Microsoft Excel: Advanced Pivot Tables

This workshop builds on the basic concepts and skills learned in Microsoft Excel: Level 2 and Microsoft Excel: Level 3, and provides an in-depth look at the usage and capabilities of pivot tables.

Topic covered will include:

  • Managing your data source
  • Ways to summarize data
  • Review of slicers
  • Calculating within a pivot table
  • Custom grouping
  • Introduction to dashboards

All students will receive handouts and sample files to take home with them for continued practice.

Prerequisites: Students should have taken Microsoft Excel: Level 2, or already be familiar with the concepts covered within the workshop.

This class is hands-on. Students must bring a laptop (and mouse) with MS Office 2010, 2013 or 2016 with them to class.  Please ensure that Microsoft Excel is working properly and that your laptop has downloaded and incorporated the latest Windows updates prior to class.  The class will be presented in MS Office 365 on Windows.  Those using a Mac will notice a few differences with course material presented in Windows.

Course Fee: $129.00 tuition (non-credit)

Tools & Materials

PDT-ComDP-22

Microsoft Excel: Advanced Pivot Tables

This class is hands-on. Students must bring a laptop (and mouse) with MS Office 2010, 2013 or 2016 with them to class. Please ensure that Microsoft Excel is working properly and that your laptop has downloaded and incorporated the latest Windows updates prior to class.

All students will receive a workbook to use during class, and to take home with them for continued practice.

Instructor Bios

PDT-ComDP-22

Microsoft Excel: Advanced Pivot Tables

  • Nancy Little

    Nancy has been working as a Microsoft Certified Trainer since 2002.  She has extensive experience in classroom, corporate, custom, and individual trainings with Excel, Word, Access, PowerPoint, and Windows.  Nancy's students describe her as professional, patient, and knowledgeable.

This course is currently unavailable.