413 9119 / 5440 9119

Course Detail

img
EA 2 Months

Excel for Accountants (Intermediate)

Course Information

  • Total Students 20 per class
  • Course Duration 2 Months

Description

Excel for Accountants (Intermediate) Course is
a short course that aims to teach eleven important topics that will assist finance staff with daily Excel tasks.

Course Outline

1. Perform calculations using Time and Date functions
2. Lookup information using HLOOKUP and VLOOKUP
3. Perform more complex lookups using INDEX and MATCH
4. Make decisions with IF Statements
5. Incorporate logical operators into formulas
6. Advanced Formulae
7. Create PivotTables and PivotCharts
8. Analyse large datasets using Power Pivot
9. VBA / Auditing VBA
10. Name Management
11. Automate common tasks using Macros