knowledgeplus Training Center
413 9119 / 5440 9119

Course Detail

EA 2 Months

Excel for Accountants (Intermediate)

Course Information

  • Total Students 20 per class
  • Course Duration 2 Months


This course is designed to help Finance staff and Accounting professionals develop the skills and knowledge needed to use Excel effectively in their work, including data management, analysis, reporting, and automation in only 2 months.

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