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 and Tricks
0:34 – Duplicate file quickly
0:54 – Adding buttons to QAT
1:31 – Move QAT below
1:40 – Create your own list in Excel
2:39 – GPS in Excel
3:12 – Clipboard Tool
3:50 – Pin files for quick access
4:13 – Excel uses a single sheet by default
4:45 – Change Excel color
5:14 – One shortcut to rule them all
5:53 – Top 10 filter
6:08 – Sort on multiple columns
6:43 – Screenshots / screenshots in Excel
7:44 – Hide things with ;;;
8:34 – Rotate text in cells
8:49 – Select numbers only
9:22 – New line in a cell
9:42 – Find and highlight all matching values at once
10:37 – Browser (bird's eye view of Excel workbook)
11:31 a.m. – Image data
12:52 – TAKE function (Excel 365)
13:32 – Quickly edit formula ranges
14:07 – Move help text
14:19 – Single function (Excel 365)
2:50 p.m. – Image in cell (Excel 365)
16:32 – Formulatext function
4:50 p.m. – Debug formulas with F9
17:26 – Formula result tooltip (Excel 365)
5:40 p.m. – Reverse formula with goal search
6:26 p.m. – Excel.new for new files
7:07 p.m. – Recommended pivots
7:27 p.m. – Move pivot fields/row labels
7:40 p.m. – Hide buttons in pivot tables
19:54 – Multiple pivots in one click
8:30 p.m. – Slice those pivots
20:53 – Sort list of pivot table fields
21:12 – Separate count in the pivots
9:41 p.m. – Median in pivots (with DAX)
10:25 p.m. – Set your own pivot table defaults
11:10 p.m. – Easily hide elements in chart
11:33 p.m. – Filters and charts
24:02 – Dynamic chart titles
24:32 – Emoji in graphics
25:04 – Small graphics with sparklines
26:09 – Images in charts
26:49 – Negative values in a different color chart
27:38 – Combined Charts
28:16 – Adjust graph range with mouse
28:54 – Recommended graphics
29:26 – 50 is a lot!!!
MORE TIPS COLLECTIONS
Do you like this video ? You will also love these videos.
30 Advanced Excel Tips and Tricks – https://youtu.be/m2C_-6PW6WE (300,000 views)
5 Amazing Conditional Formatting Tips – https://youtu.be/El28a08cXIU (140,000 views)
5 advanced tips on the IF formula – https://youtu.be/15NtFld9mVM (140,000 views)
10 things my boss did in Excel – https://youtu.be/HgfC3etOgsU (2.3 mins views, that's right, 2.3 mins!)
10 Things You Thought Excel Couldn't Do – https://youtu.be/HcY8sYesI3Y (100,000 views)
10 Copy-Paste tips – https://youtu.be/uQoRef0L5Yw (200,000 views)
Data cleaning – 10 tips – https://youtu.be/q7EpoOwBcnM (300,000 views)
10 more data cleaning tips – https://youtu.be/SNVjndgWBlw (450,000 views)
AI in Excel – 5 AWESOME Features – https://youtu.be/xGqH__hLVcU (380,000 views)
#excel #exceltips #doyouknow
Why can Excel never get married?
It waits for the exact MATCH()
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments