56 Essential Microsoft Excel Tips — Right Here!

Introduction

I am frequently coming across tips & tricks for all the different programs and tools that I use. Especially Excel!

I am accumulating these tips to create a resource down the road…so much great content to review and share!

So, I’ve decided to share some of the content that has caught my eye with all my followers!

I hope you find this as useful as I do!

#1 — Using a Slicer on a Dashboard (Bill Jelen, aka, “Mr. Excel” — YouTube)

I love this tip from Bill Jelen (“Mr Excel”) included in the July issue of Strategic Finance Magazine. A truly unique approach to using Slicers and Excel’s Dynamic Arrays functions!

Don Tomoff, MBA, CPA on LinkedIn: #twinztalk #twinztechtip #ms365

#2 — Top 25 Microsoft Excel Tips and Tricks for 2021 // NEW features, hidden gems and time-saving tips (Mike Tholfson — YouTube)

A great compilation of tips from Mike Tholfson on YouTube! All of these tips are excellent, but I have indicated my FAVS with ✅.

1. 0:10 Import PDF ✅
2. 1:08 Analyze Data (Formerly “Ideas in Excel”) ✅
3. 2:57 Flash fill ✅
4. 3:59 Geography and Map data
5. 4:54 Version History
6. 5:50 One-click email as attachment or PDF
7. 6:44 XLOOKUP ✅
8. 8:26 Diagonal cell formatting
9. 8:58 Sparklines ✅
10. 9:20 The best keyboard shortcuts
11. 10:57 Auto-size columns or rows ✅
12. 11:21 Sheet Background
13. 12:01 Delete Blank Rows
14. 12:25 Conditional Formatting ✅
15. 13:18 Stock History and Wolfram Alpha ✅
16. 14:25 Screen shot/camera
17. 15:24 Drop Down lists ✅
18. 16:10 Customize the Quick Access Toolbar (QAT) ✅
19. 16:52 Pivot table ✅
20. 18:58 Right drag fill series
21. 19:25 Casing functions (UPPER/LOWER/PROPER)
22. 19:58 Color your tabs/shortcuts
23. 20:20 Photo of Excel table
24. 21:13 Import data from web ✅
25. 21:49 Excel speaks

No question there are a few in here that will up ⬆️ your Excel productivity! 🤔💪

#3–30 *Advanced* Excel Tips & Tricks to make you awesome (Chandoo — YouTube)

One of my favorite Excel experts to follow is Chandoo! He did not disappoint with this fantastic collection of tips! All of these tips are excellent, but I have indicated my FAVS with ✅.

* indicates that Excel 365 is required to use the tip. All other tips should work in any modern version of Excel.

1. 0:55 — New FILTER function * ✅
2. 1:51 — CHAR(10) Trick
3. 2:46 — CTRL SHIFT 4 — quick currency format ✅
4. 3:06 — Using SUBTOTAL function ✅
5. 3:34 — Slicers on Table ✅
6. 4:25 — Mini charts with REPT() trick ✅
7. 5:19 — Finding 2nd largest value
8. 5:58 — CTRL SHIFT 3 — quick date format
9. 6:17 — Quick number formats in pivots ✅
10. 6:46 — Easy interactive chart trick ✅
11. 7:20 — ☝ Slicer ✌ Charts ✅
12. 7:57 — Year to date totals in Pivots
13. 8:45 — CTRL F1 — Collapse / expand ribbon
14. 9:06 — Adding subtitle (caption) to charts
15. 9:52 — NEW Treemap chart * ✅
16. 10:37 — Tiny charts, big impact
17. 11:24 — Free ICONS to spice up your reports *
18. 11:51 — Lookup from bottom *
19. 12:45 — CTRL G — Go anywhere
20. 13:28 — Quick Age grouping in pivots ✅
21. 14:18 — Rearrange pivot row labels in any order ✅
22. 14:46 — Make sense of large pivots easily ✅
23. 15:45 — Fix date formats with this trick
24. 16:38 — Emojis in your formulas 😀😂🤩
25. 17:30 — Get live stock (share) prices in Excel * ✅
26. 18:36 — Printing trick 🖨📰⚡
27. 19:24 — Databars, but not too long ✅
28. 20:24 — F7 — Spellcheck
29. 20:43 — Smart chart titles
30. 21:19 — Hide away charts temporarily ✅

Which tips are new to you? Hope you picked up a few!

About Don

“It’s time for different”

Connect with Don!

LinkedIn, Flipboard, Twitter, Snapchat