@prompt.and.polish: If I got a dollar every time someone asked me to fix their spreadsheet, I’d be rich by now. 😂 So I’m creating an account to document my Excel tips, starting from the basics. First up: 5 formulas that quietly do half the work, each with an example you can copy straight into your sheet. Save it & follow for more Excel, automation + AI. Which one’s new to you? #excel #exceltips #spreadsheets #learnexcel

Isaac Hernandez :

I don’t use formulas anymore. I know how to use power query. 💪💪💪

Black_Clover :

These formulas are the fundamentals, but power query will take you further!

user4886599018078 :

What’s different between vlookup and xlookup?

glumking :

I don't need this. Copilot does it for me now.

baristareignonIG :

what about vlookup?

ron :

Why use Text split when you can just use the text to column excel has already?

mochi :

Uncs you don’t need INDEX or MATCH anymore, just you xlookup. You can nest xlookup and you don’t have to put FALSE OR 0 for exact match.

Jim Yatteau :

I did not know about UNIQUE and FILTER. Thank you, I’m sure I can find use of those.

Froog :

whats difference between xlookup and vlookup? I only use vlookup thank you for answering

Miguel :

The trim function is actually really useful. I use it all the time within xlookup to ensure data matches.

sheils🍊🍑 :

TextJoin instead of Concat

Lan :

sumproduct is underrated

KRniv0R :

here's something, pivot your data to a single column and insert slicer, write your filter with pivot range as criteria, now have a filter output with control

lyssaaa :

What Excel formula can I use to find a specific amount within multiple rows of data? tyy

ro.riches :

I use flash fill instead of text split

Onyemalu Francis :

starting Excel new n I'm already feeling lost n confused...

Edmund Legitimas :

you need MATCH, CHOOSE, INDEX, ISNUMBER

Kaye DJ :

let x find you! 🤭

uhhhhhhas :

Would concat formula achieve textsplit to a more precise degree?

Alice.barronn :

How did you get Claude to make this

อิสระ :

concat also.

Notion HolyGrail :

are there still people using excel spreadsheets in 2026? wow

╔═══❖•ೋ° Bukhari °ೋ•❖═══╗ :

MentAly DistUrb🍁 :

can anyone help me to understand the use of sumif and countif

ShobiWonKenobi :

Index, match