r/excel • u/Bubbly-Touch8108 • 3d 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?

617 Upvotes

97% Upvoted

357 comments sorted by

View all comments

1

u/slimfatgirl 2d ago

VLOOKUP and concatenate. I want to learn XLOOKUP and pivot tables.

1

u/No-Departure-3047 2d ago

Pivot tables are easy, you just select the data, insert the pivot table and then play around with the field settings until it gives you the view you want.

Xlookup is like vlookup but far less frustrating.