-
Get and Transform Data – Your first look at Power Query
14 Lessons-
PreviewCourse Introduction
-
PreviewPower Query Learn and Earn Activities
-
StartModule 1 - Introduction
-
StartWhat is Power query
-
StartWhat is Power Query?
-
StartHow to connect to Excel
-
StartConnecting to your first set of data
-
StartHow do I find my way around power query?
-
PreviewPower Pivot Orientation
-
StartConnecting to TXT and CSV files
-
StartHow do I connect to a TXT or CSV file
-
StartHow do I connect to web data?
-
StartConnecting to Web Data
-
StartActivity
-
-
Combining Files and Simple data Transformations.
12 Lessons-
StartModule 2 Introduction
-
StartWhat are query setting properties and applied steps
-
StartApplied Steps
-
StartWhy and how do I append queries
-
PreviewAppend Queries
-
StartWhy and how do I merge queries
-
StartMerge Queries
-
StartMerge Types
-
StartImpact of merge types
-
StartHow do I combine a folder containing Excel Files
-
StartActivity
-
StartActivity solution
-
-
Column and Row Transformations
10 Lessons-
StartModule 3 Introduction
-
StartHow do I manage and work with Columns in a Power Query table?
-
StartHow to manage columns
-
StartHow do I replace values and fill data?
-
StartReplace and Fill data
-
StartHow do I use filter or reduce the rows?
-
StartHow to reduce rows
-
StartWhat are data types and how do I change them
-
StartData types
-
StartActivity
-
-
Power Query Table Transformations
12 Lessons-
StartModule 4 introduction
-
StartHow can I work with Text columns
-
StartText columns
-
StartGrouping Data
-
StartPower Query Group by
-
StartHow and when would you use Transpose?
-
StartHow can you pivot and unpivot data?
-
StartWork with Pivot and Transpose transformations
-
StartPutting it all together
-
StartPutting it together
-
StartActivity
-
StartActivity Solution
-
-
Adding Columns in Power Query
12 Lessons-
StartModule 5 Introduction
-
StartHow do I add columns by Example
-
StartAdding columns by example
-
StartHow do I add custom columns
-
StartHow do I add Conditional Columns
-
StartAdding Connditional columns
-
StartHow do I add Index Columns
-
StartCan I add other column types
-
StartAdding other columns
-
StartActivity
-
StartActivity 1 solutions
-
StartActivity 2 solutions
-
-
Connecting and Transforming More Complex Data Structures
18 Lessons-
StartModule 6 Introduction
-
StartHow to I work with Records and Lists contained within columns of a dataset?
-
StartList Records
-
StartWhat is JSON Data
-
StartHow to connect to JSON from Excel
-
StartConnecting to json with powerquery
-
StartHow do I parse JSON data in Power Query
-
StartParse JSON
-
StartLearn and Earn activity (JSON)
-
StartHow can I get a list of file names and file details from a folder?
-
StartFile names and details
-
StartHow can I duplicate or reference a query
-
StartDuplicate and reference queries
-
StartActivity 1
-
StartActivity 1 solution
-
StartActivity 2
-
StartActivity 2 solution
-
StartLearn and Earn Activity (reconcile accounts with power query)
-
-
Mashup An Introduction to M
11 Lessons-
StartModule 7 Introduction
-
StartWhat is M and the advanced editor
-
StartAn Introduction to M
-
StartHow do I read and write M
-
StartHow do I create lists and records in M
-
StartGetting your head around M
-
StartHow can I use M on custom columns
-
StartActivity
-
StartActivity solutions
-
StartActivity 2
-
StartActivity 2 solutions
-
-
Introduction to Parameters and Custom Functions in Power Query
11 Lessons-
StartModule 8 Introduction
-
StartWhat are Parameters in Power query
-
Starthow can I use parameters to filter
-
StartFilter parameters
-
StartWhat is a custom function in Power Query
-
StartCustom functions
-
StartHow can I use a parameter table in Excel
-
StartParameters in Excel
-
StartActivity
-
StartActivity solution
-
StartConclusion
-
Power Query Excel 365
Get, Clean and Transform Data like a Pro in Excel Power Query
Course Summary
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.
This course is a hands-on practical course with workbooks to download and activities to complete
Course Curriculum
Paula Guilfoyle
After over 10 years in Accounting and Operations Paula turned her career to subject matter expert, consultant, content creation and online education. In 2010 Paula began teaching online and can now boast over 250K students in 186 different countries. In 2016 Paula began her learning journey around Blockchain and Cryptocurrency. By 2022 Paula pivoted her consultancy, content creation and online education to focus on Blockchain, Web3 and Digital Assets.
