Short Course Description
A practical Excel training program designed specifically for accountants, bookkeepers, auditors, and finance professionals. The course focuses on accounting functions, financial statements, reconciliations, analysis techniques, and professional reporting used in real accounting jobs.
Target Audience
-Accountants & bookkeepers
-University accounting students
-Finance & audit professionals
-Admin staff who handle financial data
-Business owners managing financial records
What Students Will Learn
-Core Excel functions for accounting (SUMIF, XLOOKUP, INDEX/MATCH)
-Creating ledgers, journals & trial balances
-Bank reconciliation using Excel
-PivotTables for financial analysis
-VAT calculation templates (UAE format)
-Financial statements automation (P&L, Balance Sheet)
-Depreciation schedules & amortization
-Ratio analysis & dashboards
-Forecasting & budgeting templates
-Real accounting case studies (AR/AP, expenses, payroll)
