Microsoft

Microsoft Excel Power Pivot ISI-1554

Not sure this is the right class? Read What Microsoft Excel Class Should I Take?

  • 1 day
  • 1 upcoming date 1 open for booking
  • $595 per seat

Upcoming dates

Dates Where Status Seat Book
Nov 23 2026 Live Online 9:00 AM to 4:00 PM PT Confirmed to run $595

See every class on the schedule

About this class

Power Pivot for Excel is an add-in that you can use to perform powerful data analysis in Excel, bringing self-service business intelligence to your desktop. This one-day, instructor-led course is intended for all business professionals including IT professionals, developers, managers, project leads, project managers, and team leads, who have not used Power Pivot before. It is ideal for analyzing data, especially when it comes from multiple data sources or is very large. It even makes better PivotTables and Pivot Charts.

This course gets you up and running with Power Pivot by teaching you the basics relatively quickly, so that you can import data and create pivot tables and charts for decision making purposes. You will learn how to link data tables, create summary pivot tables and make the data displayed in a pivot table interactive by adding filters, slicers and timelines.

What you'll be able to do

  • Use the Table Import Wizard
  • Import data into the data model
  • Create relationships
  • Use slicers
  • Create pivot tables, pivot charts
  • Create KPI’s and hierarchies
  • Applying conditional formatting
  • Add sparklines to a pivot table

Before you attend

Students should be familiar with using personal computers and Have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take the following courses or have equivalent knowledge:

  • Microsoft Excel Levels 1, 2 and 3

Course outline

  1. Module 1The Power Pivot Data Model

    • Adding the Power Pivot Add-In
    • Connecting to data sources
    • Using an Access database
    • Using an Excel workbook

  2. Module 2Relationships Between Tables

    • Viewing existing relationships
    • Creating relationships
    • Creating a column hierarchy
    • Creating a Pivot Table with a hierarchy

  3. Module 3Shaping the Data Model with Data Analysis Expressions (DAX)

    • Building calculated columns
    • Measures (calculated fields)
    • DAX functions
    • Related() Functions
    • Count() Functions
    • DistinctCount Functions ()
    • Month()( Functions
    • Year() Functions
    • Date() Function
    • Calculate() Function
    • All()( Functions

  4. Module 4Time Intelligence

    • Creating a date table
    • Relating a date table to the data model
    • Build time-intelligence functions

Download the full outline (PDF)

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More desktop applications classes

See all