Description

Overview

This Microsoft Excel: Master Power Query course will unlock your full potential and will show you how to excel in a career in Microsoft Excel: Master Power Query. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel: Master Power Query is available in this course.

Learning and progressing are the hallmarks of personal development. This Microsoft Excel: Master Power Query will quickly teach you the must-have skills needed to start in the relevant industry.

In This Microsoft Excel: Master Power Query
Course, You Will:

Learn strategies to boost your workplace efficiency.

Hone your Microsoft Excel: Master Power Query skills to help you advance your career.

Acquire a comprehensive understanding of various Microsoft Excel: Master Power Query topics and tips from industry experts.

Learn in-demand Microsoft Excel: Master Power Query skills that are in high demand among UK employers, which will help you to kickstart your career.

This Microsoft Excel: Master Power Query course covers everything you must know to stand against the tough competition in the Microsoft Excel: Master Power Query field.

The future is truly yours to seize with this Microsoft Excel: Master Power Query. Enrol today and complete the course to achieve a Microsoft Excel: Master Power Query certificate that can change your professional career forever.

Additional Perks of Buying a Course From Institute of Mental Health

Study online - whenever and wherever you want.

One-to-one support from a dedicated tutor throughout your course.

Certificate immediately upon course completion

100% Money back guarantee

Exclusive discounts on your next course purchase from Institute of Mental Health

Enrolling in the Microsoft Excel: Master Power Query course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now.

Process of Evaluation

After studying the Microsoft Excel: Master Power Query course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.

Certificate of Achievement

Upon successfully completing the Microsoft Excel: Master Power Query course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99.

Who Is This Course for?

This Microsoft Excel: Master Power Query is suitable for anyone aspiring to start a career in Microsoft Excel: Master Power Query; even if you are new to this and have no prior knowledge on Microsoft Excel: Master Power Query, this course is going to be very easy for you to understand.

And if you are already working in the Microsoft Excel: Master Power Query field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.

Taking this Microsoft Excel: Master Power Query course is a win-win for you in all aspects.

This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education.

Requirements

This Microsoft Excel: Master Power Query course has no prerequisite.

You don't need any educational qualification or experience to enrol in the Microsoft Excel: Master Power Query course.

Do note: you must be at least 16 years old to enrol.

Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Microsoft Excel: Master Power Query course.

Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills.

Course Curriculum

Microsoft Excel: Master Power Query
	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

Course Images

Microsoft Excel: Master Power Query

By IOMH - Institute of Mental Health

Booking options

Highlights

Description

About The Provider

Tags

Reviews