Data & BIIntermediate
Power BI — from data to dashboard
Go from a data extract to a readable, actionable Power BI dashboard.
3 days / 21 hours · In person · Remote · In-company
Analysts
- Import data
- Transform
- Build a model
Excel & productivity
Advanced Excel & automation
Structure, clean and automate Excel files for reliable reporting.
Excel remains the most common reporting tool. Files decay through copy-paste, broken formulas and mixed sources. This training shows how to build a structured workbook, prepare data with Power Query and automate updates.
- Intermediate
- 3 days / 21 hours
- In person
- Remote
- In-company
Audience: Controllers · Operations · HR · Finance
- Level
- Intermediate
- Duration
- 3 days / 21 hours
- Format
- In person · Remote · In-company
- Modalities
- Strong interaction and workshops. · A program dedicated to one organization.
- Audience
- Controllers · Operations · HR · Finance
- Language
- French or English
- Prerequisites
- Regular Excel use (basic formulas, tables).
Why this training?
Excel remains the most common reporting tool. Files decay through copy-paste, broken formulas and mixed sources. This training shows how to build a structured workbook, prepare data with Power Query and automate updates.
- Unstable files
- Uncleaned data
- Manual reporting
- Structured tables
- Automatable preparation
- Fewer reporting errors
Learning objectives
- Build a structured, usable table for reporting.
- Clean and transform data with Power Query.
- Automate repetitive processing.
- Produce stable, reusable indicators.
Skills developed
After the training, you will be able to:
- Import and clean data
- Transform with Power Query
- Build a simple model
- Automate recurring tasks
Audience
Controllers, operations, finance, HR and professionals who produce recurring Excel reports.
Prerequisites
- Regular Excel use (basic formulas, tables).
Curriculum
Learning objectives
- Make a file structure reliable.
Notions
- Tables
- References
- Good practices
Exercises
- Rebuild a business file
Learning objectives
- Automate cleaning and consolidation.
Notions
- Import
- Transforms
- Refresh
Exercises
- Consolidate several sources
Learning objectives
- Reduce manual handling.
Notions
- Pivot tables
- Indicators
- Automation
Exercises
- Typical monthly report
Practice at the core of the path
- Clean a business export with Power Query
- Build a structured reporting table
- Automate a monthly refresh
Teaching method
Demonstration on business files, guided exercises, review, then application on a participant case when the format allows.
- Real cases
- Business files
- Exercises
- Review
Tools used
- Excel
- Power Query
- Power Pivot
Format
In person
3 days / 21 hours
Strong interaction and workshops.
On site or in a classroom, including Abidjan when in-person is selected.
Remote
3 days / 21 hours
In-company
3 days / 21 hours
A program dedicated to one organization.
Assessment
- Practical case
Deliverables
- Exercise files
- Templates
- Materials
Attestation
Certificate of attendance
Sessions
No public session is currently scheduled.
FAQ
Regular Excel practice is required: simple formulas, tables, filters. This is not an introduction.
Yes. Data preparation with Power Query is part of the program.
Excel for Microsoft 365, or a recent Excel version with Power Query.
Yes. In-company sessions can adapt files and cases to your business.
A certificate of attendance is issued.
Continue your progression
- Excel & productivityIntermediate
Excel for Human Resources
Build reliable HR spreadsheets: headcount, absenteeism, payroll and social reporting.
2 days / 14 hours · In person · Remote · In-company
HR
- Organize an HR file
- Calculate simple indicators
- Produce a monthly report