How much does Microsoft Excel Power Pivot cost?

$595 per seat. That covers courseware and lab access. Exam vouchers are quoted separately. Volume pricing is available for teams, and a private cohort is usually cheaper per seat past about four people.

How long is Microsoft Excel Power Pivot?

1 day of instructor-led training, delivered live online. Classes run during business hours in the timezone shown on each date.

When is the next Microsoft Excel Power Pivot class?

The next scheduled date is Mon, Nov 23. There is 1 upcoming date in total.

Is Microsoft Excel Power Pivot delivered online?

Yes. It runs live online with an instructor, not as a recording, so you can ask questions as you go. It can also be delivered privately at your site.

Can a government agency buy Microsoft Excel Power Pivot?

Yes. Purchase orders and government purchase cards are both accepted at checkout, and quotes can be formatted for a solicitation response. Terms are net 30 on invoiced orders.

What happens if I need to cancel Microsoft Excel Power Pivot?

Course fees are fully refundable with written notice at least ten business days before the class. Inside that window the fee is forfeited, though one free retake is available within six months of the class date.

ISI-1554 Microsoft Excel Power Pivot | 1-day class

Upcoming dates

All times shown in the class's own timezone. Dates we teach ourselves run once 1 people are booked, so a pair of seats confirms one.

Dates	Starts	Where	Status	Seat	Book
Mon, Nov 23	9:00 AM to 4:00 PM PST Taught by us	Live virtual	RUNS WITH 1+	$595

About this class

We have 1 scheduled date of Microsoft Excel Power Pivot, starting Mon, Nov 23. We teach this one ourselves, with our own instructors and courseware. Seats are $595 each over 1 day, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.

Which Microsoft Excel Course should I take?

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

Course outline

Module 1 The Power Pivot Data Model

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

Module 2 Relationships Between Tables

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

Module 3 Shaping the Data Model with Data Analysis

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

Module 4 Time Intelligence

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

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