Microsoft Excel 2010 PowerPivot Training Course Outline

Audience: This course is aimed at experienced users of Excel PivotTables wishing to further their knowledge in Excel PowerPivot. Microsoft PowerPivot is a Microsoft Excel 2010 Add-on used for creating Business Intelligence (BI) reports based on large data sets inside the familiar environment of Excel PivotTables. PowerPivot is a free download from Microsoft. You need to have the PowerPivot add-on installed before the course if you are using your own equipment.

Course Duration: 1 day

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel 2010 PowerPivot training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Navigate the PowerPivot window
  • Specify source data for PowerPivot
  • Preparing data for analysis
  • Format Data
  • Create PowerPivot Relationships
  • Enter PowerPivot Calculations using DAX
  • Create Key Performance Indicators (KPI’s)

Course Outline

Module 1: Introduction to Power Pivot

  • Enabling the PowerPivot Add-in
  • Opening the PowerPivot window
  • Navigating the PowerPivot window
  • Exploring PowerPivot tabs and field list

Module 2: Source data for PowerPivot

  • Data sources and types supported by PowerPivot workbooks
  • Importing data
  • Adding tables to a PowerPivot model
  • Linking to Excel Tables

Module 3: Preparing data for analysis

  • Working with Tables and Columns
  • Filtering and Sorting Data
  • Creating Table relationships
  • Creating calculations

Module 4: Formatting Data

  • Creating and deleting a table
  • Renaming a Table or Column
  • Setting the Data Type of a Column
  • Hiding and Freezing Columns
  • Sorting and filtering table data

Module 5: PowerPivot Relationships

  • Understanding Relationships
  • Creating Relationships between Tables
  • Viewing and Editing Relationships
  • Deleting Relationships

Module 6: PowerPivot Calculations

  • The Data Analysis Expressions (DAX) language
  • Creating formulas for calculated columns and measures
  • Using DAX operators
  • Review of DAX functions
  • Using relationships and lookups in formulas
  • Using aggregate functions
  • Using filters in aggregate functions
  • Recalculating Formulas

Module 7: Key Performance Indicators (KPI’s)

  • Defining a KPI
  • Creating the KPI calculation
  • Setting the icon style and threshold values
  • Editing a KPI