Excellence in Excel for Accountants

OBJECTIVES
This Excel for Accountants Course will equip you with the exact Excel skills you need as accountant.

COURSE OUTLINE
• 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
• Create a Loan Amortization table using the PMT function
• Clean and prepare raw data
• Create PivotTables and PivotCharts
• Analyse large datasets using Power Pivot
• Use Goal Seek, Data Tables and Scenarios to analyse data
• Automate common tasks using Macros

FOR WHOM
Accounting and Finance Professionals.

Methodology
The training methodology integrates lectures, interactive discussions, collaborative group exercises, and illustrative examples. Participants will acquire a blend of theoretical insights and hands-on practical experience, emphasizing the application of learned techniques. This approach ensures that attendees return to their professional environments equipped with both the competence and self-assurance to effectively implement the acquired skills in their responsibilities.
DATE:
1ST BATCH: 14th – 17th Apr, 2025
2ND BATCH: 28th – 31st Oct, 2025