50 things you didnt know Excel can DO πŸ’‘ @chandoo_
50 things you didnt know Excel can DO πŸ’‘  @chandoo_
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() 🀣
50 things you didnt know Excel can DO πŸ’‘How to Find the Highest Value in Excel Instantly!Welcome to Chandoo.org on YouTube πŸ‘‹How to use SQL with Power BI πŸ’‘ ~ End-to-end Demo with Sample FilesHow to make $100,000+ with Excel Skills (6 strategies)End to End Power Query Data Cleaning Masterclass [FREE Workbook]Dont tell my boss, but AI is doing all my Excel work now 🀫Learn ALL the useful Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts (with file πŸ“)Excel SCAN Function is Shockingly Powerful! [Step-by-Step]This Excel Trick Finds the Last 5 Salaries Instantly!How I Tracked 5 Stocks in Excel With One Formula!You need these 4 Excel Skills if you run a Small Business
Chandoo |

50 things you didn't know Excel can DO πŸ’‘

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER