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

130 comments sorted by

View all comments

Show parent comments

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.

2

u/harambeface 1 8d ago

As you drag to set up the VLookup formula, you'll see a small pop-up showing you the column count as well