Excel
Basic level, Analysis and reporting, Advanced level and automation, Practical applications
Basic level3 courses
-
Excel from Zero to Advanced
From the interface and formatting to formulas, functions, tables and charts.
30 training hours
-
Excel for Accountants
Everyday Excel in accounting work: entries, balances, reconciliations and reports.
24 training hours
-
Financial and Accounting Functions in Excel
Lookup, conditional and aggregation functions, plus loan, depreciation and time-value-of-money functions.
18 training hours
Analysis and reporting4 courses
-
Pivot Tables and Data Analysis
Summarising and analysing large data sets with pivot tables, slicers and calculated fields.
18 training hours
-
Interactive Dashboards
Building an interactive dashboard that presents key figures with charts and filters.
20 training hours
-
Financial Reporting in Excel
Designing periodic financial reports that are linked to the data, update automatically and are ready for management.
20 training hours
-
Financial Modeling
Building a model that links the three statements, with assumptions, forecasts and sensitivity analysis.
30 training hours
Advanced level and automation2 courses
-
Power Query and Power Pivot for Accountants
Importing, cleaning and merging data automatically, then building and analysing a data model.
24 training hours
-
Automating Accounting Tasks with Macros and VBA
Recording macros and writing simple VBA code to cut down repetitive tasks.
30 training hours
Practical applications3 courses
-
Building a Complete Accounting System in Excel
Building a system that starts with the chart of accounts and journal and ends with the trial balance and financial statements.
30 training hours
-
Payroll and Attendance Sheets in Excel
Designing an attendance file and a payroll sheet that calculates entitlements and deductions.
18 training hours
-
Inventory and Sales Management in Excel
A file to track items, movements, balances and sales, with reports and reorder alerts.
18 training hours
Start with the course that fits you
Pick your course from the catalogue and register in a minute, or message us on WhatsApp if you would like guidance.