Advanced Excel course: pivot tables, functions, scenarios and macros

The certification

ICDL – Organise, analyse and present numerical data with spreadsheet software, Advanced 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.

Objectives

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

• Apply conditional formatting and custom formats, and use templates
• Use advanced functions: date, logical, text, statistical, financial, lookup (VLOOKUP, HLOOKUP), database, nested functions and 3D references
• Create combination charts, sparklines and secondary axes
• Work with data using PivotTables, advanced filters, subtotals and the Scenario Manager
• Make data entry reliable: data validation, formula auditing
• Automate: named ranges, paste special, links, data import, simple macros
• Secure collective work: comparison, protection of cells and sheets

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

   Advanced formatting and templates

   Conditional formatting, custom formats, creating and using workbook templates.

2. 2

   Advanced and nested functions

   Date, logical, text, statistical and financial functions; VLOOKUP and HLOOKUP; database functions; 3D references. XLOOKUP is presented as an extra, outside the exam.

3. 3

   Advanced charts

   Combination charts, secondary axes, sparklines, advanced formatting of chart elements.

4. 4

   Analyse with PivotTables

   PivotTables and PivotCharts, advanced sorting and filters, subtotals, outline mode, Scenario Manager.

5. 5

   Make data entry reliable

   Data validation, formula auditing, spotting and correcting errors.

6. 6

   Automate

   Named ranges, paste special, links between workbooks, data import, simple macros.

7. 7

   Collaborate and protect

   Comparing workbooks, protecting cells, sheets and workbooks.

8. 8

   Work faster with the AI assistant (outside the exam)

   Generate and explain formulas, summarise data, spot anomalies, always checking 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.

Audience and prerequisites

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

• Standard level in spreadsheets, validated by the certification or by the placement test.
• 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