Excel course: organise, analyse and present your data

The certification

ICDL – Organise, analyse and present numerical data with spreadsheet software, Standard level — RS7528, registered until 27 February 2029.

Certifying body: EURO APTITUDES (trading name ICDL France), SIRET 409 155 892 00022.

Software and environments: Excel, Google Sheets or Calc.

View the official RS7528 record on France Compétences

Two options

The placement test determines the right option. Price per person, net of tax (VAT not applicable), certification exam included.

This course is also part of the Certified office assistant pack (Standard Word, Excel and PowerPoint): 3 certifications · 49 hrs · €2,990 net of tax per person.

Objectives

By the end of the course, the learner is able to:

• Create, save and manage workbooks
• Enter, sort, copy and organise data in structured sheets
• Manage rows, columns, panes and sheets
• Calculate with formulas and functions (SUM, AVERAGE, IF, SUMIF, COUNTIF), mastering relative and absolute references
• Format numbers, dates and cells
• Create and edit charts
• Prepare a workbook for printing

Programme

Programme built on the RS7528 certification syllabus (France Compétences registration). The order and length of each module are adjusted to the group after the placement test.

1. 1

   Get to grips with the spreadsheet

   Create, open and save workbooks, choose file formats, adjust options and display.

2. 2

   Enter and organise data

   Build a list correctly, enter, sort, find and replace, copy down and create series.

3. 3

   Manage rows, columns, panes and sheets

   Insert, delete, hide and freeze rows and columns; rename, move and copy sheets.

4. 4

   Calculate with formulas and functions

   Operators, relative, absolute and mixed references; SUM, AVERAGE, MIN, MAX, COUNT, IF, SUMIF, COUNTIF; spot and correct common errors.

5. 5

   Format

   Number, currency, percentage and date formats; alignment, borders, merging cells.

6. 6

   Create charts

   Choose the right type (columns, lines, pie), add titles, legends and labels, format.

7. 7

   Page layout and printing

   Margins, orientation, headers and footers, repeated titles, print area and preview.

8. 8

   Analyse a spreadsheet with the AI assistant (outside the exam)

   Describe a spreadsheet, explain a formula, suggest a chart with the AI assistant, then check the results.

9. 9

   Exam practice and sitting the certification

   ICDL practice tests on the 7 skills of the syllabus, corrected with comments, then a supervised certification exam.

The Complete option devotes more time to modules 1 to 4 and to guided practice.

Audience and prerequisites

Audience: employees, freelancers, public-sector staff and jobseekers with CPF rights.

• Know how to use a computer (keyboard, mouse, files).
• Command of written and spoken French or English (courses delivered in French or English).
• Take the free ICDL placement test before enrolling.

Formats

For online and hybrid courses, technical and teaching support is provided by phone and email, with a reply within 48 working hours at the latest.

Assessment and validation

• Before: free ICDL placement test.
• During: corrected exercises and practice tests.
• At the end: ICDL certification exam, online, supervised, with no reference materials. It lasts 35 minutes and has 36 questions (click zones, multiple-choice, screenshot questions); the certification is obtained with 75% correct answers or more.
• Satisfaction: questionnaire at the end of the course, then a questionnaire after 3 months.

Validation: ICDL certificate verifiable online if you pass, course completion certificate in all cases. The conditions for retaking the exam in case of failure are set out in the general terms of sale.

Teaching methods and resources: interview and placement test, then a pathway adjusted to the result. Demonstrations, exercises on professional cases, practice tests, digital materials given to the learner. Trainers experienced in the subject taught.

Accessibility

Courses are accessible to people with disabilities after a discussion with the disability officer, who assesses the adaptations needed. The rooms in Mougins, Valbonne and Sophia Antipolis are accessible to people with reduced mobility. Disability officer: +33 4 22 21 32 43, contact@antipolisformation.fr. For the ICDL exam, extra time (47 minutes instead of 35) can be activated.

Access times

Enrolment all year round. The course starts at the earliest 11 working days after the enrolment request on Mon Compte Formation. In practice, allow 2 to 4 weeks depending on the session calendar.

Funding

Possible funding: CPF, employer, OPCO.

• Funding cap: €1,500 per certification of the Specific Directory. This course’s price is below that cap.
• Mandatory contribution from the account holder: €150 per course, on top of the price, for any enrolment since 2 April 2026. Jobseekers are exempt. The employer can cover it with a top-up contribution.
• Enrolment and payment exclusively on moncompteformation.gouv.fr. Antipolis Formation complies with the CPF code of ethics and does not cold-call by phone.

Prices are per person, net of tax (VAT not applicable).

Practical information

• Documents given before the start of the course: programme, general terms of sale, internal rules, welcome booklet.
• Enrolment and teaching questions: +33 4 22 21 32 43, contact@antipolisformation.fr.
• Complaints: same address, with a reply within 10 working days.
• Other answers: see the frequently asked questions on courses, ICDL certification and funding.

Legal notice and terms of use of the site

Print this sheet