Course Description

The Excel for Accountants (Intermediate) course is a short course covered within 2 months on part time basis. The course is primarily aimed at accounting professionals. It aims to teach eleven important topics that will assist finance staff with daily Excel tasks.Learning to excel at Excel is a great accounting career move. Master the basics of Excel and build a solid foundation in which to build further skills

What you" ll learn in this course?

• Perform calculations using Time and Date functions

• Lookup information using HLOOKUP and VLOOKUP

• Perform more complex lookups using INDEX and MATCH

• Make decisions with IF Statements

• Incorporate logical operators into formulas

• Advanced Formulae

• Create Pivot Tables and Pivot Charts

• Analyse large datasets using Power Pivot

• VBA / Auditing VBA

• Name Management

• Automate common tasks using Macro