Call for Application for Training on Advanced Excel and Power Bi for Executives and Project Leaders |||| The Result Consult Co. Ltd
Event Details:
CALL FOR APPLICATION FOR TRAINING ON ADVANCED EXCEL AND POWER BI FOR EXECUTIVES AND PROJECT LEADERS
1. Background
In an increasingly data driven world, the ability to process, visualize, and interpret data is a key asset for decision makers. Advanced Excel and Microsoft Power BI are two of the most powerful tools available for data analysis and business intelligence. While Excel remains an essential platform for modeling, budgeting, and detailed data manipulation, Power BI enhances these capabilities with dynamic, interactive dashboards and real-time reporting. This training is designed to empower executives, project leaders, data science practitioners, and business professionals with the tools and techniques needed to transform raw data into actionable insights. It bridges the gap between data and strategy, equipping participants to lead with clarity, confidence, and impact
2. Objectives of the training
The main objective of this training is to equip executives and project leaders with practical and advanced skills in using Microsoft Excel and Power BI for data analysis, reporting, and informed decision making. Specifically, this training aims to:
Apply advanced Excel functions and formulas for efficient data analysis and reporting
Design interactive dashboards using Excel and Power BI
Connect, transform, and visualize data using Power BI tools
To foster a data-driven culture among executives and project leaders, promoting evidence-based planning and resource optimization
Interpret data to support strategic decisions and communicate insights effectively
3. Expected Output
By the end of the training, participants will be able to confidently use advanced Excel techniques and Power BI tools to organize, analyze, and visualize data. They will create interactive dashboards, automate workflows, and design performance reports that support data driven decisions. Participants will return to their organizations equipped with practical solutions for monitoring project outcomes, tracking KPIs, and delivering high level reports to stakeholders.
4. Content
This training will cover the following main chapters
Advanced Excel will cover three chapters
Chapter 1: Advanced Formulas and Functions
Logical Functions (IF AND NOT & OR FUNCTION KEYS)
Lookup and reference functions (VLOOKUP, XLOOKUP, HLOOKUP, INDEX, MATCH)
Text functions (CONCATENATE, LEFT, RIGHT, MID)
Statistical functions (AVERAGE, AVERAGEIFS, COUNT, COUNTIFS, SUMIFS)
Nested Functions
Advanced conditional formatting techniques
Array Formulas
Round down, Roundup, Round
Len
Power Pivot
Left, Right, Mid, Search, Find
Index, Match
Workbook and Worksheet Protection, Etc.
Chapter 2: Advanced Data Entry, Cleaning, Analysis, Visualization, and Reporting Techniques.
Data entry technique
PivotTables and Pivot Charts
Data validation and data filtering
Advanced sorting and filtering techniques
Subtotal and summary functions
What-If analysis with Scenario Manager
Using slicers to filter data through the pivot table
Charts, Graphs & Visualizations in Excel
Chapter 3: Excel Dashboards and Reporting:
Creating dynamic dashboards using Excel
Using form controls and slicers for interactivity
Automating reports with macros and VBA basics
Advanced sorting and filtering techniques
Best practices for executive-level reporting
Power BI will cover four chapters
Chapter 1: Introduction to Power Bi
Understanding Power BI environment and components
Connecting to data sources (Excel, databases, online sources)
Data cleaning and transformation using Power Query
Data modeling basics (relationships, calculated columns)
Visualizations and Reports using Power Bi
Chapter 2: Data Visualization and Dash boarding in Power BI
Building interactive dashboards
Designing effective charts and visuals for decision-making
Using slicers, filters, and drill-through features
Customizing reports with themes and templates
Chapter 3: Advanced Power Bi Techniques
Introduction to DAX (Data Analysis Expressions)
Building Interactive Dashboards
Using Custom Visuals in Power BI
Chapter 4: Interacting Power Query and Power BI
Best practices for Data Integration
Real World Case Studies and Applications
Hand on practices with Real Data Sets
5. Participants
The training is designed for executives, project managers, team leaders, M&E officers, finance professionals, and anyone in a leadership or coordinator role who regularly works with data and reports.
Notice: We can offer this training demanded by institutions for their staff at their office or as per their plan
6. Date and Venue
This training is scheduled to take place from 12th to 23rdMay, 2025, from 6:00 pm to 9:00 pm from Monday up to Friday. The training will be hosted at the office of the firm which is located in Kigali – Nyarugenge at KN 1 Ave 55 (Near Sainte Famille Hotel).
7. Participation fee and payment processes
The participation fee is 100,000 Rwf. Interested applicants are encouraged to pay the registration fees through the following bank details: Bank Account: 20071588001 open in I&M Bank, in the name of The Result Consult Co. Ltd, or through MoMo Pay (182*8*1588357). To make easy for participants, payment can be made in two installments, 50% at the start and the remaining 50% at the end of the training.
For further clarification, you can always contact us on 0781004638 (Training and Events Coordinator) or visit www.theresult.rw
This is the link for registration: https://forms.office.com/r/sk40z2rDiL
8. Facilitator
The session will be led by a certified Excel expert and professional trainer with extensive experience in capacity building for business professionals, project teams, and senior managers. The facilitator brings practical, hands-on approach to ensure that participants leave the training with immediately applicable skills.
9. Post-training support
We offer an option of post training support for a period from 1 month to 3 months to ensure that, we stick to the main and specific objectives of the training. Apart from this, we offer on the job coaching to ensure that skills are applied effectively and productively.
10. Certificate
At the end of the training, we provide a certificate of completion
Deadline for application is due 12th May, 2025 by 5 pm
Done at Kigali, 23rd April, 2025
Sylvain Bikorimana
Managing Director
Date and Timings:
25-04-2025 10:45 AM to 13-05-2025 10:45 AM
