? 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() ?