Description

Overview

By enroling in Microsoft Excel: Master Power Query in 120 Minutes!, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic.

The Microsoft Excel: Master Power Query in 120 Minutes! course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent Microsoft Excel: Master Power Query in 120 Minutes! course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our Microsoft Excel: Master Power Query in 120 Minutes! Program.

So enrol in our Microsoft Excel: Master Power Query in 120 Minutes! course right away if you're keen to envision yourself in a rewarding career.

Description

Enroling in this Microsoft Excel: Master Power Query in 120 Minutes! course can improve your Microsoft Excel: Master Power Query in 120 Minutes! perspective, regardless of your skill levels in the Microsoft Excel: Master Power Query in 120 Minutes! topics you want to master. If you're already a Microsoft Excel: Master Power Query in 120 Minutes! expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced Microsoft Excel: Master Power Query in 120 Minutes! insights that will help you make the most of your time. This Microsoft Excel: Master Power Query in 120 Minutes! course will act as a guide for you if you've ever wished to excel at Microsoft Excel: Master Power Query in 120 Minutes!.

Why Choose Us?

This course is accredited by the CPD Quality Standards.

Lifetime access to the whole collection of the learning materials.

Online test with immediate results.

Enroling in the course has no additional cost.

You can study and complete the course at your own pace.

Study for the course using any internet-connected device, such as a computer, tablet, or mobile device.

Will I Receive A Certificate Of Completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99.

Who Is This Course For?

This Microsoft Excel: Master Power Query in 120 Minutes! course is a great place to start if you're looking to start a new career in Microsoft Excel: Master Power Query in 120 Minutes! field. This training is for anyone interested in gaining in-demand Microsoft Excel: Master Power Query in 120 Minutes! proficiency to help launch a career or their business aptitude.

Requirements

The Microsoft Excel: Master Power Query in 120 Minutes! course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Microsoft Excel: Master Power Query in 120 Minutes!, without any fuss.

Career Path

This Microsoft Excel: Master Power Query in 120 Minutes! training will assist you develop your Microsoft Excel: Master Power Query in 120 Minutes! ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a Microsoft Excel: Master Power Query in 120 Minutes! professional story and personalise your path to a new career. Furthermore, developing this Microsoft Excel: Master Power Query in 120 Minutes! skillset can lead to numerous opportunities for high-paying jobs in a variety of fields.

Order Your Certificate To order CPD Quality Standard Certificate, we kindly invite you to visit the following link:

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
Order Your Certificate
	Order Your Certificate	00:00:00

Course Images

Microsoft Excel: Master Power Query in 120 Minutes! Course

By NextGen Learning

Booking options

Highlights

Description

About The Provider

Tags

Reviews