Excel for (Trainee) Accountants

This topic has 1 reply, 2 voices, and was last updated 7 years ago by Chris.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
April 4, 2019 at 1:30 pm #511198
dublinacca
Member
- Topics: 8
- Replies: 3
Hi,

What are the Excel skills trainee accounts should have or at least would be ideal to have assuming their firm doesn’t use their own software packages?

Can you recommend a video learning resource that would ideally also supply downloadable Excel files to use alongside the videos?

Thanks.
April 4, 2019 at 2:51 pm #511203
Chris
Member
- Topics: 7
- Replies: 591
– Basic formulae like SUM, MAX, MIN, COUNT
– More advanced formulae like IF, VLOOKUP, SUMIF, SUMIFS, COUNTIF
– Pivot tables
– Macro writing and VBA coding can be useful but only for advanced users, learn the other stuff first

Plenty of stuff on the Web if you have a look.
Author

Posts

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.