COURSE INFORMATION

Scheduled Dates: 26 – 30 Jan 2026 | 20 – 24 April 2026 | 20 – 24 Jul 2026 | 26 – 30 Oct 2026

Duration: 1 Week

Customized dates and one-on-one sessions can be organized.

Preamble

This CPM intensive one-week course is designed to equip participants with advanced skills in Microsoft Excel and Power BI for data analysis, reporting, and business intelligence. The training focuses on transforming raw data into meaningful insights using powerful tools such as advanced formulas, PivotTables, Power Query, data modeling, and interactive dashboards.

Participants will gain hands-on experience in building automated reports, analyzing large datasets, and creating visually compelling dashboards that support data-driven decision-making.

Target Group

This course is suitable for:

• Data analysts and business analysts
• Finance and accounting professionals
• Monitoring & Evaluation (M&E) officers
• Project managers
• Researchers and statisticians
• Administrative and operations staff
• Anyone working with data who wants to improve reporting and analytics skills
  

Course Outline

Day 1: Advanced Excel Foundations

• Review of key Excel concepts

• Advanced formulas:

o IF, nested IF, IFS

o VLOOKUP, HLOOKUP, XLOOKUP

o INDEX & MATCH

• Logical and text functions

• Named ranges

• Data validation techniques

Day 2: Data Analysis & Automation in Excel

• Advanced PivotTables and PivotCharts

• Slicers and timelines

• Conditional formatting (advanced rules)

• Introduction to Power Query:

o Importing data

o Cleaning and transforming datasets

• Removing duplicates, splitting/merging columns

• Automating repetitive tasks

Day 3: Excel Dashboards & Data Modeling

• Dashboard design principles

• Creating interactive dashboards in Excel

• Using form controls

• Introduction to data modeling:

o Tables and relationships

o Calculated columns and measures

• Introduction to Power Pivot

Day 4: Introduction to Power BI

• Overview of Power BI ecosystem

• Connecting to different data sources

• Data transformation using Power Query in Power BI

• Data modeling in Power BI:

o Relationships

o Basic DAX formulas

• Creating visualizations:

o Charts, tables, maps

Day 5: Advanced Power BI & Reporting

• Advanced DAX functions

• Creating interactive dashboards

• Filters, slicers, drill-down features

• Data storytelling and visualization best practices

• Publishing and sharing reports

• Course project: Build a complete dashboard

• Review and assessment

 

REGISTRATION

To register, kindly fill the Seminar Registration Form and send it to us through:
Email: This email address is being protected from spambots. You need JavaScript enabled to view it. , This email address is being protected from spambots. You need JavaScript enabled to view it.

TERMS AND CONDITIONS OF PAYMENT

1. Fees Payment - All fees are payable strictly in advance 2 working days before the course starting date.
2. Cancellation Fee - Cancellation of any participant 5 working days before the start day of a course will incur a 20% cancellation fee.
   We regret that no cancellations will be accepted within 2 working days of a course, but substitutions may be made.