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.
4.6
4.6 Rating ( 10 Reviews ) 
152 Students
152 StudentsBestseller
Great Service
Highly Rated
Trending
Unlock 3,000+ Courses & Unlimited Free Digital Certificates for £99 Only! Grab Now
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
Exclusive Deal! 95% Off, Today Only!
Offer Ends Soon
Take All courses for £49
This course includes:
Access
Level
Number of Units
Duration
- Original price was: £424.00.£29.99Current price is: £29.99.
- 1 year
- Intermediate
- Number of Units37
- Number of Quizzes0
- 3 hours, 13 minutes Gift this course
14-Day Money-Back Guarantee
£29.99
/Unit Price
Exclusive Deal! 95% Off, Today Only!
Discounted Total:£145.00
Quantity:
Buying more than one of the same courses?
- 50% discount for orders of 10+ courses
- 60% discount for orders of 50+ courses
- 70% discount for orders of 100+ courses
Looking for a more personalised package?
Contact Us Now