Microsoft Excel 2013 PowerPivot - EX13PP

In Connect 2 Courses Microsoft Excel 2013 Intermediate and Advanced courses, we show you how to create and manage PivotTables, Slicers and PivotCharts: some of Excel's most powerful features for analysing data. This course takes PivotTables to the next level, teaching you how to use PowerPivot: a free add-in available for Microsoft Excel 2013.

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).

Please Note: PowerPivot will not work on Microsoft Excel 2003 or 2007, it is designed for Microsoft Excel 2010 or 2013 users only.

Target Audience

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.


Module 1 - PivotTable Review

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

Module 2 - Introduction to PowerPivot

  • PowerPivot Overview
  • PowerPivot Online Information

Module 3 - Connecting to Single Table Data Sources

  • 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 4 - Working with Multiple Table Data Sources

  • Connecting to Data Different Sources
  • Pasting Data into PowerPivot
  • Checking PowerPivot Can Produce Results
  • Excel (Flat-File Database) as a Data Source
  • Managing Data in a PowerPivot Window
  • Importing Data from Data Feeds into PowerPivot
  • Importing Data from Windows Azure Marketplace
  • Excel (Linked Tables) as a Data Source

Module 5 - The Diagram View

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

Module 6 - Measures, Calculations and KPIs

  • 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 7 - Working with DAX (Data Analysis Expressions)
  • Sample DAX Functions
  • Writing DAX Functions
  • Time Intelligent Functions

Module 8 - Working with Slicers

  • Layout Styles
  • Using Slicers
  • Additional Slicer Settings
  • Locking a Slicer to a PivotTable/Chart
  • Adding a Timeline to a PivotTable/Chart
  • Pricing / Dates / Locations available on request

  • Please call us on 01285 711200
    Enquire below:

Course Information

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 2013
  • 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

To ensure your success, we recommend the following courses have been undertaken, or equivalent knowledge gained:

  • Microsoft Excel 2013 Advanced

Please Note: If you attend a course and do not meet the prerequisites, or your organisation does not use Microsoft Excel 2013 (or 2010), you may be asked to leave.

  • Use a wide variety of data sources within PowerPivot
  • Create calculations within PowerPivot
  • Manage various PivotTables creates by PowerPivot

Enquire about this course

Please leave this field blank: