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
CPD Accredited Certification
You will be eligible for CPD Accredited Certificates after completing this Course successfully.
Certification is available –
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
£29.99
£424
Access
Level
Number of Units
Number of Quizzes
Duration
Mindful Eating: Nourishing the Gut-Brain Connection
Original price was: £424.00.£29.99Current price is: £29.99.
Prime Your Day : Create a Perfect Morning Routine
Original price was: £424.00.£29.99Current price is: £29.99.
Machine Learning Model Using AWS SageMaker Canvas
Original price was: £424.00.£29.99Current price is: £29.99.