Microsoft Excel: Master Power Query in 120 Minutes!
Course Overview
You’ll have an arsenal of skills to lock down your desired career after completing this [course_title] course. Moreover, you will have access to all of the materials in this course for free for a whole year and learn a multitude of highly coveted skills to move up the corporate ladder.
With this comprehensive [course_title] course, you’ll have all of your questions answered and all of the necessary expertise under your belt. Apart from setting you up for success, this course offers numerous advantages to make your learning experience more pleasurable and less stressful. So, add this [course_title] course to the basket and take your expertise up a notch!
Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.
Why Choose Thames College?
Thames College offers you the benefit of —
- Learn with engaging voice-over and visual elements to facilitate your learning process.
- Receive round-the-clock access to expert assistance.
- Participate in quick assessments and get instant feedback on your progress.
- Study at your own schedule from the convenience of your own home.
Who Is This Course For?
Those who want to strengthen their professional skills while training for the desired job should take advantage of the [course_title] training! This course will keep you up-to-date with all the latest developments and coach you accordingly. So invest in this [course_title] course if you want the best training available.
Certificate of Achievement
CPD Certification
After successfully completing the assessment of this [course_title] course, you can apply for the CPD accredited certificates. The PDF version is only £2.99 and the Hardcopy version will cost you £8.99.
Requirements
No formal entry requirements! No prerequisites or relevant experience is required!
This course is accessible to anyone with an eagerness to learn. All you require is—
- A smart device with a stable internet connection
- A keen interest in this subject
- And being over the age of 16.
Career Path
Utilise this all-inclusive course to acquire the skills and expertise you’ll need to thrive in the workplace.
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 | ||
| Excel Power Query – Query Editor Ribbon | 00:09: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:13: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 Join | 00:09:00 | ||
| Power Query – Convert Reports into Pivot Tables | 00:05:00 | ||
| Modulo | 00:06: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.
Access
Level
Number of Units
Duration