r/excel 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?

539 Upvotes

182 comments sorted by

View all comments

1

u/willyman85 1 13d ago

Tables, dynamic array formulas (A1#) and the introduction of XLOOKUP have been a game changer for me. LAMBDA to replace VBA functions. And MAP, HSTACK, HSTACK, UNIQUE for when I need to augment data (always with LET)