Microsoft Excel 2010 PowerPivot

2 Day Course
Code QAEX10PP

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite

Overview

This course takes PivotTables to the next level, teaching you how to use PowerPivot: a free add-in available only for Microsoft Excel 2010. PowerPivot links in with PivotTables, however the data used, can be manipulated and managed as though you were using a Relational Database (such as SQL or Access). This course is designed for intermediate/advanced Microsoft Excel professionals who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation. They will have a need to create PivotTables on a regular basis and to produce reports with multiple PivotTables/PivotCharts to produce 'Business Intelligent' type dashboard reports

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Module 1 - Introduction and Welcome

Module 2 - PivotTable Review (4 topics)

  • Why Use a PivotTable?
  • PivotTable Hints and Tips
  • Connecting to External Data with PivotTables

Module 3 - Introduction to PowerPivot (4 topics)

  • PowerPivot Overview
  • Where do I get PowerPivot from?
  • Identifying PowerPivot

Module 4 - Connecting to Single Table Data Sources (6 topics)

  • Connecting to Data Different Sources
  • Pasting data into PowerPivot
  • Checking PowerPivot can Produce Results
  • Excel (flat-file database) as a Data Source
  • Importing Data from SharePoint Lists to PowerPivot

Module 5 - Working with Multiple Table Data Sources (8 topics)

  • Excel (linked tables) as a Data Source
  • PowerPivot Relationships
  • Access Tables (relational database) as a Data Source
  • SQL Databases as a Data Source
  • Creating a Perspective to make Field Lists Manageable
  • Filtering Data during Importing External Data
  • Database Tables as a Data Source Writing SQL Statements

Module 6 - The Diagram View (4 topics)

  • The Diagram View in PowerPivot
  • Managing Relationships and Tables in the Diagram View
  • Working with Hierarchies

Module 7 - Measures, Calculations and KPIs (9 topics)

  • Measures Overview
  • Create a Calculated Column
  • Creating a Measure
  • AutoSum Measures
  • User Created Measures
  • Working with Dates in a PowerPivot Environment
  • Creating a KPI
  • Adding a KPI to a PivotTable

Module 8 - Working with DAX (Data Analysis Expressions (4 topics)

  • Sample DAX Functions
  • Writing DAX Functions
  • Time Intelligent Functions

Module 9 - Working with Slicers (5 topics)

  • Layout Styles
  • Using Slicers
  • Additional Slicer Settings
  • Locking a Slicer to a PivotTable

Prerequisites

Before attending this course, students need to be able to: Demonstrate a good working knowledge of Microsoft Windows Demonstrate a good working knowledge of Microsoft Excel 2010 Demonstrate a basic knowledge of Database Relationships (if relevant to your work) Understand formula/function writing to manipulate data Understand basic features of PivotTables, such as the areas designed for fields

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections