Microsoft Excel: Master Power Query in 120 Minutes!
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
- Mock exams
- Multiple-choice assessment
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Microsoft Excel: Master Power Query in 120 Minutes! is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
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 | ||
| Power Query and Query Editor Ribbon | 00:09:00 | ||
| Enabling M in Power Query | 00:02:00 | ||
| Transform Data – Trim in Excel Power Query | 00:05:00 | ||
| Transform Data – Format Dates and Values in Excel Power Query | 00:02:00 | ||
| Simple Expressions | 00:08:00 | ||
| Simple Expressions – Nested Expressions | 00:03:00 | ||
| Transform Data – Parsing URLs in Excel Power Query | 00:05:00 | ||
| Variables | 00:08:00 | ||
| Functions | 00:06:00 | ||
| Transform Data – Split Text Fields in Excel Power Query | 00:10:00 | ||
| Reusable Functions | 00:02:00 | ||
| Invoking | 00:01:00 | ||
| Transform Data – Group By in Excel Power Query | 00:03:00 | ||
| Passing Functions | 00:08:00 | ||
| Passing Functions – keyword each | 00:03:00 | ||
| Finding the list of M functions | 00:02: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 | ||
| Using M Functions | 00:10: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 | ||
| 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 | ||
| 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 | ||
| Welcome to the Power Query Course! | 00:01:00 | ||
FREQUENT ASKED QUESTION
.accordion-body, though the transition does limit overflow.
.accordion-body, though the transition does limit overflow.
.accordion-body, though the transition does limit overflow.