50 things you didn't know Excel can DO 💡

💥 Get ready to be surprised and amazed.
👉 FREE Excel + Power BI tips newsletter - https://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 -    • Top 30 *Advanced* Excel Tips to make ...   (300k+ views)
5 Amazing Conditional Formatting Tricks -    • 5 Conditional Formatting tips to make...   (140k views)
5 Advanced Tips on IF formula -    • 5 Advanced Tips on how to use IF form...   (140k views)
10 things my boss was doing in Excel -    • I saw my boss do these 10 things in E...   (2.3 mn views, that is right, 2.3 mn!)
10 things you thought Excel couldn't do -    • 10 things you thought Excel couldn't ...   (100k views)
10 Copy Paste Tricks -    • 10 *SURPRISING* Copy Paste Secrets fo...   (200k views)
Data Cleaning - 10 tips -    • Data Cleaning in Excel - 10 Tricks (B...   (300k views)
10 More Data Cleaning tricks -    • Data cleaning in Excel - 10 tricks *P...   (450k views)
AI in Excel - 5 AWESOME Features -    • 10x your productivity with these AI t...   (380k views)


~

#excel #exceltips #doyouknow

~

Why can't Excel ever marry?
It is waiting for the exact MATCH() 🤣