Real skills. Solid foundations.Kénitra, MoroccoQuestions? Let’s talk.
Microsoft Excel

Professional Excel — Mastery & Productivity

Structure worksheets, make formulas reliable and turn working data into useful analysis, pivot tables and dashboards.

Beginner → advanced6 modulesFR / EN · website & free lessons
YOUR PROGRESSION, LEVEL BY LEVEL

The right level. A practical goal.

Start at the level matching your experience. Every stage has prerequisites, workshops and a validation project.

01
LEVEL 01

Beginner

Become independent with a working workbook, from data entry to your first tracker.

Prerequisites: Basic computer skills; no previous Excel experience required.

01Working with a workbook
  • Worksheets, cells and ranges
  • Saving and organising files
  • Shortcuts and navigation
02Entering clean data
  • Text, numbers and dates
  • Formats and units
  • Copying, filling and correcting
03Building your first formulas
  • Order of operations
  • Relative and absolute references
  • SUM, AVERAGE, MIN and MAX
04Organising a usable list
  • Structured tables and headers
  • Sorting and filters
  • Basic validation and duplicates
05Presenting results
  • Choosing a simple chart
  • Conditional formatting
  • Page layout and PDF export
06Delivering a reliable file
  • Checking totals
  • Separating input and calculations
  • Documenting and handing over a workbook
VALIDATION PROJECT

Prove it through practice.

Create an expense tracker: a structured table, validated calculations, a chart and a printable view.

Success criteria
  • Consistent entries and correct data types
  • Formulas copied without reference errors
  • Totals reconciled to source data
Choose this level
02
LEVEL 02

Intermediate

Improve reliability and speed when working with lists, lookups and business summaries.

Prerequisites: Be comfortable with references and structured tables, or complete the beginner level.

01Combining useful functions
  • IF, AND, OR and IFERROR
  • SUMIFS and COUNTIFS
  • Testing edge cases
02Connecting reference data
  • XLOOKUP where supported
  • INDEX/MATCH as an alternative
  • Exact matches and unique keys
03Working with text and dates
  • Cleaning and extraction
  • Dates, deadlines and periods
  • Detecting numbers stored as text
04Making input reliable
  • Drop-down lists
  • Conditional rules
  • Cross-column consistency checks
05Summarising with pivot tables
  • Fields, grouping and filters
  • Slicers and pivot charts
  • Refreshing and reconciling totals
06Sharing a maintainable tool
  • Protection against accidental edits
  • Separating sources, calculations and output
  • User notes and a test dataset
VALIDATION PROJECT

Prove it through practice.

Build a sales tracker: a product reference table, input checks, a monthly summary and a pivot table.

Success criteria
  • Lookups explicitly handle missing matches
  • Metrics verified on a sample
  • Pivot tables refresh correctly after adding rows
Choose this level
03
LEVEL 03

Advanced

Design robust, reusable workbooks that refresh reliably, with automation suited to the task.

Prerequisites: Solid conditional formula, lookup and pivot-table skills; Excel supporting the selected features.

01Structuring advanced calculations
  • Named formulas and readability
  • LET and dynamic arrays where supported
  • Filters, sorts and spilled results
02Preparing data with Power Query
  • Importing a folder of files
  • Types, nulls and errors
  • Merging and appending queries
03Introducing the data model
  • Fact and dimension tables
  • Relationships and granularity
  • Basic measures with Power Pivot where available
04Building a management dashboard
  • Defining KPIs
  • Navigation and visual reading
  • Period comparisons and thresholds
05Choosing appropriate automation
  • Power Query before code
  • Introduction to VBA or Office Scripts depending on the environment
  • Operation logs and error handling
06Auditing and handing over
  • Finding fragile dependencies
  • Testing volume and refresh
  • File versioning and maintenance guide
VALIDATION PROJECT

Prove it through practice.

Deliver a refreshable management workbook: monthly import, integrity checks, metrics and maintenance documentation.

Success criteria
  • A new file is integrated without copying calculations
  • Source errors are identified and documented
  • Reference test cases produce consistent results
Choose this level
Software & environment

Recent desktop Excel recommended. XLOOKUP, LET, dynamic arrays, Power Query, Power Pivot and automation depend on version, operating system and licence; alternatives are confirmed before the session.

Start with a real lesson.

GENIUS NOTES / FREE PREVIEW6 MIN

Before the chart, define what the figure measures.

An explained concept, a diagram or example, then an exercise to work through yourself.

Read the free lesson

What you will learn to do

  • Organise data in structured tables
  • Use suitable formulas and references
  • Summarise with pivot tables
  • Build clear, verifiable reporting

Skills across the programme

01Worksheets, tables and data quality
02Formulas, references and checks
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
03Lookup functions and conditional calculations
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
04Pivot tables and charts
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
05Preparing data with Power Query
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
06Dashboard and measured automation
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.

Start with the right foundations

Prerequisites

Basic computer literacy. Access to Excel; features are adapted to the version used.

Language and format

Discovery resources are available in French and English. Contact us to confirm the teaching language, format, materials and support for your chosen programme.

Connect knowledge to a project

EXAMPLE TARGET PROJECT

Create a sales tracker with structured data, validated metrics, a pivot table and a dashboard.

Before you enrol

Preview lessonFree · no account
Full programme and materialsAs confirmed for the session
Official examSeparate registration
Cloud environment costsCheck for each lab
TRY BEFORE YOU CHOOSE

The best way to find out?
Start learning.

One lesson, a real concept and an exercise. Discover our approach, without an account and at your own pace.

Open a free lesson
GENIUS NOTES / 001
CLOUD ARCHITECTURE

A reliable architecture starts with the right questions.

6 min · Reading & exerciseRead the lesson

Your next chapter starts here.

A goal, a question, a project? Let’s talk about your learning path.

Let’s talk about your goals