Management
Hands on Training icon
Hands On Training
Hands on Training icon

Microsoft Excel: Master Power Query in 120 Minutes!

Course Cover

5

(4)

compare button icon

Course Features

icon

Duration

2 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

Course Description

Are you frustrated when you open a power query and see the many things you need to do? This Microsoft Excel course will teach you how to master Power Query in just 120 minutes! This course is what you need.

Power Query, an Excel business intelligence tool that allows you to import data and transform it as necessary.

This course is for those who want to learn Power Query. Power query, a data connection technology that allows you to connect, refine and discover data from multiple sources in order to meet your analysis needs, is what the course is designed for.

This course will teach you the basics of Power query, then how to format dates and values in Excel PowerQuery and trim and transform Data in Excel PowerQuery. Excel Power Query will teach you how to extract data from folders, and perform autocleanup. Additionally, you will learn how to combine and shape data to meet analysis requirements.

Course Overview

projects-img

Personlized Teaching

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Learn about the fundamentals of power query and the query editor ribbon

Know how to trim in excel power query

Understand how to format dates and values in excel power query

Parse URLs in excel power query

Understand split text fields

Learn to unpivot columns

Learn about “Group by” in power query

Course Accreditations

Course Reviews

Average Rating Based on 4 reviews

5.0

100%

Course Cover