PowerPivot for End Users

Session Detail:    Classroom 2 Day

This 2-day Instructor-led course shows you 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.

Prerequisites

General Excel and Report building skills

Who Can Benefit

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

Session Outline

Class Outline

Module 1: Overview

  • Introduction

After completing this module, students will be able to:

  • Understand your course, classroom, classmates, facility and instructor.

Module 2: PowerPivot Introduction

  • Lesson 1: Excel 2010 Features
  • Lesson 2: PowerPivot Introduction

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

  • Lesson 1: Supported 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

  • Lesson 1: PowerPivot Expressions

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

  • Lesson 1: PowerPivot 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

  • Lesson 1: Reports and Email
  • Lesson 2: 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

Need to train your team?

All of our sessions can be customized to meet your team’s specific needs. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

PowerPivot for End Users

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now