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