Power Query

Learn how to convert vast amounts of data into key business information efficiently

Overview

Power Query will allow you to transform data into information using an intuitive interface which will record the steps taken so that they can be adapted and applied to new datasets.

Learn how you can stop wasting time on repetitive data cleansing tasks. Using hands-on examples throughout, you will learn how to convert vast amounts of data into key business information efficiently.

Please note, this is the same course featured in the Power Query, Power Pivot and Power BI pack.

Learning outcomes
Additional information

You will learn:

how to extract, transform and load data using Power Query from a range of sources
how to merge and combine data to create integrated tables
how to format and transform ’dirty’ data into a usable form to enable analysis
an understanding of the Mashup (M) code behind Power Query.

This course contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within Excel.
This course requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021.
The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
This course requires you to have a basic understanding of Microsoft Excel.
CPD certificate is available upon successful completion of the course.
12-month access.

Price

Price 120 GBP

Location

Global

Date & time

On demand

Book on ACCA Learning

Course providers