Microsoft® Excel: Data Tables & PivotTables Featuring PowerPivot

Click Here For More Information

Course Description:

This hands-on course is ideal for professionals with a working knowledge of Excel who are ready to take their data analysis skills to the next level.

In the first half, participants will reinforce foundational skills in working with Excel data lists and tables, including sorting, filtering, and subtotaling. Building on these essentials, the course introduces PivotTables—starting with basic, one-dimensional designs and progressing to multi-dimensional PivotTables enhanced by filters, slicers, and Pivot Charts.

The second half focuses on PowerPivot, a powerful Excel Add-In that extends the capabilities of traditional PivotTables. Participants will learn to perform advanced calculations, group and manage large data sets efficiently, and connect to external data sources to create robust, scalable reports.


Course Highlights:

  • Identify and structure Excel data lists

  • Perform basic and complex sorting techniques

  • Apply filters and subtotal functions to analyze data

  • Convert standard data lists into Excel Tables

  • Create and customize one-dimensional and multi-dimensional PivotTables

  • Reorganize PivotTable data for dynamic views

  • Use filters and slicers to enhance interactivity

  • Develop visually engaging Pivot Charts

  • Utilize PowerPivot for:

    • Advanced calculations

    • Grouping and summarizing large data sets

    • Connecting to external data sources

    • Designing and distributing professional-level reports

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: www.nasbaregistry.org.


Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22

Course Information
  • Prerequisite:Excel Intermediate or equivalent knowledge
  • Credit:CPE 8 Hours
  • Fee:$299
  • Length:1 day
  • Hours:8:30 a.m. - 4:15 p.m.
  • Delivery:Virtual Group Live
  • Recommend Field of StudyComputer Applications
  • Program Knowledge LevelAdvanced
  • Advanced PreparationNone
  • 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 info@knowledgesourceinc.com or by calling 919-878-7100. Refunds will be issued within 30 days after the course.

Related Courses