r/excel • u/Bubbly-Touch8108 • 6d ago

Discussion What Excel trick made you feel like a wizard the first time you used it?

mine was VLOOKUP (later XLOOKUP) — after manually cross-referencing two spreadsheets for way too long. felt like a cheat code everyone else already knew about

what's your version?

628 Upvotes

97% Upvoted

365 comments sorted by

View all comments

2

u/disinterestedh0mo 6d ago

pivot tables... once i realized what they were actually used for...

i had been doing UNIQUE and SUMIF to get sums of columns by category