Professional Training
4.7 (186 Reviews)

Excel PowerPivot

STL, In London (+21 locations)
Length
1 day
Price
650 - 750 GBP excl. VAT
Next course start
19 September, 2024 (+51 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
650 - 750 GBP excl. VAT
Next course start
19 September, 2024 (+51 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel PowerPivot

STL courses

  • At the end of this 2 day course delegates will have the skills required to start using PowerPivot.
  • The course will show delegates how to leverage their existing PivotTable knowledge in Excel with PowerPivot.
  • Enable delegates to better understand how PowerPivot might be applied back in their workplace.

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • Face-to-Face and Virtual Instructor led .
  • And more... .

Upcoming start dates

Choose between 51 start dates

19 September, 2024

  • Virtual Classroom
  • Online
  • English

3 October, 2024

  • Classroom
  • London
  • English

17 October, 2024

  • Virtual Classroom
  • Online
  • English

1 November, 2024

  • Classroom
  • London
  • English

18 November, 2024

  • Virtual Classroom
  • Online
  • English

29 November, 2024

  • Classroom
  • London
  • English

18 December, 2024

  • Virtual Classroom
  • Online
  • English

3 January, 2025

  • Classroom
  • London
  • English

20 January, 2025

  • Virtual Classroom
  • Online
  • English

3 February, 2025

  • Classroom
  • London
  • English

19 February, 2025

  • Virtual Classroom
  • Online
  • English

5 March, 2025

  • Classroom
  • London
  • English

19 March, 2025

  • Virtual Classroom
  • Online
  • English

4 April, 2025

  • Classroom
  • London
  • English

22 April, 2025

  • Virtual Classroom
  • Online
  • English

2 May, 2025

  • Classroom
  • London
  • English

22 May, 2025

  • Virtual Classroom
  • Online
  • English

2 June, 2025

  • Classroom
  • London
  • English

19 June, 2025

  • Virtual Classroom
  • Online
  • English

2 July, 2025

  • Classroom
  • London
  • English

17 July, 2025

  • Virtual Classroom
  • Online
  • English

1 August, 2025

  • Classroom
  • London
  • English

14 August, 2025

  • Virtual Classroom
  • Online
  • English

1 September, 2025

  • Classroom
  • London
  • English

11 September, 2025

  • Virtual Classroom
  • Online
  • English

1 October, 2025

  • Classroom
  • London
  • English

10 October, 2025

  • Virtual Classroom
  • Online
  • English

31 October, 2025

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?



This course is suitable for any existing Excel user who has to manipulate, analyse and report on massive amounts of data. Types of PowerPivot Course London attendees have varied from business analysts, commercial directors, finance teams, client service/revenue managers to the Office for National Statistics.

Training Course Content



Getting started with PowerPivot

Start Excel and launch the PowerPivot window
Navigating the PowerPivot window
Exploring the PowerPivot tab and field list in Excel

Adding data to PowerPivot

Data sources and types supported in PowerPivot workbooks
Importing data (from pre-prepared file)
Add Data by using Excel Linked Tables
Using Power Query

Preparing data for analysis

Working with Tables and Columns
Filtering and Sorting Data
Creating Relationships Between Tables
Creating and Working with calculations

Data; formatting and layout

Creating, deleting a table
Rename a Table or Column
Set the Data Type of a Column
Hide or Freeze Columns
Undo or Redo an Action
Sorting and filtering data in a table

PowerPivot and relationships

Understanding Relationships
Create a Relationship Between Two Tables
View and Edit Relationships
Delete Relationships
Troubleshoot Relationships

Calculations in PowerPivot

Overview of Data Analysis Expressions (DAX) language
Building Formulas for Calculated Columns and Measures
Understanding the Use of Relationships and Lookups in Formulas
Understanding Aggregations in Formulas
Filtering Data in Formulas
Recalculating Formulas

Creating PivotTables, Charts and Reports

Create a PivotTable or PivotChart Report
Create a Reporting Services Report with PowerPivot Data
Create a Measure in a PivotTable or PivotChart
Create and Change the Field Layout in a PivotTable or PivotChart Report
Delete a PivotTable or PivotChart Report
Filter Data using Slicers
Work with Relationships in PivotTables
Change the Display Language

Overview of Key Performance Indicators (KPI's) in PowerPivot

Retail sales KPI case study
Sales per hour, average
Conversion rates
Wage to sales ratio

Expenses



List price £995, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact form

Fill out your details to find out more about Excel PowerPivot.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews by course attendees

Average rating 4.7

Based on 186 reviews.
Reviews are published according to our review policy.
Write a review!
5/5
Nicholas
13 Feb 2023

Not sure of the level of knowledge everyone else had going into the course so maybe it was because I had used pivot tables before but felt that could have done some more advance...

Show more
5/5
Melinda
18 Jan 2023

Samer was brilliant. Explained things so well and was very patient; making sure everyone understood before he moved on. I have already recommended STL to someone looking for t...

Show more
5/5
Christopher
18 Oct 2022

Most useful topic: PowerQuery

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads