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 create 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) 
• create 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
? Makuza Peace Plaza, 7th Floor (Wing B), Kigali – Rwanda

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

? info@icbfinexperts.com

?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