This high-impact master class is designed to equip finance professionals with practical, hands-on expertise in Microsoft Excel, enabling them to automate financial statements, streamline reporting, and enhance data-driven decision-making.

By the end of this intensive program, you will:

• Master Microsoft Excel from a very beginner to advanced levels, developing a strong command of its tools and functionalities.
• Leverage cutting-edge Excel features in Microsoft Office 2021 and Microsoft 365, ensuring you stay ahead with the latest updates.
• Apply powerful financial formulas such as Subtotal, IF Functions (Logical, Nested, IFAND, IFOR), COUNTIF, SUMIF, HLOOKUP, VLOOKUP, INDEX MATCH, and XLOOKUP to automate and optimize financial reporting.
• Automate Payroll Processing, Assets Register and Aging Analysis for Account Receivables & Payables using advanced Excel techniques for accuracy and efficiency.
• Prepare Multi-Period Financial Statements that align with IFRS and IPSAS standards.
• Optimize financial report printing in Excel for professional, structured, and error-free reporting. This master class goes beyond theory—it’s a hands-on experience that transforms the way you work with financial data.
• Design, prepare, and automate key financial statements, including:
  • Statement of Profit or Loss and Other Comprehensive Income
  • Statement of Financial Position
  • Statement of Changes in Equity (Net Assets)
  • Statement of Cash Flows
  • Notes to Financial Statements

These objectives are designed to ensure you not only learn the material but can effectively apply it in your professional environment, making an immediate impact on your career trajectory.

Dr. CPA David Dickson Kiwia
Founder & Managing Director

Comprehensive Learning Path