Power Pivot Basics

Course Details


Friday, August 30, 2019

5:30am – 7:00am
(Registration: 5:00am)

Field of Study


Course Number


CPE Credit

2.0 hours CPE credit

Level of Knowledge



CalCPA Education Foundation


Comfortable with traditional PivotTables.


Although traditional PivotTables are incredible, they do have limitations. If you have ever encountered one of these limitations, you’ll be excited to learn that by using Power Pivot, you’ll be able to bypass many of the restrictions that exist with traditional PivotTables.

Power Pivot is included in current versions of Excel for Windows (unavailable in Excel for Mac). Power Pivot enables you to build PivotTables that were previously not practical. In this session, we’ll build PivotTables from multiple tables and create measures.

If you frequently build PivotTables and would like to do more with them, you’ll want to understand how to use Power Pivot to enhance your reports.

Materials are provided as an ebook for this course.


  • Power Pivot
  • Data Model
  • PivotTables
  • Measures
  • Table Relationships
  • Calculated Columns
  • Cube Functions


  • Recall the steps to access the Power Pivot window
  • Identify the process to create table relationships
  • State the procedure for creating measures

Designed For

CPAs, accountants and staff.

Registration for this course has passed.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

Non-Member Fee

Applicable if you are not a HSCPA member.

Your Price $94.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts