Development
QLS
Business
Healthcare
Health & Fitness
Technology
Teaching
Lifestyle
Design
- Overview
Educational accomplishments and income are closely correlated. Education and skill with endorsed certificates from credible and renowned authorities typically lead to better jobs with attractive salaries. Educated and skilled workers also have lower rates of unemployment. Therefore, skills and endorsed certificates to showcase are essential for people early in their careers.
- Why Choose Imperial Academy?
Imperial Academy offers this premium Microsoft Excel: Master Power Query in 120 Minutes! course to ensure security in your career. In addition, this comprehensive Microsoft Excel: Master Power Query in 120 Minutes! course will assist you in building relevant skills that will help you find a job in the related sectors. Also, the Certificate you’ll get after completing the Microsoft Excel: Master Power Query in 120 Minutes! will put your head and shoulder above others in front of potential employers.
Become the person who would attract the results you seek. What you plant now, you will harvest later. So, grab this opportunity and start learning Microsoft Excel: Master Power Query in 120 Minutes!
- What Imperial Academy Offers You
- QLS/ CPD/ CIQ Accredited
- 24/7 Assistance from our Support Team
- 100% Online
- Self-paced course
- Bite-sized Audio-visual Modules
- Rich Learning Materials
- Developed by Industry Specialists
- Career Guidance
- Course Design
Learn at your own pace from the comfort of your home, as the rich learning materials of this premium course is accessible from any place at any time. The advanced course curriculums are divided into tiny bite-sized audio-visual modules by industry specialists with years of experience behind them.
- Audio-visual Lessons
- Online Study Materials
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
Learners will get an certificate of achievement directly at their doorstep after successfully completing the course!
It should also be noted that international students must pay £10 for shipping cost.
CPD Accredited Certification
Upon successfully completing the course, you will be qualified for CPD Accredited Certificate. Certification is available –
- PDF Certificate £7.99
- Hard Copy Certificate £14.99
Recent Courses
