Academy
Advanced Excel & professional dashboards
Reliable files, automated calculations and a dashboard ready to present.
Advanced formulas, pivot tables, Power Query and dashboards: a hands-on course to save time on your management files and present clear figures.
- Duration
- 20–30 h
- Format
- On site in Oujda, in-company or remote
- Level
- Intermédiaire
- Pricing
- Request the conditions
Who is it for?
- Audience
Employees, administrative staff, accountants and management assistants who use Excel every day and want reliable, automated files.
- Prerequisites
Everyday use of Excel: data entry, formatting, simple formulas and filters. A computer with Excel 2016 or later (Microsoft 365 recommended).
What you will be able to do
- Structure data in reliable tables, with input checks and drop-down lists
- Use advanced functions: XLOOKUP, nested IF, SUMIFS, date and text functions
- Analyse data with pivot tables and pivot charts
- Import, clean and combine files with Power Query
- Build an interactive dashboard with slicers and key indicators
Curriculum
Organising reliable data
Structured tables, data validation, conditional formatting, sheet protection.
Advanced functions
XLOOKUP and INDEX/MATCH, logical and conditional functions, dates and text; finding and fixing errors.
Pivot tables
Grouping, calculated fields, filters, slicers and pivot charts.
Power Query
Import Excel and CSV files, clean them, merge them and refresh them without re-keying.
The dashboard
Choose the indicators, build the charts, make the dashboard interactive and readable.
Automating repetitive tasks
Introduction to recorded macros and good practice for sharing files.
Hands-on practice
Deliverable: a management dashboard
Each participant builds a refreshable dashboard from real or realistic data from their own work: sales, budget, stock or activity tracking.
Assessment and certificate
Corrected exercises in every session, then a presentation of the final dashboard: the trainer checks that the calculations are right and the indicators readable.
ENTSI Academy certificate of completion, issued at the end of the course once the deliverable is validated.
Sessions
Next session to be confirmed.
Leave your details and we will send you the next dates as soon as they are set.