Course 50433B: PowerPivot for End Users

Type: Course
Audience(s):information workers
Technology:Excel
Level:300
This Revision:B
Delivery method:
Instructor-led (classroom)
Length:2 days
Language(s):English

First published:

30 March 2012
Overview
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
After completing this course, students will be able to:
  • Explore every aspect of using Microsoft PowerPivot
Course details
Course OutlineModule 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
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 SourcesLab : Cleaning DataLab : Creating Relationships
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 TableLab : Using DATE FunctionsLab : Using TIME INTELLIGENCE FunctionsLab : Using STATISTICAL FunctionsLab : Using VALUE FunctionsLab : Using LOGICAL and INFORMATION FunctionsLab : Using 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
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 2010Lab : Configuring 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
Prerequisites
Before attending this course, students must have:
  • General Excel and Report building skills
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you