Power Pivot Basics

Course Details

Date

Friday, August 30, 2019

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

Field of Study

Technology

Course Number

4193799B

CPE Credit

2.0 hours CPE credit

Level of Knowledge

Intermediate

Vendor

CalCPA Education Foundation

Prerequisites

Comfortable with traditional PivotTables.

Description

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.

Highlights

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

Objectives

  • 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.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$60.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$94.00
Your Price $94.00

CPE Choice

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

View All Webcasts