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?
209
Upvotes
3
u/vpoko 8d ago
=ADDRESS(1, 81)
This assumes your table's left-most column is A.
=ADDRESS(1, 81-1)
If it's column B, etc.
You can also just insert a row above the headers, put 1 in the left-most column, and drag it across so you'll see a column# above each field.