Code: 
MSEXCEL4PIVT
Duration: 
1-2 Day(s)
Price: 
£1000-385

Overview

In the Microsoft Excel PowerPivot training course, we show you how to create and manage PivotTables, Slicers and PivotCharts: some of Excel's most powerful features for analysing data.

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

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.

Skills Gained

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

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

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

  • Microsoft Office Excel 2010: Level 2 (Intermediate)


Course Specifics

Course Outline

Module 1 - Introduction and Welcome

Module 2 - PivotTable Review

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

Module 3 - Introduction to PowerPivot

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

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

  • 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

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

Module 7 - 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 8 - Working with DAX (Data Analysis Expressions)

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

Module 9 - Working with Slicers

  • Layout Styles
  • Using Slicers
  • Additional Slicer Settings
  • Locking a Slicer to a PivotTable

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Please click date to Enquire Now
Course Location Days Cost Date
London2 1345 £1345 2018-05-21
London2 1345 £1345 2018-01-22
London2 1345 £1345 2018-01-15
Leicester2 1790 £1790 2017-12-06
Leicester2 1790 £1790 2017-11-02
Leicester2 1790 £1790 2017-10-31
Cardiff2 1000 £1000 2017-10-30
Manchester2 1000 £1000 2017-10-26
Oxford2 1000 £1000 2017-10-11
Leicester2 1790 £1790 2017-09-25
London2 1345 £1345 2017-09-18
London2 1345 £1345 2017-09-11
Leicester2 1790 £1790 2017-08-25
London2 1000 £1000 2017-08-23
Reading2 1000 £1000 2017-08-04
Bristol2 1000 £1000 2017-07-31
Glasgow2 1000 £1000 2017-07-19
Leicester2 1790 £1790 2017-07-17
Leeds2 1000 £1000 2017-07-12
London1 385 £385 2017-07-10