Microsoft Excel: Master Power Query in 120 Minutes!
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.
£29.99
£424
TAKE THIS COURSE
or
Access all 3000+ Courses for £129
Access
Level
Number of Units
Duration