Microsoft® Excel PivotTables

Microsoft® Excel PivotTables will demonstrate to the Excel user how to create and use list and table data to create analytical Pivot Tables. This will include an exploration of both one and two-dimensional Pivot Tables, feature data filtering and slicers, as well as creating Pivot Charts. The user will also be exposed to using external data for Pivot analysis.

Objective: Upon completion of this course the advanced Excel user will be able to create and modify Pivot Tables and Charts where advanced filtering techniques are featured.

  • Creating Pivot Tables
    1. One-dimensional
    2. Two-dimensional
    3. Refreshing data
  • Filtering Pivot Table data
    1. Filtering Pivot data fields
    2. The Filter Section
    3. Using Slicers
  • Grouping Data Fields
    1. Creating date ranges
    2. Creating numeric pocket ranges
  • Pivot Charts
    1. Stacked Column Charts
    2. Pie Charts
    3. Data filtration
  • Using External Data
    1. Importing data from a database file
    2. Creating a Pivot Table from an external source

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Course Information
  • Course Level:Intermediate
  • Prerequisite:Excel Basic Formulas and Excel Charts or equivalent knowledge
  • Credit:2 CPE Hours
  • Fee:$99
  • Delivery:Virtual Instructor-Led Live/Group Internet-Based
  • Recommend Field of StudyComputer Software and Applications
  • Program Knowledge LevelIntermediate
  • Advanced PreparationDownload and install class files a minimum of 2 working days prior to class.
  • Refund PolicyRequests for cancellations must be submitted in writing and received by Knowledge Source Inc. five (5) days prior to the date of the event to receive a full refund (less a 10% processing fee). Refunds are not given for no-shows. Special circumstances and cancellation requests may be emailed to or by calling 919-878-7100. Refunds will be issued within 30 days after the course.

Related Courses