Uploaded February 2024 | Updated November 2026, 3 hours ago
My name is Chandoo and my mission is to make you awesome in your work.
I do this by posting weekly videos on various data technologies like,
β Excel
β Power BI
β SQL
β Coding
β Working with Data
I have been doing this for 16+ years now and I really love my work.
It is so good to have you in my channel.
Feel free to subscribe.
Here are my top playlists for learning:
Most Popular Videos on the channel:
youtube.com/playlist?list=PLmejDGrsgFyCcnXXRgXwqzuMu0uCcYD-f
FREE Excel Course:
youtube.com/playlist?list=PLmejDGrsgFyCZ4YC5s8mgdQztj7zt5to5
FREE Power BI Course:
youtube.com/playlist?list=PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo
SQL Concepts:
youtube.com/playlist?list=PLmejDGrsgFyAN92fGoXP7Q4xS5q_021xh
Important Skills for Data Analysts:
youtube.com/playlist?list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
How to make Excel Dashboards:
youtube.com/playlist?list=PLmejDGrsgFyDN-HoP5wlkvq9zKbWM9KtT
Excel VBA Projects & Tutorials:
youtube.com/playlist?list=PLmejDGrsgFyCcACC_FRUFc03XYf1Mxf9k
Data Analysis with Excel
youtube.com/playlist?list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3
FULL LENGTH COURSES:
For Excel:
chandoo.org/wp/excel-school-program
For Power BI:
chandoo.org/wp/power-bi-course
My Website:
chandoo.org/wp
~
Have a beautiful day π»ππ
#Chandoo
My name is Chandoo and my mission is to make you awesome in your work.
I do this by posting weekly videos on various data technologies like,
β Excel
β Power BI
β SQL
β Coding
β Working with Data
I have been doing this for 16+ years now and I really love my work.
It is so good to have you in my channel.
Feel free to subscribe.
Here are my top playlists for learning:
Most Popular Videos on the channel:
youtube.com/playlist?list=PLmejDGrsgFyCcnXXRgXwqzuMu0uCcYD-f
FREE Excel Course:
youtube.com/playlist?list=PLmejDGrsgFyCZ4YC5s8mgdQztj7zt5to5
FREE Power BI Course:
youtube.com/playlist?list=PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo
SQL Concepts:
youtube.com/playlist?list=PLmejDGrsgFyAN92fGoXP7Q4xS5q_021xh
Important Skills for Data Analysts:
youtube.com/playlist?list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
How to make Excel Dashboards:
youtube.com/playlist?list=PLmejDGrsgFyDN-HoP5wlkvq9zKbWM9KtT
Excel VBA Projects & Tutorials:
youtube.com/playlist?list=PLmejDGrsgFyCcACC_FRUFc03XYf1Mxf9k
Data Analysis with Excel
youtube.com/playlist?list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3
FULL LENGTH COURSES:
For Excel:
chandoo.org/wp/excel-school-program
For Power BI:
chandoo.org/wp/power-bi-course
My Website:
chandoo.org/wp
~
Have a beautiful day π»ππ
#Chandoo


![End to End Power Query Data Cleaning Masterclass [FREE Workbook]
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: https://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 End to End Power Query Data Cleaning Masterclass [FREE Workbook]](https://i.ytimg.com/vi/UhD3LbbimZ0/mqdefault.jpg)


![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)




