PowerPivot for End Users

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

In this module we take a look at the lessons of the module!

Supported 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

Cleaning data in PowerPivot

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

In this module we take a look at the lessons of the module!

PowerPivot Expressions

Create a Time Table for future labs

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

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

Use AVERAGE* Functions

Use COUNT* Functions

Use MAX* and MIN* Functions

Use ALL, ALLEXCEPT and ALLNOBLANKROW

Use CALCULATE, CALCULATETABLE

Use DISTINCT

Use EARLIER and EARLIEST

Use FILTER

Use REALTED, RELATEDTABLE

Use VALUES

Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)

Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)

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

In this module we take a look at the lessons of the module!

PowerPivot 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

In this module we take a look at the lessons of the module!

Reports and Email

PowerPivot for SharePoint 2010

Install PowerPivot for SharePoint 2010

Configure PowerPivot for SharePoint

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