Course Duration: 2 Days

About This Course

This 2-day Instructor Led course How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint 2010.

Audience Profile

Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.

At Course Completion

Explore every aspect of using Microsoft PowerPivot


General Excel and Report building skills


Module 1: Overview

Module 2: PowerPivot Introduction

Module 3: PowerPivot Data Sources

Module 4: PowerPivot Functions

Module 5: Building Reports using PowerPivot

Module 6: PowerPivot for SharePoint 2010