💥 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 – https://youtu.be/m2C_-6PW6WE (300k+ views)
5 Amazing Conditional Formatting Tricks – https://youtu.be/El28a08cXIU (140k views)
5 Advanced Tips on IF formula – https://youtu.be/15NtFld9mVM (140k views)
10 things my boss was doing in Excel – https://youtu.be/HgfC3etOgsU (2.3 mn views, that is right, 2.3 mn!)
10 things you thought Excel couldn’t do – https://youtu.be/HcY8sYesI3Y (100k views)
10 Copy Paste Tricks – https://youtu.be/uQoRef0L5Yw (200k views)
Data Cleaning – 10 tips – https://youtu.be/q7EpoOwBcnM (300k views)
10 More Data Cleaning tricks – https://youtu.be/SNVjndgWBlw (450k views)
AI in Excel – 5 AWESOME Features – https://youtu.be/xGqH__hLVcU (380k views)
~
#excel #exceltips #doyouknow
~
Why can’t Excel ever marry?
It is waiting for the exact MATCH() 🤣