Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Tips Excel Profile picture
@gudanglifehack
May 21 • 25 tweets • 2 min read • Read on X
Scrolly
Thread 🧵: Master Excel Fast! 24 Essential Shortcuts & Formulas 💻✨

(Save this before disappearing). Image
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

• • •

Missing some Tweet in this thread? You can try to force a refresh
　

Keep Current with Tips Excel

Tips Excel Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @gudanglifehack

Tips Excel Profile picture
May 11
Claude can now act as a senior travel hacker to find $5,000 first-class experiences for pennies.

Here are 7 powerful prompts to travel the world like a millionaire on a student budget:

(Save and do this).
1. The Flight Error Finder

Prompt: "I want to fly from [Origin] to [Destination] in [Month]. List 3 'Hidden City' ticketing routes or nearby airport hubs that can cut my flight cost by at least 40%."
2. The Credit Card Point Optimizer

Prompt: "I have [Number] points with [Bank/Airline]. Plan a dream trip to [Location] and show me exactly how to transfer these points to partner airlines for a 3x value increase."
Read 9 tweets
Tips Excel Profile picture
May 10
Final Interview:
"We’d like to offer you the position at $85,000."

Most people say: "That sounds great, thank you!"

Stop. You just left $10,000+ on the table in 5 seconds.

Say this instead:

(Save this for later).
1. The "Golden Rule" of Timing

Never be the first to mention a number. If they ask for your "salary expectations" early on, say: "Right now, I’m focused on seeing if I’m the right fit. I’m sure we can reach a fair agreement on compensation once we see the value I can bring."
2. The "Silence" Strategy

When the recruiter finally gives you the number, do not speak. Count to 5 in your head while looking at the offer. Silence creates a "negotiation vacuum." Often, the recruiter will get nervous and say: "Now, there might be a little room for flexibility on that base..."
Read 12 tweets
Tips Excel Profile picture
May 10
During a job interview, when they ask “Where do you see yourself in 5 years?”

HERE ARE 10 HONEST ANSWERS THAT ACTUALLY WORK:

(Save this before disappearing).
A lot of people freeze on this question.

They think there’s a right answer.

Something about leadership or ambition or climbing a ladder.

There isn’t.
Here’s what’s actually happening when they ask this.

They want to know where you’re headed.

Whether this role fits that direction.

Whether you’ve thought about it at all.
Read 19 tweets
Tips Excel Profile picture
May 10
25 BORING HUSBAND HABITS THAT WILL MAKE YOUR WIFE SEE YOU DIFFERENTLY BY JULY:

1. Put your phone face down when she walks into the room. Every single time.

(Save this before disappearing).
2. Greet her first when you walk in. Before the couch. Before the fridge. Her.

3. Make her morning drink the way she likes it. Without being asked.

4. Text her one specific thing you noticed about her today. Not "miss you." Specific.

5. Ask how she's really doing tonight. Then wait for the real answer.
6. Do one thing around the house before she notices it needs doing.

7. Sit at the dinner table with no screen. Every night this week.

8. Go to bed at the same time as her. Even when you're not tired.

9. Apologize without the "but." Just the apology. Clean. Complete.

10. Remember one small thing she mentioned in passing. Act on it this week.
Read 7 tweets
Tips Excel Profile picture
May 9
8 rules that will solve 80% of your problems. Read them. Save them. Use them.

(Save this before it disappears).
1. If you're sad — run.
Sadness is stagnant energy. Movement forces it through you. You don't need motivation. You just need to put one foot in front of the other. After 10 minutes, your chemistry shifts. After 20, you remember what it
feels like to feel something else.
2. If you have no ideas — read.
Creativity is not magic. It's input. You can't generate something from nothing. Read one page. One
paragraph. One quote. Let someone else's words unstick yours.
Read 10 tweets
Tips Excel Profile picture
May 9
When you’re asked, “Tell me about yourself” during a job interview.

Here’s a list to use (top 3):

(Save this thank me later).
This question is the most important one in the interview, because it sets the frame for everything that follows.

Most people ramble. You won’t.

The winning structure (always works)

Present → Past → Future (role-focused)
30–60 seconds. No life story.
1. Universal, for any role

“I’m someone who’s very organized, reliable, and focused on doing quality work.

I’ve spent the last [X] years working in [field/type of role], where I’ve been responsible for [1–2 relevant responsibilities]. In that time, I’ve learned how to [key skill tied to the job] and work effectively with different people and priorities.

Right now, I’m looking to grow in a role where I can contribute consistently, keep improving my skills, and add value to a team like yours.
Read 8 tweets

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

Send Email!

:(