Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back

Microsoft Excel Power Pivot

Course overview

Analyse, manipulate and present data in pivot tables and pivot charts.

Course duration

1 day

Delivery method

Flexible (Online/Classroom)


Open participant course: £195 per person - maximum 10 people

Closed company course: £1,000 per course - maximum 10 people

Suitable for

Those who need to produce complex analysis of single and multiple data sets in order to present and manipulating data using pivot tables and pivot charts.

Learning outcomes

By the end of the course, you will be able to use multiple data sources and produce calculations in Power Pivot and manage pivot table and pivot chart outputs with slicers.

Course content

Pivot Table Revision:

  • Creating a pivot table.
  • Presenting data using pivot charts.
  • Filtering pivot data with interactive slicers.

Getting Started and Connecting to Data Sources:

  • Introducing Power Pivot and the Power Pivot interface.
  • Using the table import wizard.
  • Filtering data on import.
  • Creating queries to import data.
  • Adding data using copy and paste techniques.
  • Linking table data.

Related Data Sources:

  • Creating additional queries.
  • Merge and append queries.
  • Creating relationships in Power Pivot.
  • Managing relationships.
  • Working in diagram view.
  • Defining hierarchy groups.
  • Producing related data outputs.
  • Adding queries to the data model.
  • Manipulating the data model.

Working with Power Pivot Formulas:

  • Creating calculated columns.
  • Using Power Pivot functions.
  • Producing measures and KPIs.
  • Creating perspectives.

Course requirements

This course can be delivered remotely or in a classroom environment, to suit your requirements.

Attendees should have an advanced understanding of working with Microsoft Excel, including using functions and formulas. A working knowledge of pivot tables and related databases is desirable but not essential.

Attendees must have the following equipment to attend this training remotely:

  • PC or laptop with a microphone and speakers (webcam is preferred but not essential).
  • Access to the internet and web browser application (e.g. Google Chrome).
  • Microsoft Excel installed on the PC or laptop.
  • An email account for file sharing.
  • A second screen is ideal but not essential.


For more information about this course please contact us.

Queens Court Regent Street Barnsley South Yorkshire S70 2EG
Tel: 01226 216760 | Email: |

These course details were downloaded on 20/04/2024

Enquire Now