Let’s Excel
Published in

Let’s Excel

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!

#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

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store