20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for December 2024 exams.
Get your discount code >>

Excel for (Trainee) Accountants

This topic has 1 reply, 2 voices, and was last updated 5 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: 600
– 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.