Zenler Player
Your course is loading. Hang tight.
Power Query Excel 365
Back to curriculum
0% Complete
0% Complete
Course Introduction
Power Query Learn and Earn Activities
Module 1 - Introduction
What is Power query
What is Power Query?
How to connect to Excel
Connecting to your first set of data
How do I find my way around power query?
Power Pivot Orientation
Connecting to TXT and CSV files
How do I connect to a TXT or CSV file
How do I connect to web data?
Connecting to Web Data
Activity
Module 2 Introduction
What are query setting properties and applied steps
Applied Steps
Why and how do I append queries
Append Queries
Why and how do I merge queries
Merge Queries
Merge Types
Impact of merge types
How do I combine a folder containing Excel Files
Activity
Activity solution
Module 3 Introduction
How do I manage and work with Columns in a Power Query table?
How to manage columns
How do I replace values and fill data?
Replace and Fill data
How do I use filter or reduce the rows?
How to reduce rows
What are data types and how do I change them
Data types
Activity
Module 4 introduction
How can I work with Text columns
Text columns
Grouping Data
Power Query Group by
How and when would you use Transpose?
How can you pivot and unpivot data?
Work with Pivot and Transpose transformations
Putting it all together
Putting it together
Activity
Activity Solution
Module 5 Introduction
How do I add columns by Example
Adding columns by example
How do I add custom columns
How do I add Conditional Columns
Adding Connditional columns
How do I add Index Columns
Can I add other column types
Adding other columns
Activity
Activity 1 solutions
Activity 2 solutions
Module 6 Introduction
How to I work with Records and Lists contained within columns of a dataset?
List Records
What is JSON Data
How to connect to JSON from Excel
Connecting to json with powerquery
How do I parse JSON data in Power Query
Parse JSON
Learn and Earn activity (JSON)
How can I get a list of file names and file details from a folder?
File names and details
How can I duplicate or reference a query
Duplicate and reference queries
Activity 1
Activity 1 solution
Activity 2
Activity 2 solution
Learn and Earn Activity (reconcile accounts with power query)
Module 7 Introduction
What is M and the advanced editor
An Introduction to M
How do I read and write M
How do I create lists and records in M
Getting your head around M
How can I use M on custom columns
Activity
Activity solutions
Activity 2
Activity 2 solutions
Module 8 Introduction
What are Parameters in Power query
how can I use parameters to filter
Filter parameters
What is a custom function in Power Query
Custom functions
How can I use a parameter table in Excel
Parameters in Excel
Activity
Activity solution
Conclusion
Get and Transform Data – Your first look at Power Query
Course Introduction
Preview
Power Query Learn and Earn Activities
Preview
Module 1 - Introduction
What is Power query
What is Power Query?
How to connect to Excel
Connecting to your first set of data
How do I find my way around power query?
Power Pivot Orientation
Preview
Connecting to TXT and CSV files
How do I connect to a TXT or CSV file
How do I connect to web data?
Connecting to Web Data
Activity
Combining Files and Simple data Transformations.
Module 2 Introduction
What are query setting properties and applied steps
Applied Steps
Why and how do I append queries
Append Queries
Preview
Why and how do I merge queries
Merge Queries
Merge Types
Impact of merge types
How do I combine a folder containing Excel Files
Activity
Activity solution
Column and Row Transformations
Module 3 Introduction
How do I manage and work with Columns in a Power Query table?
How to manage columns
How do I replace values and fill data?
Replace and Fill data
How do I use filter or reduce the rows?
How to reduce rows
What are data types and how do I change them
Data types
Activity
Power Query Table Transformations
Module 4 introduction
How can I work with Text columns
Text columns
Grouping Data
Power Query Group by
How and when would you use Transpose?
How can you pivot and unpivot data?
Work with Pivot and Transpose transformations
Putting it all together
Putting it together
Activity
Activity Solution
Adding Columns in Power Query
Module 5 Introduction
How do I add columns by Example
Adding columns by example
How do I add custom columns
How do I add Conditional Columns
Adding Connditional columns
How do I add Index Columns
Can I add other column types
Adding other columns
Activity
Activity 1 solutions
Activity 2 solutions
Connecting and Transforming More Complex Data Structures
Module 6 Introduction
How to I work with Records and Lists contained within columns of a dataset?
List Records
What is JSON Data
How to connect to JSON from Excel
Connecting to json with powerquery
How do I parse JSON data in Power Query
Parse JSON
Learn and Earn activity (JSON)
How can I get a list of file names and file details from a folder?
File names and details
How can I duplicate or reference a query
Duplicate and reference queries
Activity 1
Activity 1 solution
Activity 2
Activity 2 solution
Learn and Earn Activity (reconcile accounts with power query)
Mashup An Introduction to M
Module 7 Introduction
What is M and the advanced editor
An Introduction to M
How do I read and write M
How do I create lists and records in M
Getting your head around M
How can I use M on custom columns
Activity
Activity solutions
Activity 2
Activity 2 solutions
Introduction to Parameters and Custom Functions in Power Query
Module 8 Introduction
What are Parameters in Power query
how can I use parameters to filter
Filter parameters
What is a custom function in Power Query
Custom functions
How can I use a parameter table in Excel
Parameters in Excel
Activity
Activity solution
Conclusion
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson