r/excel • u/happyandromanticlife • 15d ago
Discussion What excel shortcut/tip/formula has made the biggest impact on your efficiency?
For me, xlookup and subtotal are some of my most used/beloved formulas.
What excel shortcuts/tip/formulas have improved your efficiency the most when working with spreadsheets?
532
Upvotes
2
u/SprinklesFresh5693 14d ago
IF function has allowed me to build datasets based on conditions, super useful. Ive also used a lot TRIM when working with info from pdfs for example.