Microsoft Excel  - PowerPivot for Excel IntroductionDownload Course Outline

This is the outline of our Microsoft Excel PowerPivot Introduction course - Duration: 1 day

PowerPivot for Excel is a free add-in to Excel 2010 that will provide you with powerful tools for analysing and integrating large amounts of data, exceeding the one million row threshold in a standard Excel workbook.   The add-in will deliver to you the capability for On Line Analytical Processing (OLAP) provided by Microsoft’s SQL Server Analysis Services right to your PC. 

This course will give you an introduction to PowerPivot. You’ll learn how PowerPivot uses Excel Tables, PivotTables, Pivot Charts and Slicers to display and analyse PowerPivot data and also how PowerPivot can be used to perform powerful calculations on related tables of data using familiar tools such as filtering, sorting and an intuitive library of functions.

This course will also cover one of the most powerful features of PowerPivot and that is the ability to go beyond the use of standard Excel expressions and use PowerPivot’s Data Analysis Expressions (DAX) language to perform powerful data manipulations and use Time Intelligence functions. You'll learn how to create or follow relationships between tables as in a relational database 

To get the most out of this course you should be a competent Microsoft Excel user.

We specialise on on-site training and can come to you to run our course either on your PC's or provide our own high specification equipment. If you want specific training for your staff, we're happy to customise this course to your requirements, adding or removing topics as necessary.

Microsoft Excel  - PowerPivot Introduction course content

Download a PDF course outline using the link on the right.

What is PowerPivot for Excel?

  • Understanding the three components of the Add In
  • The PowerPivot Tab in the Ribbon
  • The PowerPivot Window
  • The PowerPivot Field List

Importing your Data 

  • How to import data into the PowerPivot window
  • Using Copy and Paste
  • From External Data Sources
  • From an Excel Spreadsheet using an Excel Table

Creating Relationships

  • How to create relationships between tables in the PowerPivot window

Sorting and Filtering Tables

  • How to work with large sets of data
  • Using the Sort and Filter options

Creating PowerPivot PivotTables

  • How to create a PivotTable with PowerPivot data
  • How to use the PowerPivot Field list
  • Recap on essential PivotTable skills
  • Using the “Show Data As” option

What-If Analysis

  • How to perform “What-If” analysis on PowerPivot PivotTables.

Using Slicers

  • How to filer data using Slicers
  • Connecting Slicers to more than one PivotTable

 

Calculations in PowerPivot

  • How formulas and functions are different in PowerPivot.

Where to use DAX

  • What is DAX
  • How DAX is used in PowerPivot PivotTables

Creating Calculated Columns

  • How to create a Calculated Column in a PowerPivot Table.
  • How to use DAX expressions in Calculated Columns
  • Looking up values from related tables

Creating Measures

  • What is a Measure
  • How to Add a Measure to a PowerPivot PivotTable
  • Using DAX aggregate functions in a PowerPivot PivotTable
  • Using Measures to create Measures
  • How to use the Calculate Function
  • How to use the ALL Function

Using Time Intelligence Functions

  • Why Time Intelligence Functions?
  • Setting up a Date Table
  • Finding Month to Date, Year To Date, Same Period Last Year and adding months, quarters to dates.

Using PowerPivot Sets

  • What are PowerPivot Sets?
  • How to Create a Set to get the combination of data you want from a PowerPivot PivotTable