Skip to main content

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.

Next session to be confirmed
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.

Ask for the next dates

Reliable files, automated calculations and a dashboard ready to present.

* Required field