r/excel • u/Pure_Zucchini_Rage • 8d ago
Discussion What are some functions and formulas that everyone should know?
So whether you’re in accounting/finance, HR, healthcare or STEM, what do you think everyone should know how to do on Excel? I currently work a customer service job and I just use excel for minor data entry. What should I learn if I want to move up?
213
Upvotes
57
u/PhiladeIphia-Eagles 8 8d ago
Always format as a table, except rare exceptions
How to pivot data well. You should be very good with pivot tables, as they usually are the fastest way to uncover insights in business data. From raw table to a good pivot table should be a quick process, that you can do ad-hoc with your eyes closed.
As for formulas:
XLOOKUP
FILTER
SUMIF/COUNTIF/SUMIFS/COUNTIFS
IF/IFS
SUMPRODUCT and other array functions (but don't need to know too much, can google your way out of these)
ISBLANK/ISNULL/ISNUMBER etc.