Uploaded August 2023 | Updated November 2026, 1 day ago
π₯ Get ready to be surprised and amazed.
π FREE Excel + Power BI tips newsletter - chandoo.org/wp/subscribe
Here are the 50 things you didn't know Excel can do.
0:00 - 50 Advanced Excel Tips & Tricks
0:34 - Duplicate file quickly
0:54 - Adding buttons to QAT
1:31 - Move QAT below
1:40 - Make your own list in Excel
2:39 - GPS in Excel
3:12 - Clipboard Tool
3:50 - Pin files to quickly access them
4:13 - Excel defaults to one sheet
4:45 - Change Excel color
5:14 - One shortcut to rule them all
5:53 - Top 10 filter
6:08 - Sort by more than one column
6:43 - Screenshots / screencaps in Excel
7:44 - Hide things with ;;;
8:34 - Rotate text in cells
8:49 - Select just numbers
9:22 - New line in a cell
9:42 - Find and highlight all matching values in one go
10:37 - Navigator (birds eye view of Excel workbook)
11:31 - Data from picture
12:52 - TAKE function (Excel 365)
13:32 - Edit formula ranges quickly
14:07 - Move help text away
14:19 - Unique function (Excel 365)
14:50 - Image in cell (Excel 365)
16:32 - Formulatext function
16:50 - Debug formulas with F9
17:26 - Formula result tooltip (Excel 365)
17:40 - Reverse formula with goalseek
18:26 - Excel.new for new files
19:07 - Recommended pivots
19:27 - Move pivot fields / row labels
19:40 - Hide the + buttons in pivot tables
19:54 - Multiple pivots with one click
20:30 - Slice those pivots
20:53 - Sort pivot table field list
21:12 - Distinct count in pivots
21:41 - Median in Pivots (with DAX)
22:25 - Set your own Pivot Table defaults
23:10 - Hide items in chart easily
23:33 - Filters & charts
24:02 - Dynamic chart titles
24:32 - Emoji ππ π» in Charts
25:04 - Tiny charts with sparklines
26:09 - Images in charts πΌ
26:49 - Negative values in a different color chart
27:38 - Combo charts
28:16 - Adjust chart range with mouse
28:54 - Recommended charts
29:26 - 50 is a lot!!!
πΊ MORE TIP COLLECTIONS
========================
Like this video? You are going to LOVE these videos too.
30 Advanced Excel Tips & Tricks - youtu.be/m2C_-6PW6WE (300k+ views)
5 Amazing Conditional Formatting Tricks - youtu.be/El28a08cXIU (140k views)
5 Advanced Tips on IF formula - youtu.be/15NtFld9mVM (140k views)
10 things my boss was doing in Excel - youtu.be/HgfC3etOgsU (2.3 mn views, that is right, 2.3 mn!)
10 things you thought Excel couldn't do - youtu.be/HcY8sYesI3Y (100k views)
10 Copy Paste Tricks - youtu.be/uQoRef0L5Yw (200k views)
Data Cleaning - 10 tips - youtu.be/q7EpoOwBcnM (300k views)
10 More Data Cleaning tricks - youtu.be/SNVjndgWBlw (450k views)
AI in Excel - 5 AWESOME Features - youtu.be/xGqH__hLVcU (380k views)
~
#excel #exceltips #doyouknow
~
Why can't Excel ever marry?
It is waiting for the exact MATCH() π€£
π₯ Get ready to be surprised and amazed.
π FREE Excel + Power BI tips newsletter - chandoo.org/wp/subscribe
Here are the 50 things you didn't know Excel can do.
0:00 - 50 Advanced Excel Tips & Tricks
0:34 - Duplicate file quickly
0:54 - Adding buttons to QAT
1:31 - Move QAT below
1:40 - Make your own list in Excel
2:39 - GPS in Excel
3:12 - Clipboard Tool
3:50 - Pin files to quickly access them
4:13 - Excel defaults to one sheet
4:45 - Change Excel color
5:14 - One shortcut to rule them all
5:53 - Top 10 filter
6:08 - Sort by more than one column
6:43 - Screenshots / screencaps in Excel
7:44 - Hide things with ;;;
8:34 - Rotate text in cells
8:49 - Select just numbers
9:22 - New line in a cell
9:42 - Find and highlight all matching values in one go
10:37 - Navigator (birds eye view of Excel workbook)
11:31 - Data from picture
12:52 - TAKE function (Excel 365)
13:32 - Edit formula ranges quickly
14:07 - Move help text away
14:19 - Unique function (Excel 365)
14:50 - Image in cell (Excel 365)
16:32 - Formulatext function
16:50 - Debug formulas with F9
17:26 - Formula result tooltip (Excel 365)
17:40 - Reverse formula with goalseek
18:26 - Excel.new for new files
19:07 - Recommended pivots
19:27 - Move pivot fields / row labels
19:40 - Hide the + buttons in pivot tables
19:54 - Multiple pivots with one click
20:30 - Slice those pivots
20:53 - Sort pivot table field list
21:12 - Distinct count in pivots
21:41 - Median in Pivots (with DAX)
22:25 - Set your own Pivot Table defaults
23:10 - Hide items in chart easily
23:33 - Filters & charts
24:02 - Dynamic chart titles
24:32 - Emoji ππ π» in Charts
25:04 - Tiny charts with sparklines
26:09 - Images in charts πΌ
26:49 - Negative values in a different color chart
27:38 - Combo charts
28:16 - Adjust chart range with mouse
28:54 - Recommended charts
29:26 - 50 is a lot!!!
πΊ MORE TIP COLLECTIONS
========================
Like this video? You are going to LOVE these videos too.
30 Advanced Excel Tips & Tricks - youtu.be/m2C_-6PW6WE (300k+ views)
5 Amazing Conditional Formatting Tricks - youtu.be/El28a08cXIU (140k views)
5 Advanced Tips on IF formula - youtu.be/15NtFld9mVM (140k views)
10 things my boss was doing in Excel - youtu.be/HgfC3etOgsU (2.3 mn views, that is right, 2.3 mn!)
10 things you thought Excel couldn't do - youtu.be/HcY8sYesI3Y (100k views)
10 Copy Paste Tricks - youtu.be/uQoRef0L5Yw (200k views)
Data Cleaning - 10 tips - youtu.be/q7EpoOwBcnM (300k views)
10 More Data Cleaning tricks - youtu.be/SNVjndgWBlw (450k views)
AI in Excel - 5 AWESOME Features - youtu.be/xGqH__hLVcU (380k views)
~
#excel #exceltips #doyouknow
~
Why can't Excel ever marry?
It is waiting for the exact MATCH() π€£




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


