Excel 365 Power Query – Get and Transform Data like a Pro

Learn how to get and transform data like a pro using Excels Power Query
Instructor:
Paula Guilfoyle
427 students enrolled
English [Auto-generated]
Learn how to transform and clean data using Excels Power Query
Learn how to navigate Power Query and Connect to data sources
Learn how to work with column, row and table transformations
Get an introduction to M
Learn how to use parameters and custom functions

Are you ready to take your data analysis skills in excel to the next level? Do you want to learn how to connect to and transform data like a pro?

This course has been designed to take you from a beginner Power Query user to an advanced user in no time.  Power Up on your Power Query Skills today.

In this course, we will first give you Your first look at Power Query and connecting to data sources. From there we will move into combining data and simple transformations, such a merge and append. We will look in detail at row and column transformations and then we will deep dive into table transformations.

After this, we will move on to more advanced power query. We will learn how to use Power Query to add new columns to our data and we will then Connect and Transform More Complex Data Structures. Finally, we will then introduce you to the powerful M code that runs power query and you will learn how to use parameters and create custom functions

So if you are interested in learning more, why don’t you hop into the preview section and take a look.

This course is a hands-on practical course with workbooks to download and activities to complete

Would you like know more about it? Click here!Close

Getting started with Power Query - Connecting to data and simple transformations

1
Getting started introduction
2
Module 1 Intro
3
What is Power Query
4
What is Power Query?
5
How to connect to Excel
6
Connect to an Excel workbook
7
How do I find my way around Power Query
8
Power Query Orientation
9
How do I connect to CSV or Txt file?
10
Connect to a CSV or Text file
11
How do I connect to web data
12
Connect to webdata
13
Activity
14
Activity Feedback
15
Quiz

take this test to reinforce your knowledge

16
Moving on
17
Combining Files and Simple data Transformations.
18
What are query setting properties and applied steps
19
Applied Steps
20
Why and how do I append queries?
21
How to append queries
22
Why and how to I merge queries?
23
How to merge queries
24
What do the different merge join types do?
25
The impact of merge types
26
How do I combine a folder containing Excel Files
27
Activity
28
Activity solution
29
Quiz

take this quiz to reinforce your learning

Working with Columns and Rows in Power Query tables

1
Module 2 Introduction
2
Working with Columns and Rows in Power Query tables
3
How do I manage and work with columns in a power query table
4
Managing Columns
5
How do I replace values and fill data
6
How to fill up and fill down
7
How do I use filter or reduce rows
8
How to reduce rows
9
What are the data types and how do I change them
10
Data types
11
Activity
12
Activity feedback
13
Quiz

take this quiz now to reinforce your learning

14
Moving on
15
Working with table transformations
16
How can I work with Text columns?
17
Text Columns
18
Grouping Data
19
Grouping
20
How and when would you use Transpose
21
How can I pivot and unpivot data?
22
Pivot, unpivot and Transpose
23
Putting it together
24
Putting it all together
25
Activity
26
Activity Solution
27
Quiz

take this quiz to reinforce your learning

Advanced Data connections and more transformations

1
Module 3 Introduction
2
adding columns
3
How do I add columns by example
4
How do I add custom columns
5
Adding columns by example
6
How do I add conditional columns
7
Adding Conditional Columns
8
How do I add index columns
9
Can I add other column types
10
Adding other columns
11
Activity
12
Activity solution
13
Activity 2 solution
14
Quiz

take this quiz to reinforce your learning

15
Moving On
16
more complex connections
17
How to I work with Records and Lists contained within columns of a dataset?
18
List Records
19
What is JSON Data?
20
How to connect to JSON Data from Excel
21
Connecting to JSON
22
How do I parse JSON Data in Power Query
23
Parse JSON
24
How can I get a list of file names and file details from a folder?
25
File names and details
26
How can I duplicate or Reference a query and how can I change the source data?
27
Removing duplicates
28
Activity 1
29
activity solution
30
Activity 2
31
Activity solution

M is for Mashup, the code of Power Query

1
Module 4 introduction
2
An introduction to M
3
What is M and the Advanced editor
4
An introduction to M
5
How do I Read and Write M?
6
How do I create Lists and Records in M
7
How do I read and write M and how do I create lists and records
8
How can I use M on custom columns
9
activity
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!

Be the first to add a review.

Please, login to leave a review
3f4e396b3cc117a40975eba903453e30
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
51 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion