Aims & Objectives

Our Microsoft Excel Power Pivot course teaches you how to analyse and present your data more efficiently by using Power Pivot.

You’ll learn how to import data from different data sources, understand Table relationships, create basic Pivot Tables & Pivot Charts and use Data Analysis Expressions.

To attend you should be proficient in writing formulae and Excel functions.

What will I learn?

Introduction

  • Excel’s Power Pivot Ribbon
  • Starting Power Pivot
  • The Power Pivot Ribbons

Importing Data

  • Importing from different data sources
  • Adding tables to the Power Pivot window

Database Theory

  • What are related tables?
  • Viewing existing table relationships
  • Creating new table relationships

Creating a Basic Pivot Table

  • The Power Pivot layout window
  • Adding column and row labels
  • Choosing a measure

Creating a Basic Pivot Chart

  • Choosing suitable data
  • Changing the chart type
  • Adding multiple charts

Introducing Data Analysis Expressions (DAX)

  • Using DAX for calculated columns
  • Using DAX for new measures
  • DAX function examples

How We Deliver

We currently deliver all training online to comply with the Government's guidelines.

Online training works well for businesses whose staff are mainly working from home.

It allows us to train all of your staff with the same training needs at the same time. Your people simply log on from home, using details provided in advance by our team.

Choose from Watch and Learn sessions for larger groups or interactive hands on sessions for smaller groups.

When permitted we also offer face to face training at your offices.

All sessions can be customised to a half day or 90 minute sprint session and tailored to fit your needs, covering the topic(s) within a course that are most important to your business.

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)