Microsoft Excel 2010 PowerPivot

2 Day Course
Code QAEX10PP

This course has been retired. Please view currently available Business Development Training Courses.

Modules

Hide all

Module 1 - Introduction and Welcome

Module 2 - PivotTable Review (3 topics)

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

Module 3 - Introduction to PowerPivot (3 topics)

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

Module 4 - Connecting to Single Table Data Sources (5 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 (7 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 (3 topics)

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

Module 7 - Measures, Calculations and KPIs (8 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 (3 topics)

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

Module 9 - Working with Slicers (4 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

Course PDF

Print

Sections