Contact Us
We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

2 Days

(Online and onsite)

Price Upon Request
- Explore every aspect of using Microsoft PowerPivot
Module 1: Overview
A simple introduction module.
Lessons
- None
Lab 1: None
- None
After completing this module, students will be able to:
- Understand your course, classroom, classmates, facility and instructor.
Module 2: PowerPivot Introduction
In this module we take a look at an introductory view of PowerPivot.
Lessons
- Excel 2010 Features
- PowerPivot Introduction
Lab 1: Installing PowerPivot
- Install PowerPivot for Excel
After completing this module, students will be able to:
- Install PowerPivot for Excel
- Be able to navigate the PowerPivot windows
- Understand the new features of Excel 2010
Module 3: PowerPivot Data Sources
In this module we take a look at all the possible data sources of which PowerPivot can work with!
Lessons
- Supported Data Sources
Lab 1: Loading Data Sources
- Load Data From SQL Server
- Load Data From Text Files
- Load Data via Copy and Paste
- Load Data via Data Feeds
- Load Data via Reporting Services
Lab 2: Cleaning Data
- Cleaning data in PowerPivot
Lab 3: Creating Relationships
- Create Relationship between Data Sources
After completing this module, students will be able to:
- Import various data sources into PowerPivot
- Understand how to clean imported data
Module 4: PowerPivot Functions
In this module we take a look at PowerPivot Functions/DAX Expressions and how to use them!
Lessons
- PowerPivot Expressions
Lab 1: Create a Time Table
- Create a Time Table for future labs
Lab 2: Using DATE Functions
- Use DATE Function
- Use DATEVALUE Function
- Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions
- Use EDATE Function
- Use EOMONTH Function
- Use NOW and TODAY Functions
- Use TIME and TIMEVALUE Functions
- Use WEEKDAY and WEEKNUM Functions
Lab 3: Using TIME INTELLIGENCE Functions
- Use FIRST* and LAST* Functions
- Use DATE* Functions
- Use STARTOF* and ENDOF* Functions
- Use CLOSING* and OPENING* Functions
- Use LASTOF* and FIRST* Functions
- Use PREVIOUS* and NEXT* Functions
Lab 4: Using STATISTICAL Functions
- Use AVERAGE* Functions
- Use COUNT* Functions
- Use MAX* and MIN* Functions
Lab 5: Using FILTER Functions
- Use ALL, ALLEXCEPT and ALLNOBLANKROW
- Use CALCULATE, CALCULATETABLE
- Use DISTINCT and VALUES
- Use EARLIER and EARLIEST
- Use FILTER
- Use RELATED
Lab 6: Using LOGICAL and INFORMATION Functions
- Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
- Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
Lab 7: Using TEXT Functions
- Use TEXT Functions
After completing this module, students will be able to:
- Be able to describe all the new PowerPivot Expressions
- Use and apply many of the PowerPivot Expressions
Module 5: Building Reports using PowerPivot
In this module we take a look at building reports using PowerPivot.
Lessons
- PowerPivot Reports
Lab 1: Creating Reports
- Use PivotCharts
- Use Slicers
- Use Sparklines
After completing this module, students will be able to:
- Describe the different Report types in PowerPivot
- Be able to create Slicers and Sparklines for more engaging reports
Module 6: PowerPivot for SharePoint 2010
In this module we take a look at PowerPivot for SharePoint 2010.
Lessons
- Reports and Email
- PowerPivot for SharePoint 2010
Lab 1: Installing PowerPivot for SharePoint 2010
- Install PowerPivot for SharePoint 2010
- Configure PowerPivot for SharePoint
Lab 2: Configuring PowerPivot For SharePoint 2010
- Publish to SharePoint 2010
- Configure PowerPivot for SharePoint 2010
After completing this module, students will be able to:
- Describe the integration points between PowerPivot and SharePoint 2010
- Be able to publish and setup workbook data refresh in SharePoint 2010
Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.
- General Excel and Report building skills
- Explore every aspect of using Microsoft PowerPivot
Module 1: Overview
A simple introduction module.
Lessons
- None
Lab 1: None
- None
After completing this module, students will be able to:
- Understand your course, classroom, classmates, facility and instructor.
Module 2: PowerPivot Introduction
In this module we take a look at an introductory view of PowerPivot.
Lessons
- Excel 2010 Features
- PowerPivot Introduction
Lab 1: Installing PowerPivot
- Install PowerPivot for Excel
After completing this module, students will be able to:
- Install PowerPivot for Excel
- Be able to navigate the PowerPivot windows
- Understand the new features of Excel 2010
Module 3: PowerPivot Data Sources
In this module we take a look at all the possible data sources of which PowerPivot can work with!
Lessons
- Supported Data Sources
Lab 1: Loading Data Sources
- Load Data From SQL Server
- Load Data From Text Files
- Load Data via Copy and Paste
- Load Data via Data Feeds
- Load Data via Reporting Services
Lab 2: Cleaning Data
- Cleaning data in PowerPivot
Lab 3: Creating Relationships
- Create Relationship between Data Sources
After completing this module, students will be able to:
- Import various data sources into PowerPivot
- Understand how to clean imported data
Module 4: PowerPivot Functions
In this module we take a look at PowerPivot Functions/DAX Expressions and how to use them!
Lessons
- PowerPivot Expressions
Lab 1: Create a Time Table
- Create a Time Table for future labs
Lab 2: Using DATE Functions
- Use DATE Function
- Use DATEVALUE Function
- Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions
- Use EDATE Function
- Use EOMONTH Function
- Use NOW and TODAY Functions
- Use TIME and TIMEVALUE Functions
- Use WEEKDAY and WEEKNUM Functions
Lab 3: Using TIME INTELLIGENCE Functions
- Use FIRST* and LAST* Functions
- Use DATE* Functions
- Use STARTOF* and ENDOF* Functions
- Use CLOSING* and OPENING* Functions
- Use LASTOF* and FIRST* Functions
- Use PREVIOUS* and NEXT* Functions
Lab 4: Using STATISTICAL Functions
- Use AVERAGE* Functions
- Use COUNT* Functions
- Use MAX* and MIN* Functions
Lab 5: Using FILTER Functions
- Use ALL, ALLEXCEPT and ALLNOBLANKROW
- Use CALCULATE, CALCULATETABLE
- Use DISTINCT and VALUES
- Use EARLIER and EARLIEST
- Use FILTER
- Use RELATED
Lab 6: Using LOGICAL and INFORMATION Functions
- Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
- Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
Lab 7: Using TEXT Functions
- Use TEXT Functions
After completing this module, students will be able to:
- Be able to describe all the new PowerPivot Expressions
- Use and apply many of the PowerPivot Expressions
Module 5: Building Reports using PowerPivot
In this module we take a look at building reports using PowerPivot.
Lessons
- PowerPivot Reports
Lab 1: Creating Reports
- Use PivotCharts
- Use Slicers
- Use Sparklines
After completing this module, students will be able to:
- Describe the different Report types in PowerPivot
- Be able to create Slicers and Sparklines for more engaging reports
Module 6: PowerPivot for SharePoint 2010
In this module we take a look at PowerPivot for SharePoint 2010.
Lessons
- Reports and Email
- PowerPivot for SharePoint 2010
Lab 1: Installing PowerPivot for SharePoint 2010
- Install PowerPivot for SharePoint 2010
- Configure PowerPivot for SharePoint
Lab 2: Configuring PowerPivot For SharePoint 2010
- Publish to SharePoint 2010
- Configure PowerPivot for SharePoint 2010
After completing this module, students will be able to:
- Describe the integration points between PowerPivot and SharePoint 2010
- Be able to publish and setup workbook data refresh in SharePoint 2010
Advanced Excel users, users that want to gain familiarity with PowerPivot to build compelling reports.
- General Excel and Report building skills