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

How to Apply

Spaces are limited – Apply Nowand boost your financial management skills.

WELCOME ALL

🌐 www.icbfinexperts.com📞 +250 788 393 784 (Call/WhatsApp)

Application Procedure

Training Fees: Rwf141,600 Paid to ICB-FINANCE EXPERTS Ltd Via MOMO PAY: 1708263 OR BANK ACCOUNT: 100154516241 Opened in BK.

PAY 100% UPON REGISTRATION (RWF 141,600)