Skip to content
Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide cover image

Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide
ideas2action

Summary

Price
£19 inc VAT
Study method
Online, On Demand
Duration
2.1 hours · Self-paced
Qualification
No formal qualification
Additional info
  • Tutor is available to students

Add to basket or enquire

Buy with Apple Pay Buy with Google Pay

Overview

If you are serious about data analysis, then you need to know how to use the Power Query and Power Pivot tools in Microsoft Excel. This Quickstart guide will give you the skills you need to get started with these powerful features.

On completion of the course, delegates will be able to:

  • Use Power Query to load data from an external source into Microsoft Excel
  • Clean and manipulate external data before loading it into Excel
  • Consolidate separate files with Power Query
  • Update Excel tables with new data in the same format
  • Use Power Query to “unpivot” report tables to prepare the data for analysis
  • Explain the core functionality of Power Pivot
  • Link data tables together in the Power Pivot data model
  • Create pivot tables that draw data from several source data tables
  • Create performance measures and new analysis in the Power Pivot data model
  • Use the most popular DAX query language functions in Power Pivot

Curriculum

1
section
8
lectures
2h 9m
total

Course media

Description

The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data.

The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis.

If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own.

Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI

Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.

Curriculum

Lesson 1: Power Query Quickstart

Lesson 2: Consolidating Files with Power Query

Lesson 3: Unpivoting a Table

Lesson 4: Power Pivot Quickstart

Lesson 5: Power Pivot – Adding Data and Functionality

Lesson 6: Key DAX Functions for Power Pivot

Lesson 7: The DAX CALCULATE Function

Lesson 8: Key Learning Points

Requirements

No requirements

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.