Home
Course
Microsoft Excel: Master Power Query in 120 Minutes!

Microsoft Excel: Master Power Query in 120 Minutes!

4.8( 5 REVIEWS )

253 STUDENTS

Course Overview

You’ll have an arsenal of skills to lock down your desired career after completing this Microsoft Excel: Master Power Query in 120 Minutes! course. Moreover, you will have access to all of the materials in this course for free for a whole year and learn a multitude of highly coveted skills to move up the corporate ladder.

With this comprehensive Microsoft Excel: Master Power Query in 120 Minutes! course, you’ll have all of your questions answered and all of the necessary expertise under your belt. Apart from setting you up for success, this course offers numerous advantages to make your learning experience more pleasurable and less stressful. So, add this Microsoft Excel: Master Power Query in 120 Minutes! course to the basket and take your expertise up a notch!

Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.

Why Choose Thames College?

Thames College offers you the benefit of —

Who Is This Course For?

Those who want to strengthen their professional skills while training for the desired job should take advantage of the Microsoft Excel: Master Power Query in 120 Minutes! training! This course will keep you up-to-date with all the latest developments and coach you accordingly. So invest in this Microsoft Excel: Master Power Query in 120 Minutes! course if you want the best training available.

Certificate of Achievement

CPD Certification

After successfully completing the assessment of this Microsoft Excel: Master Power Query in 120 Minutes! course, you can apply for the CPD accredited certificates. The PDF version is only £2.99 and the Hardcopy version will cost you £8.99.

Requirements

No formal entry requirements! No prerequisites or relevant experience is required!

This course is accessible to anyone with an eagerness to learn. All you require is—

Career Path

Utilise this all-inclusive course to acquire the skills and expertise you’ll need to thrive in the workplace.

Course Curriculum

Microsoft Excel: Master Power Query in 120 Minutes!
	Power Query Intro and Excel version	00:03:00
	Excel Power Query – Introduction	00:03:00
	Excel Power Query – Query Editor Ribbon	00:09: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:13: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 Join	00:09:00
	Power Query – Convert Reports into Pivot Tables	00:05:00
	Modulo	00:06:00