Microsoft Excel is the most used spreadsheet in the private and professional field.

Microsoft Office Excel- ADVANCED

Excel is the spreadsheet of the Microsoft Office suite. This version offers advanced features for use in the areas of accounting and financial programs or any other field where the creation of tables and calculations is important.

Target audience
This course is designed to train advanced users involved in complex accounting, financial or scientific applications.

Master several complex functions of the program such as data consolidation, filters (and thus the notion of database), cross tables, etc ...

One week at half time, maximum 6 participants per class

Prerequisites for this training
Windows, Excel Base

Teaching method
The "Advanced Excel" course is based on a theoretical support, the practice using exercises related to current professional situations, and a personalized coaching by a trainer. Each participant has a workstation.

Course content

  • Advanced functions (SUM, NUMBER, SEARCH, INDEX)

  • Nested functions (IF nested, AND, OR)

  • Target values

  • Databases (basics, data entry, sorting, filters and subtotals)

  • PivotTables (creation, use, modification, graphics)

  • The working group

  • Consolidation by position and category

Attestation / Certificate
Certificate of participation
Certificate if the final test is successfully passed
Level reached on request



20 hrs / 1 week 

English or French 

Groups of 4 – 6 participants


CHF 700.-


Start every day

Contact us for all the details.

Schedule of classes:

Monday Friday

8:30 - 12:45

13:30 - 17:45

18:00 - 20:00