Microsoft Excel: Master Power Query in 120 Minutes!

4.6 ( 10 REVIEWS )
152 STUDENTS

To claim CPD Accredited Certificate for this course, please go to the certificate section & collect your certificate.

Course Curriculum

Microsoft Excel: Master Power Query in 120 Minutes!
Welcome to the Power Query Course! 00:01:00
Excel Power Query – Introduction 00:03:00
Power Query and Query Editor Ribbon 00:09:00
Power Query Intro and Excel version 00:03:00
Transform Data – Trim in Excel Power Query 00:05:00
Transform Data – Format Dates and Values in Excel Power Query 00:02:00
Transform Data – Parsing URLs in Excel Power Query 00:05:00
Transform Data – Split Text Fields in Excel Power Query 00:10:00
Transform Data – Group By in Excel Power Query 00:03:00
Transform Data – Unpivoting Columns in Excel Power Query 00:05:00
Transform Data – Pivoting Columns in Excel Power Query 00:02:00
Transform Data – Split Columns into Other Columns in Excel Power Query 00:04:00
Transform Data – Filtering Rows in Excel Power Query 00:05:00
Transform Data – Sorting Columns in Excel Power Query 00:02:00
Transform Data – Transform and Add Columns in Excel Power Query 00:07:00
From Folder – Import From Folder in Excel Power Query 00:07:00
From Folder – Doing Auto Cleanup in Excel Power Query 00:07:00
From Folder – Extract Data from Forms in Excel Power Query 00:13:00
From Workbook – Extract Multiple Criteria in Excel Power Query 00:05:00
From Workbook – Extract Multiple Worksheets in Excel Power Query 00:04:00
Joins – Intro to Joins 00:04:00
Joins – Merging 00:08:00
Joins – Full Outer Join 00:06:00
Joins – Right Anti 00:09:00
Power Query – Convert Reports into 00:05:00
Power Query – Modulo 00:06:00
Finding the list of M functions 00:02:00
Passing Functions – keyword each 00:03:00
Simple Expressions – Nested Expressions 00:03:00
Enabling M in Power Query 00:02:00
Using M Functions 00:10:00
Variables 00:08:00
Passing Functions 00:08:00
Reusable Functions 00:02:00
Simple Expressions 00:08:00
Functions 00:06:00
Invoking 00:01:00

Certificate of Achievement

Upon completion, you will receive a CPD-accredited certificate recognised globally. Choose from:

Pdf Certificate & Transcript  £7.99
Hardcopy Certificate & Transcript  £17.99

This certification validates your knowledge and skills, boosting your employability in healthcare.

Thames-college-logo-white-2021

We are a business that specialises in providing CPD & QLS accredited courses for anyone looking to advance their professional career.

Address : 78 Ilford Lane, Ilford, England, IG1 2LA

Email : info@thamescollege.org

Phone Number : ​020 8124 5465

Payment Methods

lead-payment-logos

Copyright © 2026 Thames College. All Right Reserved.

top