Mike Tholfsen's Micro Tips on Excel

Mike Tholfsen often shares nifty Excel tips through short Tiktok videos (<1m).  These are inaccessible in India as the domain is blocked but you can view them on Twitter where he posts the same videos. Here's a compilation of his tips that I found useful -

  1. Extract first names from a list using the LEFT() function
  2. Sequence() function for calendar dates
  3. Sequence() to automate a big list of numbers 
  4. SUMIF() formula
  5. VLOOKUP
  6. Extract names out of a list of email addresses with a single shortcut -Ctrl T, Flash fill
  7. Bulk-delete blank rows in Excel in 11 seconds
  8. Excel Geography data type - Data > Data Types | Geography 
  9. Auto-size rows and columns quickly in Excel using keyboard shortcuts - Ctrl+A, Alt H+O+A, Alt H+O+I
  10. AutoSum rows or columns - Alt+=
  11. Quick Analysis tool to gain insights - Ctrl+Q
  12. Pivot Table

Comments

Popular posts from this blog

Maven Crash Course - Learn Power Query, Power Pivot & DAX in 15 Minutes

"Data Prep & Exploratory Data Analysis" course by Maven Analytics

Oracle Cloud Infrastructure 2024 Generative AI Professional Course & Certification Exam (1Z0-1127-24)