Related Courses
Excel Skills for 2021
£299.00
Microsoft Excel: Master Power Query in 120 Minutes!
£299.00
Course Curriculum
| Microsoft Excel: Master Power Query in 120 Minutes! | |||
| 00 – Power Query Intro and Excel version | 00:03:00 | ||
| 01 – M Introduction | 00:03:00 | ||
| 01 – Power Query and Query Editor Ribbon | 00:09:00 | ||
| 02 – Enabling M in Power Query | 00:02:00 | ||
| 02 – Trim | 00:05:00 | ||
| 03 – Format Dates and Values | 00:02:00 | ||
| 03b – Simple Expressions – Nested Expressions | 00:03:00 | ||
| 04 – Parsing URLs | 00:05:00 | ||
| 04 – Variables | 00:08:00 | ||
| 05 – Functions | 00:06:00 | ||
| 05 – Split Text Fields | 00:10:00 | ||
| 05b – Functions – Reusable Functions | 00:02:00 | ||
| 05c – Functions – Invoking | 00:01:00 | ||
| 06 – Group By | 00:03:00 | ||
| 06 – Passing Functions | 00:08:00 | ||
| 06b – Passing Functions – keyword each | 00:03:00 | ||
| 07 – Finding the list of M functions | 00:02:00 | ||
| 07 – Import From Folder | 00:07:00 | ||
| 08 – Doing Auto Cleanup | 00:07:00 | ||
| 08 – Using M Functions | 00:10:00 | ||
| 09 – Extract Data from Forms | 00:13:00 | ||
| 10 – Extract – Multiple Criteria | 00:05:00 | ||
| 11 – Extract Multiple Worksheets | 00:04:00 | ||
| 12 – Unpivoting Columns | 00:05:00 | ||
| 13 – Pivoting Columns | 00:02:00 | ||
| 14 – Split Columns into Other Columns | 00:04:00 | ||
| 15 – Filtering Rows | 00:05:00 | ||
| 16 – Sorting Columns | 00:02:00 | ||
| 17 – Transform and Add Columns | 00:07:00 | ||
| 18 – Intro to Joins | 00:04:00 | ||
| 19 -Merging | 00:08:00 | ||
| 20 – Full Outer Join | 00:06:00 | ||
| 21 – Right Anti Join | 00:09:00 | ||
| 22 – Convert Reports into Pivot Tables | 00:05:00 | ||
| 23 – Modulo | 00:06:00 | ||
| FINAL | 00:01:00 | ||
