PowerPivot for End Users Training

Module 1: Overview

A simple introduction module.

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 the lessons of the module!

Lessons

• PowerPivot Introduction

Lab : 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 the lessons of the module!

Lessons

• Supported Data Sources

Lab : 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 : Cleaning Data

• Cleaning data in PowerPivot

Lab : 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 the lessons of the module!

Lessons

• PowerPivot Expressions

Lab : Create a Time Table

• Create a Time Table for future labs

Lab : 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 : 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 : Using STATISTICAL Functions

• Use AVERAGE* Functions
• Use COUNT* Functions
• Use MAX* and MIN* Functions

Lab : Using VALUE Functions

• Use ALL, ALLEXCEPT and ALLNOBLANKROW
• Use CALCULATE, CALCULATETABLE
• Use DISTINCT
• Use EARLIER and EARLIEST
• Use FILTER
• Use REALTED, RELATEDTABLE
• Use VALUES

Lab : 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 : 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 the lessons of the module!

Lessons

• PowerPivot Reports

Lab : 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 the lessons of the module!

Lessons

• Reports and Email
• PowerPivot for SharePoint 2010

Lab : Installing PowerPivot for SharePoint 2010

• Install PowerPivot for SharePoint 2010
• Configure PowerPivot for SharePoint

Lab : 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