Skip to content

Excel Power Query Fundamentals Course
Acudemy

Summary

Price
Save 22%
£350 inc VAT (was £450)
Offer ends 16 February 2026
Study method
Online + live classes
Duration
1 day · Full-time
Qualification
No formal qualification
Additional info
  • Tutor is available to students

Add to basket or enquire

Overview

Learning Microsoft Excel Power Query will enable you to fundamentally transform the way you work with business data.

It will significantly reduce the number of hours you spend manually manipulating extracted data into a usable analytical format. It will even reduce time, reliance on and the maintenance of data transforming and cleaning using MS Excel VBA Macros.

During the course you will complete a number of practical case study files which you will retain post course, as your own learning reference library. Each practical will via a step-by-step approach, coach you on the various key learning points, on how to quickly and effectively extract, transform and output cleaned data. These together with many practical user hints, and tips, will enable you to reduce many hours of repetitive data manipulation tasks into just minutes or even seconds at just the press of a refresh button, consistently time after time.

In just one day, the coaching you receive will ensure you are both confident and competent at extracting, importing, transforming, cleaning and reshaping your data into an output format which is ready to be easily analysed. Or even enable you to create a dataset in the correct format for importing into core business applications.

Description

(1) Getting Started

  • Overview of Excel Power Query
    • What is Power Query?
    • Why Use Power Query?
    • How to access Power Query?
  • Introduction to the Power Query Editor Window
    • Checking your Power Query Settings
    • The Ribbon Tabs and Icon Groups
    • The Query Navigation Pane
    • Current View Window
    • Formula Bar, Status Bar
    • Query Settings Pane
      • Properties
      • Applied Steps

(2) Extracting Data

  • How to Extract / Source Data
    • From a Named Range
    • From an Excel table
    • From another Excel workbook(s)
    • From PDF
    • Append data from Excel worksheets and multiple data sources
    • From Folder (multiple files)

(3) Transforming and Cleaning Data - Part 1

  • Basics
    • TRIM, CLEAN
    • Correct Dates
    • Text - lower case, UPPER case, Capitalise Each Word
    • Choose Columns, Go To Columns
    • Keep Rows, Top, Bottom, Range
    • Remove Rows, Top, Bottom, Alternate, Blanks, Duplicates, Errors
    • Remove Columns, Remove Other Columns
    • Keep and Remove Blanks, Duplicates, Errors
    • Replace Values, Replace Errors
    • First Row as Header, First Header as Row
    • Fill Up, Fill Down
    • Sorting and Filtering
    • Split Columns, Merge Columns
    • Extract
      • Length
      • First Characters, Last Characters, Range
      • Text Before Delimiter, Text After Delimiter
      • Text Between Delimiters

(4) Transforming and Cleaning Data - Part 2

  • Advanced
  • Working with Data Types
  • Add a Conditional Column
  • Add a Custom Column
  • Format - Add Prefix, Add Suffix
  • Transforming Dates
    • Age, Date Only, Month, Quarter, Week
    • Subtract Days, Combine Date and Time, Earliest, Latest

(5) Advanced Transforming Techniques

  • Transpose
  • Group By
  • Unpivot

(6) Queries

  • Merge Queries vs. Append Queries
    • Merge Query
      • Merge data from an Excel workbook
      • Merge data from multiple Excel workbooks
    • Append Query
  • Duplicate Query
  • Reference Query
  • Structuring your Queries by Group

(7) M Code and Advanced Editor

  • Overview of M Code
  • Applied Steps
  • Introduction to Advanced Editor window

(8) Load

  • Refresh Preview, Refresh All
  • Close and Load and setting Default
  • Close and Load To
    • Table
    • PivotTabIe Report
    • PivotChart
    • Only Create Connection
  • Queries and Connections Windows
    • Refresh Query
    • Query Properties
  • Dealing with Errors

Who is this course for?

This course is designed for existing advanced users of spreadsheets, who spend a substantial amount of their work time manually preparing data for analysis.

Previous experience of using Range Names, Structured Reference Tables, Pivot Tables and Formulas i.e.= IF, =IFS and new array formulas is required.

Requirements

It is recommended that all attendees aim to arrive at least 15 minutes before the start of the course to ensure all pre-course administration and set-up are completed in a timely manner.

Questions and answers

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