Uploaded April 2026 | Updated November 2026, 3 hours ago
In this beginner to PRO session, learn Power Query to automate data cleaning, transformation tasks. We will be using a real-life dataset to perform data cleaning with Power Query (for Power BI).
Sample workbook: chandoo.org/wp/wp-content/uploads/2026/04/pq-data-cleanup.xlsx
What do I learn?
✔️ Introduction to Power Query in Power BI
✔️ How to understand Power Query UI
✔️ Data cleaning basics (removing columns, renaming)
✔️Text transformation examples
✔️ Working with Date columns
✔️ Conditional (IF THEN ELSE) columns in Power Query
✔️ Business operations on data
✔️ Reference queries (one data source, multiple outputs)
✔️ Dependency view and how to use it
✔️ Automation with Power Query - Parameters
✔️ Fixing errors
✔️ Basic analysis of data in Power BI after Load
✔️ Refresh process
Who is this for?
👶 Power Query beginners
👩💻People who work with lots of data (in Excel or Power BI)
⚙️ Looking to automate / simplify data management / cleaning processes
🚫NOT for people who already know & use Power Query a lot
🕐 Video Chapters
0:00 - Introduction
5:30 - Brief Intro Power Query and how it fits in
11:40 - Sample Data & how to load it into PQ in Power BI
19:00 - Power Query UI Explained
24:00 - Data Cleaning basics with Power Query - Removing columns
28:00 - Date cleanup
32:30 - Text transformations in Power Query
37:30 - Arithmetic operations
41:00 - How to think about Power Query
44:30 - Salary bucket (conditional columns)
52:00 - Reference queries, multiple outputs from one source
56:30 - Using dependency view to understand various queries in your data
58:30 - Introduction to parameters and automation with PQ
1:02:00 - Closing & loading the data, testing everything in Power BI
1:05:30 - Adding new data, changing file names (parameter testing)
1:07:40 - Fixing refresh errors
1:11:00 - Using other sources (demo with SQL Server)
1:13:30 - Q&A
1:26:30 - Doing the same in Excel (demo with Blank Query, Copy pasting M Code)
#POWERQUERY #POWERBI
In this beginner to PRO session, learn Power Query to automate data cleaning, transformation tasks. We will be using a real-life dataset to perform data cleaning with Power Query (for Power BI).
Sample workbook: chandoo.org/wp/wp-content/uploads/2026/04/pq-data-cleanup.xlsx
What do I learn?
✔️ Introduction to Power Query in Power BI
✔️ How to understand Power Query UI
✔️ Data cleaning basics (removing columns, renaming)
✔️Text transformation examples
✔️ Working with Date columns
✔️ Conditional (IF THEN ELSE) columns in Power Query
✔️ Business operations on data
✔️ Reference queries (one data source, multiple outputs)
✔️ Dependency view and how to use it
✔️ Automation with Power Query - Parameters
✔️ Fixing errors
✔️ Basic analysis of data in Power BI after Load
✔️ Refresh process
Who is this for?
👶 Power Query beginners
👩💻People who work with lots of data (in Excel or Power BI)
⚙️ Looking to automate / simplify data management / cleaning processes
🚫NOT for people who already know & use Power Query a lot
🕐 Video Chapters
0:00 - Introduction
5:30 - Brief Intro Power Query and how it fits in
11:40 - Sample Data & how to load it into PQ in Power BI
19:00 - Power Query UI Explained
24:00 - Data Cleaning basics with Power Query - Removing columns
28:00 - Date cleanup
32:30 - Text transformations in Power Query
37:30 - Arithmetic operations
41:00 - How to think about Power Query
44:30 - Salary bucket (conditional columns)
52:00 - Reference queries, multiple outputs from one source
56:30 - Using dependency view to understand various queries in your data
58:30 - Introduction to parameters and automation with PQ
1:02:00 - Closing & loading the data, testing everything in Power BI
1:05:30 - Adding new data, changing file names (parameter testing)
1:07:40 - Fixing refresh errors
1:11:00 - Using other sources (demo with SQL Server)
1:13:30 - Q&A
1:26:30 - Doing the same in Excel (demo with Blank Query, Copy pasting M Code)
#POWERQUERY #POWERBI


![Excel SCAN Function is Shockingly Powerful! [Step-by-Step]
Every heard of SCAN function in Excel? Today, let me show you why you need this function and how it changes the way you solve your data problems. I think SCAN is Magic ✨
You are going learn:
What is SCAN function in Excel
SCAN syntax and application
How to use SCAN to calculate running total quickly
Using SCAN to get Maximum values
SCAN with LAMBDA
Advanced SCAN usage when your data is dynamic
~WHAT IS SCAN FUNCTION~
Scan function in Excel lets us run an operation on a range and returns all the intermediate results.
For example, you can use SCAN function to calculate running total of a range.
~WHAT IS THE SYNTAX OF SCAN~
SCAN(initial_value, range or array, operation)
For example:
=SCAN(0, A1:A10, SUM)
is going to return the running to of the range A1:A10
You can also use LAMBDA functions with SCAN to create more complex calculations.
=SCAN(0, A1:A10, LAMBDA(a, b, SUM(a,b)))
will return the same values as the first SCAN example above.
⏱ Video timestamps:
0:00 - What is SCAN function & Why it is important?
1:46 - Understanding how SCAN works
3:46 - Using SCAN to calculate running MAX
4:57 - Using LAMBDA functions with SCAN
6:38 - How I use SCAN to solve tricky problems
📺 Watch next
How to use LAMBDA function in Excel - https://youtu.be/YrMCkE59ef4
How to use FILTER function in Excel - https://youtu.be/JuTdj2j-9Kg
Top 10 Essential Excel functions - https://youtu.be/HgNCvd8IbSc
📁 Sample Workbook:
If you need a file with SCAN examples, download the scandoo.xlsx here:
https://chandoo.org/wp/wp-content/uploads/2024/03/scandoo.xlsx
~
What is the favourite Excel function of a German Shepard 🐶?
LAMBda... 🐑
#Excel #functions Excel SCAN Function is Shockingly Powerful! [Step-by-Step]](https://i.ytimg.com/vi/VrQSgI596IQ/mqdefault.jpg)







