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