PowerPivot for ExcelDownload Course Outline 2010, 2013 or 2016

Duration: 1 day

This course will give you an introduction to Power Pivot, an add-in to Excel that provides you with a powerful tool for analysing and integrating large amounts of data, exceeding the one million row threshold in a standard Excel workbook.  You’ll learn how to import data from a variety of external sources into Power Pivot and then combine the data so it can be analysed in Pivot Tables and Pivot Charts in Excel.  You’ll also have an introduction to the powerful calculations that can be performed within the Power Pivot environment, known as DAX.
Perhaps most importantly, you’ll discover the benefits of using Power Pivot over more traditional Excel analysis methods, particularly the demise of the Vlookup and linked workbooks.

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

 Call us on 0800 0199 746  

Outline of our PowerPivot for Excel 2010, 2013 or 2016 course

You can download a PDF course outline using the link on the top right of this page.

Overview of Power Pivot for Excel 

  • What is Power Pivot ?
  • What are the benefits of using Power Pivot ?
  • How to enable the Power Pivot add-in
  • The Power Pivot Window

Importing Your Data and the Data Model

  • How to import data into the PowerPivot Data Model.
  • Importing Data from a variety of Data Sources
  • Working with Data Connections
  • Refeshing Data

Creating the Power Pivot Data Model

  • How to create relationships between tables in the PowerPivot Data Model. 
  • Understanding One-to Many Relationships

Excel Analysis Tables

  • What is an Excel Analysis Table?
  • Using Slicers to filter data in the Table
  • Why Excel Tables are important to Power Pivot
  • Adding Linked Tables to the Data Model 

Analysing Data using a Pivot Table

  • Understanding Compact Layout
  • Changing the Layout
  • Using the “in-situ” filters
  • Grouping data for ad-hoc subtotals
  • Grouping date columns into years, months etc

 Creating PivotTables with PowerPivot 

  • How to create a PivotTable with PowerPivot data
  • How to use the Field list with the Data Model
  • What is different in a PowerPivot Pivot Table 
  • How Drill-down differs in PowerPivot.
  • Creating a Flattened Pivot Table to analyse combinations of unique data. 

 

 

 

Creating PivotTables with PowerPivot 

  • How to create a Pivot Table with Power Pivot data
  • How to use the Field List in the Data Model
  • What is different in a PowerPivot Pivot Table 
  • Recap and overview of data analysis using a Pivot Table

Working with Dates in Power Pivot 

  • How to analyse by Year, Quarter, Month etc.
  • Why a Date Table (Calendar Table) is required
  • Generating a Date Table
  • Marking as a Date Table. 

Using Slicers to Filter Data 

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

Using PivotCharts and Dashboards 

  • What is different about PowerPivot Charts
  • Connecting Slicers to PivotCharts
  • Creating "Dashboards". 

Creating Simple Calculated Columns 

  • How to create a Calculated Column
  • Looking up values from related tables 

Creating Calculated Fields

  • What is a Calculated Field
  • How to Add a Calculated Field to a PowerPivot PivotTable

Using PowerPivot Sets 

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

 Call us on 0800 0199 746