Trainings & Short Courses
- Home
- »
- Training and Consultancy
Microsoft Excel and Power BI for Data Analytics and Reporting.
Ellchart Trainings
Let’s Build Capacity That Makes a Difference
Ellchart Trainings is the professional development department of Ellchart Business School, delivering high-impact, industry-aligned training programs. We specialize in equipping public and private sector professionals with the critical skills needed to succeed in today’s dynamic environment.
Designed specifically for
public sector accountants, finance managers, auditors, and compliance professionals,
our IPSAS training equips participants with a clear understanding of accrual-based financial reporting in line with international best practices.
Through real-world case studies and hands-on exercises, we cover:
- IPSAS classification and framework
- Fixed asset accounting under IPSAS 17
- Financial statement preparation
- Transitioning from cash to accrual accounting
- IPSAS 33 for first-time adoption
- Common implementation challenges and how to address them
This course is ideal for government ministries, municipalities, and parastatals aiming to enhance
accountability, transparency, and consistency in their financial systems.
Many Zimbabwean SOEs and parastatals are still required to prepare financial reports under IFRS.
Our specialized IFRS workshop ensures that finance professionals remain current with international standards and their local application.
Key topics include:
- Deep dives into critical standards: IFRS 9 (Financial Instruments), IFRS 15 (Revenue), IFRS 16 (Leases), IFRS 17 (Insurance Contracts), and the new IFRS 18 (Presentation and Disclosure in Financial Statements)
- Real-life application through Zimbabwean case scenarios
- Navigating complexities in consolidation, financial instruments, lease classification, and revenue recognition
- Preparing for external audits and stakeholder reporting
This course supports finance professionals in maintaining
financial integrity, audit readiness, and strategic alignment with global reporting expectations.
Microsoft Excel for Professionals
Excel remains the go-to tool for financial modeling, data management, and operational analysis.
Our Excel training is structured to benefit users at all levels—whether you’re building your first spreadsheet or managing large datasets.
Training levels include:
- Foundations: Basic formulas, cell formatting, data validation
- Intermediate: Lookup functions (VLOOKUP, INDEX/MATCH), PivotTables, named ranges
- Advanced: Macros, VBA scripting, dashboards, automation techniques, dynamic charts
- Finance Focus: Budgeting models, what-if analysis, variance reporting
Participants gain the confidence to create efficient, error-free spreadsheets and make informed decisions faster—an essential skill for professionals across all sectors.
Artificial Intelligence (AI) & Data Analytics
In today’s data-driven world, organizations need people who can interpret data, identify patterns, and turn raw information into actionable insights.
This course is tailored for non-technical professionals looking to break into AI and analytics without needing a background in coding.
Covered areas include:
- Introduction to AI and machine learning concepts
- Data cleaning, preparation, and visualization using tools like Power BI & Excel
- Using AI tools like ChatGPT, Power Automate, and Excel Copilot to automate routine tasks
- Interpreting dashboards for strategic decision-making
- Building simple predictive models using no-code platforms
This program empowers participants to confidently use data and emerging technologies to improve performance, reduce risk, and drive innovation.