Thread 🧵: Master Excel Fast! 24 Essential Shortcuts & Formulas 💻✨
(Save this before disappearing).
1/ Excel can save you hours if you know the right tricks! Today, I’ll share 24 essential shortcuts & formulas + what they do. Ready to level up? 🚀
2/ CTRL + C / CTRL + V – Copy & Paste. Essential for duplicating data or formulas quickly. Use CTRL + ALT + V for Paste Special (values, formatting).
3/ CTRL + Z / CTRL + Y – Undo & Redo. Mistake? Fix instantly or redo last action. Saves stress and time.
4/ CTRL + SHIFT + L – Toggle Filters. Quickly filter large datasets to analyze or clean data efficiently.
5/ CTRL + ARROW KEYS – Navigate edges of your data. Jump to the last filled row or column in seconds.
6/ F2 – Edit a cell without touching the mouse. Perfect for tweaking formulas in-place.
7/ ALT + = – AutoSum. Automatically sums a range of numbers—no typing needed!
8/ CTRL + T – Create a Table. Makes your data dynamic, sortable, and formatted instantly.
9/ CTRL + ; / CTRL + SHIFT + ; – Insert current date / time. Ideal for timestamps or logs.
10/ VLOOKUP() – Search a value vertically. Example: =VLOOKUP(A2, Data!A:B, 2, FALSE) pulls matching data from another table.
11/ HLOOKUP() – Search a value horizontally. Example: =HLOOKUP(B1, Data!1:2, 2, FALSE) for row-based lookups.
12/ INDEX() + MATCH() – Flexible lookup alternative. Find any value without column restrictions. Example: =INDEX(B:B, MATCH("Apple", A:A, 0))
13/ SUM() – Add numbers in a range. Example: =SUM(B2:B10) sums up sales, expenses, or totals.
14/ SUMIF() / SUMIFS() – Add numbers conditionally. Example: =SUMIF(A2:A10, "Apple", B2:B10) sums only Apple sales.
15/ COUNT() / COUNTA() – Count numbers or all filled cells. Example: =COUNT(A2:A10) counts numbers only.
16/ IF() – Conditional logic. Example: =IF(A2>100, "High", "Low") decides based on criteria.
17/ CONCAT() / CONCATENATE() – Combine text. Example: =CONCAT(A2," ",B2) → “John Doe”.
18/ TEXT() – Format numbers or dates. Example: =TEXT(TODAY(),"DD-MMM-YYYY") → “21-May-2026”.
19/ PROPER() / UPPER() / LOWER() – Adjust text case. =PROPER(A2) capitalizes each word.
20/ LEFT() / RIGHT() / MID() – Extract text. =LEFT(A2,5) → first 5 characters; =MID(A2,2,4) → middle text.
21/ ROUND() / ROUNDUP() / ROUNDDOWN() – Control decimals. =ROUND(A2,2) → rounds to 2 decimal places.
22/ PMT() – Loan payments calculator. Example: =PMT(5%/12,12*5,-10000) → monthly payment.
23/ CTRL + SHIFT + “$” / “%” / “#” – Format currency, percent, or date instantly. Saves clicks!
24/ Master these shortcuts & formulas, and your Excel skills will skyrocket! 🚀 Don’t forget to save this thread and follow @gudanglifehack for more tips! 💡 #Excel #Productivity #LifeHack
Share this Scrolly Tale with your friends.
A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.