CALL FOR APPLICATIONS: PROFESSIONAL TRAINING PROGRAM IN ADVANCED EXCEL,
FINANCIAL MODELING & POWER BI DELIVERED BY CERTIFIED MICROSOFT PROFESSIONALS.
About the Program
ICB–Finance Experts Ltd invites applications for its Professional Training in Advanced Excel,Financial Modeling and Power BI, a practical, hands-on program designed to equip accountants, auditors, and finance professionals with advanced skills in financial analysis, modeling, automation, and data
visualization.
The program integrates Advanced Excel, Financial Modeling, and Power BI Reporting, enabling
participants to build professional financial models, automate reporting, and develop interactive
dashboards for decision-making.
Note: Trainers are Microsoft Certified Professionals.
TRAINING INVESTMENT
- Training Fee: RWF 141,600 (VAT Inclusive) – Non-negotiable
- Corporate Discount: 20% discount available for organizations enrolling 3 or more
participants - Referral Offer: 20% discount for individuals who register with a friend or colleague
- EBM Receipts: Official Electronic Billing Machine (EBM) receipts will be issued for all payments
NOTE: Register and complete your payment by 26th April to enjoy a 15% early payment discount.
SPECIAL OFFER
- Participants who are ICB Finance Experts graduates will pay a training fee of RWF 59,000 only.
Program Objectives
By the end of the training, participants will be able to:
- Build fully integrated financial statements (Income Statement, Balance Sheet & Cash Flow)
- Develop budgets, forecasts, and valuation models
- Perform investment analysis using NPV, IRR, ROI
- Automate Excel models and reporting workflows
- Build interactive Power BI dashboards for financial reporting.
COURSE MODULES
Module 1: Advanced Excel Foundations for Financial Modeling
- Excel interface optimization & productivity shortcuts
- Workbook structure & worksheet management
- Advanced formatting techniques for financial reports
- Data validation & error-proof spreadsheet design
- Named ranges & structured references
Module 2: Advanced Excel Formulas & Functions
- Logical functions: IF, IFS, AND, OR, SWITCH
- Lookup functions: XLOOKUP, INDEX, MATCH, VLOOKUP (advanced use)
- Text, date & financial functions for modeling
- Dynamic formulas for automation
Module 3: Data Analysis & Management in Excel
- Sorting, filtering & data cleaning
- Conditional formatting using formulas
- Drop-down lists & validation controls
- Data structuring for financial modeling
Module 4: Pivot Tables, Pivot Charts & Dashboards
- Advanced Pivot Table design
- Calculated fields & grouping
- Pivot Charts for reporting
- Slicers & interactive dashboards
Module 5: Power Query (Get & Transform Data)
- Importing and cleaning data from multiple sources
- Merging and appending datasets
- Automating data preparation workflows
Module 6: Financial Statement Modeling
- Integration of financial statements
- Forecasting assumptions
- Ratio analysis and financial linkage
Module 7: Budgeting & Forecasting Models
- Revenue & cost projections
- Rolling budgets & variance analysis
- Cash flow forecasting
Module 8: Valuation & Investment Modeling
- DCF valuation
- Comparable analysis
- NPV, IRR, ROI analysis
- Sensitivity analysis
Module 9: Power BI for Financial Reporting
- Data modeling & Power Query integration
- DAX formulas
- KPI dashboards & visualization
- Excel–Power BI integration
Module 10: Advanced Modeling & Automation
- VBA macros
- Scenario analysis tools
- Dynamic dashboards
Module 11: Mergers & Acquisitions (M&A) Modeling
- Deal structuring & synergy analysis
- Pro forma financial statements
- Accretion/dilution analysis
Module 12: IFRS-Based Financial Modeling
- Consolidation models
- IFRS adjustments
- Audit-ready reporting systems
Who Should Attend
- Accountants & Auditors
- Finance & Tax Professionals
- Business Analysts & Advisors
- Entrepreneurs & Project Managers
- Finance Graduates
Training Schedule
- Start Date: 18th May 2026
- End Date: 14th June 2026
Delivery Modes
- Day: 9:00 AM – 12:00 PM (Mon–Fri)
- Evening: 6:00 PM – 8:00 PM
- Weekend: 9:00 AM – 1:00 PM (Sat & Sun)
- Umuganda: 2:00 PM – 5:00 PM
- Car-Free Day: 10:30 AM – 2:00 PM
- Online : 6:00 PM – 8:00 PM (Mon–Fri)
Training Venue
ICB–Finance Experts Ltd Training Centre for Microsoft Excel
📍NEXT TO BK IN CAR FREE ZONE AREA
Certification
🎓 Professional Certificate in Advanced Excel,Financial Modeling & Power BI
Application Procedure
Prior to submitting your application, you are required to assess your proficiency in Microsoft Excel (Basic and Intermediate levels) by accessing the link provided below:
Link:
https://forms.gle/pjL6goZLbvwTCGBA7
AFTER CHECKING YOUR LEVEL OF EXCEL PLEASE CONTINUE WITH PAYMENT AND APPLY TO THE BELOW LINK:
https://icbfinexperts.com/courses
🌐www.icbfinexperts.com📞 +250 788 393 784 (Call/WhatsApp)
Limited slots available – Early registration encouraged
Application Deadline
🗓 Sunday, 10th May 2026 – 23:59
Empowering Accountants with Practical Financial Intelligence
ICB–Finance Experts Ltd
Professional Training | Accounting | Taxation | Financial Modeling | Advisory