Microsoft Excel: Master Power Query in 120 Minutes!

Overview

Grasp the science of Microsoft Excel: Master Power Query in 120 Minutes! and how it relates to launching a lucrative career. Prepare for future Microsoft Excel: Master Power Query in 120 Minutes! needs by looking beyond the ongoing Microsoft Excel: Master Power Query in 120 Minutes! impact with Discover Training’s up-to-date Microsoft Excel: Master Power Query in 120 Minutes! course .

Discover Training’s Microsoft Excel: Master Power Query in 120 Minutes! course gives you a solid foundation in Microsoft Excel: Master Power Query in 120 Minutes! in many settings of human development. With industry expert interviews, you’ll gain a greater understanding of Microsoft Excel: Master Power Query in 120 Minutes!‘s applications and limitations, as well as how it’s already been efficiently used in the field. Discover Training’s Microsoft Excel: Master Power Query in 120 Minutes! course will help you obtain facts and knowledge to strengthen your abilities on both standard Microsoft Excel: Master Power Query in 120 Minutes! techniques.

As you progress through the interactive modules of this online program, you will have a strong grasp of Microsoft Excel: Master Power Query in 120 Minutes! to identify new opportunities for innovation and drive digital growth within your organization. Enrol in the Microsoft Excel: Master Power Query in 120 Minutes! course today and leverage your knowledge tomorrow.

Description:

Industry professionals developed the content of this online Microsoft Excel: Master Power Query in 120 Minutes! course, combining their expertise and in-depth knowledge. The curriculum was developed by Discover Training to assist you in growing in your current role by providing you with the necessary information and concepts. As you progress through the modules of this course, you’ll learn the fundamentals of Microsoft Excel: Master Power Query in 120 Minutes! and explore the essential concepts.

Who is this course for?

This Microsoft Excel: Master Power Query in 120 Minutes! course is for you if you want to learn about the revolutionary potential of Microsoft Excel: Master Power Query in 120 Minutes!. Whether you are a newbie or a seasoned veteran, a grasp of challenges that Microsoft Excel: Master Power Query in 120 Minutes! techniques can tackle would benefit anyone working in the Microsoft Excel: Master Power Query in 120 Minutes! sector. This Microsoft Excel: Master Power Query in 120 Minutes! training covers crucial subjects that will help you overcome challenges and improve your practices.

Requirements:

Certification

Once the Microsoft Excel: Master Power Query in 120 Minutes! course is successfully completed, the learner can obtain the PDF certificate without any cost. The hardcopy version of the certificate is also available for only £9.99. However, anyone ordering the hardcopy certificate from outside the United Kingdom may need to pay an additional delivery charge.

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

Frequently Asked Questions

Are Discover Training courses accredited?

Yes, Discover Training provides accredited and CPD-certified courses, ensuring learners receive recognised qualifications that support career progression and professional compliance.

Who can enrol on Discover Training courses?

Anyone can enrol, including students, professionals, job seekers, career changers, and organisations. Most courses do not require previous experience, making them accessible to learners at all levels.

What types of courses does Discover Training offer?

Discover Training offers courses across multiple sectors, including business, health and safety, compliance, leadership, IT, personal development, and professional skills training.

Will I get a refund if I cancel my order?

You will have 14 days to revoke your Course purchase from your purchase date. Regrettably, refunds are not allowed after your purchase have been approved, and materials have been posted to the student’s dashboard or accessed.

Will I receive a certificate after completing a course?

Yes, learners receive a downloadable digital certificate upon successful completion, suitable for CPD records, CVs, and professional portfolios.