Arrow Electronics, Inc.

PowerPivot for End Users

CODE: EDUMS-50433

LENGTH: 2 days

PRICE: $990.00

Description

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.

Objectives

After completing this course, students will be able to:
Explore every aspect of using Microsoft PowerPivot

Audience

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

Prerequisites

Before attending this course, students must have:
General Excel and Report building skills

Programme

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
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
Lab : Cleaning Data
Lab : 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 Table
Lab : Using DATE Functions
Lab : Using TIME INTELLIGENCE Functions
Lab : Using STATISTICAL Functions
Lab : Using VALUE Functions
Lab : Using LOGICAL and INFORMATION Functions
Lab : 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 2010
Lab : 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

Session Dates