Office tools · Qualiopi-certified training organisation

Excel Training

Excel is the reference spreadsheet for data processing. This course teaches participants to use Excel in a structured way: get familiar with the interface and menus, manage and manipulate data, build reliable tables and analyse them with functions, pivot tables and charts.

Duration 2 to 3 days
Level Beginner to intermediate
Format On site (your premises) or online
Price from 750 € excl. VAT / day
Lead time 14 days after the training agreement is signed

Request a quote Download the syllabus (PDF) (PDF in French)

Learning objectives

Get familiar with Excel, its interface and menus.
Manage and manipulate data: entry, formatting, sorting, filtering, validation.
Build reliable formulas and use the most useful functions.
Analyse data with pivot tables and charts.

Syllabus

Day 1 — Solid foundations

Introduction to Excel where needed; getting familiar with the whole interface.
Basic manipulation; tables; data formatting.
The most used formulas: relative and absolute references, SUM, AVERAGE, IF, XLOOKUP, etc.
Practical exercises.

Day 2 — Analysing and presenting

Inserting charts and choosing the right chart type.
Conditional formatting; sorting and filtering; data validation.
Pivot tables: building, refreshing, slicing.
Advanced functions; productivity tips.

Day 3 (optional) — Your files

Work on the participants' workbooks: making them reliable, simplifying, light automation.
Introduction to Power Query and a bridge to VBA or Power BI.

Audience and prerequisites

Anyone who needs to process and structure data: assistants, administrators, technicians, project managers. Prerequisites: basic use of Windows or Mac.

Teaching methods and assessment

Course materials, corrected exercises, work on your own files, end-of-course assessment reviewed by Numersalis, certificate of completion.

View the detailed syllabus (PDF in French)

Funding

Numersalis is Qualiopi certified: for companies based in France, our courses are eligible for funding through your OPCO training fund. We help you with the paperwork.

Accessibility

Our courses are open to people with disabilities: contact us so we can plan the adjustments you need.

Frequently asked questions

Yes. The first half-day covers the basics for those who need them; more confident participants move on to additional exercises. A short questionnaire before the session lets us adjust the pace.

Your company's: Microsoft 365, Excel 2021 or earlier, Windows or Mac. Recent functions such as XLOOKUP are presented with their equivalents for older versions.

The Excel course stops at advanced functions and pivot tables; automation with macros is covered by the VBA course, often scheduled right after.