No products in the basket.

Registering for this site is easy. just fill in the fields below, and we’ll get a new account set up for you in not time.

Sign in to your Imperial Academy Account

Home
Course
Personal Development
Office Productivity
Microsoft Excel: Master Power Query in 120 Minutes!

Microsoft Excel: Master Power Query in 120 Minutes!

Office Productivity

4 students

(10 Rating)

About This Course

Educational accomplishments and income are closely correlated. Education and skill with endorsed certificates from credible and renowned authorities typically lead to better jobs with attractive salaries. Educated and skilled workers also have lower rates of unemployment. Therefore, skills and endorsed certificates to showcase are essential for people early in their careers.

Imperial Academy offers this premium Microsoft Excel: Master Power Query in 120 Minutes! course to ensure security in your career. In addition, this comprehensive Microsoft Excel: Master Power Query in 120 Minutes! course will assist you in building relevant skills that will help you find a job in the related sectors. Also, the Certificate you’ll get after completing the Microsoft Excel: Master Power Query in 120 Minutes! will put your head and shoulder above others in front of potential employers.

Become the person who would attract the results you seek. What you plant now, you will harvest later. So, grab this opportunity and start learning Microsoft Excel: Master Power Query in 120 Minutes!

QLS/ CPD/ CIQ Accredited
24/7 Assistance from our Support Team
100% Online
Self-paced course
Bite-sized Audio-visual Modules
Rich Learning Materials
Developed by Industry Specialists
Career Guidance

Learn at your own pace from the comfort of your home, as the rich learning materials of this premium course is accessible from any place at any time. The advanced course curriculums are divided into tiny bite-sized audio-visual modules by industry specialists with years of experience behind them.

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