Microsoft Excel for Accounting

Course Information

A practical Excel-based accounting course designed to help participants build automated ledgers, trial balances, financial statements, and KPI dashboards. The program combines accounting application, IFRS and VAT adjustments, and a comprehensive project that brings all elements together in one integrated Excel workflow. Why Attend? ✔ Use Excel to automate accounting and reporting tasks ✔ Build linked financial statements from accounting data ✔ Apply VAT, IFRS, depreciation, and closing entries in Excel ✔ Create dashboards and KPI reports for management use ✔ Strengthen practical reporting and analysis skills Who Should Attend Accountants - Accounting Staff - Finance Officers Program Structure (6 Hours) Session 1: Excel functions & tools Session 2: Project setup, ledger input, and adjustment entries Session 3: Automated financial statements & Pivot Table summaries Session 4: Financial analysis & KPI dashboard creation Session 5: Comprehensive project execution & management reporting Session 6: Final evaluation Key Learning Areas ✔ Excel fundamentals for accounting ✔ Data organization and formatting ✔ Accounting records using Excel ✔ Formulas and functions for financial calculations ✔ Trial balance and adjustments ✔ Financial statement preparation ✔ Data analysis and reporting Certification Participants will receive a Certificate of Completion upon successfully finishing the course.