Training: Microsoft Office Specialist – MOS Excel Expert

Ref. MOS-EE

Download PDF

Duration:

jours

Exam:

Inclus

Level:

Expert

Funding:

Eligible

Home > Trainings > Office Automation > Office Automation Certifications > Microsoft Office Specialist – MOS Excel Expert

Microsoft Office Specialist - MOS Excel Expert Training

The MOS Excel Expert training prepares you for the Microsoft Office Specialist Excel Expert certification, the official Microsoft credential attesting an advanced level on Excel. Over three intensive days, you cover all the assessed competencies: workbook management, advanced formatting, complex formulas, macros, chart and table management. A certification that concretely values your profile in the job market in French speaking Switzerland.

Earn the MOS Excel Expert certification to validate your level officially

For professionals in French speaking Switzerland, the MOS Excel Expert certification is a differentiating asset for analytical profiles. This MOS Excel Expert training focuses on full exam preparation: all the assessed domains are covered with hands on practice on the exercise types proposed at the exam. You leave ready to take the Microsoft exam and with course materials to revise at your own pace.

Participant Profiles

Anyone in need to master the advanced functions offered by Excel software
Anyone who want to be certified Microsoft Office Specialist (MOS): Excel Expert

Objectives

Master advanced Excel workbook options and settings
Manage and format complex data per MOS Expert standards
Build advanced formulas and macros at the level expected at certification
Master the most advanced Excel charts and tables
Prepare for the MOS Excel Expert exam under real conditions
Earn the Microsoft Office Specialist Excel Expert certification

Prerequisites

Participants should have already well-practiced on Office softwares

Course Content

Module 1: Manage workbook options and settings

Manage workbooks
- copy macros between workbooks
- reference data in other workbooks
- enable macros in a workbook
- manage workbook versions
Prepare workbooks for collaboration
- restrict editing
- protect worksheets and cell ranges
- protect workbook structure
- configure formula calculation options
- manage comments
Use and configure language options
- configure editing and display languages
- use language-specific features

Module 2: Manage and format data

Fill cells based on existing data
- fill cells by using Flash Fill
- fill cells by using advanced Fill Series options
Format and validate data
- create custom number formats
- configure data validation
- group and ungroup data
- calculate data by inserting subtotals and totals
- remove duplicate records
Apply advanced conditional formatting and filtering
- create custom conditional formatting rules
- create conditional formatting rules that use formulas
- manage conditional formatting rules

Module 3: Create advanced formulas and macros

Perform logical operations in formulas
- perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions
Look up data by using functions
- look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions
Use advanced date and time functions
- reference date and time by using the NOW() and TODAY() functions
- calculate dates by using the WEEKDAY() and WORKDAY() functions
Perform data analysis
- summarize data from multiple ranges by using the Consolidate feature
- perform what-if analysis by using Goal Seek and Scenario Manager
- forecast data by using the AND(), IF(), and NPER() functions
- calculate financial data by using the PMT() function
Troubleshoot formulas
- trace precedence and dependence
- monitor cells and formulas by using the Watch Window
- validate formulas by using error checking rules
- evaluate formulas
Create and modify simple macros
- record simple macros
- name simple macros
- edit simple macros

Module 4: Manage advanced charts and tables

Create and modify advanced charts
- create and modify dual axis charts
- create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts
Create and modify PivotTables
- create PivotTables
- modify field selections and options
- create slicers
- group PivotTable data
- add calculated fields
- format data
Create and modify PivotCharts
- create PivotCharts
- manipulate options in existing PivotCharts
- apply styles to PivotCharts
- drill down into PivotChart details

Documentation

Digital courseware included

Lab / Exercises

Practical exercises will be given during and at the end of each module

Exam

This training prepares you for the MO-201 exam: Microsoft Excel 2019 / 365 Expert
Exam voucher included in the course price

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Why aim for the MOS Excel Expert certification in 2026

The Microsoft Office Specialist Excel Expert certification is Microsoft’s official recognition of an advanced level on Excel. On a resume, it objectively attests to skills validated by a hands on exam, which sets it apart from simple self declared level mentions. The MOS Excel Expert training prepares you precisely for this exam over three days.

The stake is concrete: for analytical profiles in finance, management control, audit or HR, displaying the MOS Excel Expert certification on your LinkedIn profile or resume is a strong signal to recruiters. It is also a valuable step in a personal upskilling journey.

The content of the MOS Excel Expert certification

The MOS Excel Expert exam covers four major domains: workbook options and settings management, data management and formatting, advanced formulas and macros, advanced chart and table management. The training follows this structure to methodically prepare you for each assessed domain.

The exercises practiced during training reproduce the format of the tasks asked at the exam: precise modifications on a provided workbook, formula creation per exact specifications, parameterized conditional formatting. This familiarity with the exam format is a key success factor.

Advanced formulas and macros at the heart of MOS Expert training

The training places significant focus on advanced Excel formulas and macros. VLOOKUP, INDEX, MATCH, nested logical functions, array functions, complex conditional formulas: all formula types expected at the MOS Excel Expert exam are reviewed.

Macros are also covered at the required level: recording, basic modification, execution. The Excel VBA training deepens these topics for those who want to go well beyond the MOS Expert scope on programming.

Advanced Excel charts and tables

Managing advanced charts and tables is the fourth pillar of MOS Expert certification. The training covers combo charts, pivot charts, slicers and timelines for pivot tables, advanced table formatting. All these features are regularly assessed at the exam.

Geneva and Lausanne profiles who benefit from the certification

The MOS Excel Expert training is designed for advanced Excel users who want to officially validate their level. Management controllers, financial analysts, auditors, reporting managers, self employed professionals seeking a strong signal on their expertise: all these profiles find in the MOS Excel Expert certification a concrete differentiation lever in the job market in French speaking Switzerland.

Practical MOS Excel training in Geneva and Lausanne

At our ITTA centers in Carouge and Le Flon, this MOS Excel Expert training runs over three days with an expert instructor and a small group to ensure personalized follow up. You work on exercises reproducing the exam format, benefit from individual feedback and leave ready to take the Microsoft Office Specialist Excel Expert certification.

FAQ MOS Excel Expert training

What is the MOS Excel Expert certification?

It is the official Microsoft Office Specialist Excel Expert certification, attesting to advanced Excel skills via a 50 minute hands on exam.

What is the difference between MOS Excel Associate and MOS Excel Expert?

The Associate exam covers intermediate Excel features. The Expert exam targets an advanced level: complex formulas, macros, advanced charts, workbook management.

Do I need to master Excel before this MOS Expert training?

Yes, regular and advanced Excel use is required. The Advanced Excel Training and the Excel Dashboards course are useful prerequisites.

Is the MOS Excel Expert exam practical or theoretical?

Practical. The exam asks you to perform concrete tasks on a provided Excel workbook, in a Microsoft Office environment.

Is this MOS Excel training held in Geneva?

Yes, the training takes place at the ITTA center in Carouge in Geneva, at Le Flon in Lausanne and in a virtual classroom.

How long to prepare for the MOS Excel Expert exam?

The training runs over three intensive days. Personal review afterwards is recommended before taking the exam.

What is the professional benefit of the MOS Excel Expert certification?

It objectively attests to an advanced Excel level, values an analytical profile on LinkedIn and resumes, and represents a strong signal to recruiters for finance, audit, management control or HR roles.

Who this mos excel expert training is for

Advanced Excel users wanting to validate expert level via Microsoft certification and demonstrate mastery of most advanced features. In Geneva and Lausanne, the course welcomes participants from international organizations, banking, consulting and growing SMEs. No specific prerequisite is required other than a concrete willingness to progress on the subject.

Concretely, what will you be able to do at the end

You leave with an operational mastery of the fundamentals, reusable canvases on your concrete cases, a structured action plan for the weeks that follow. Many participants report a visible effect from the first week back, with sustainable anchoring over four to six weeks of regular practice. The course combines short theory inputs, practical exercises on your real situations and personalized trainer debrief.

Concrete use cases in business

A controller validating expert level for senior position. A freelance consultant justifying rates with recognized certification. A manager showing example on Microsoft tools mastery. The course adapts exercises to your context with personalized trainer feedback, and each participant leaves with an action plan calibrated to their own situation.

Articulation with other ITTA courses

Combines well with MOS Excel Associate (recommended prerequisite), Excel Advanced formulas for practice, other MOS Expert (Word, PowerPoint). Many participants enroll in one of these courses in the following trimester, according to their current priority and professional context.

Why this training makes a difference in professional environment

MOS Excel Expert certification validates mastery of most advanced features: complex formulas, financial and statistical functions, advanced pivot tables, macros, scenarios, audit. The reference certification to demonstrate recognized expert level.

Sustained anchoring after the course

Most participants report a noticeable effect from the first week of return, with deeper anchoring over four to six weeks of regular practice on real files. The course closes with a personalized practice plan calibrated on your professional context.

Why this course makes a difference

The features covered are used daily by millions of professionals across Geneva and Lausanne organizations. Mastery transforms repetitive work into efficient routine. This training relies on real cases and offers an outfitted approach calibrated for the 2025-2026 evolutions of the platform.

ITTA pedagogy oriented towards practice in Geneva and Lausanne

At ITTA centers in Geneva and Lausanne, this course runs in a small group with an expert trainer and a format alternating concise theory, practical exercises and personalized debrief. Group confidentiality is explicit and held. Each participant arrives with a real case and leaves with an action plan calibrated to their context. The course integrates recent evolutions of the domain (digital tools, hybrid formats, 2025-2026 practices) without losing focus on fundamentals.

Need MOS Associate?

Recommended but not mandatory.

Is the exam more difficult?

Yes, Expert exam tests most advanced features.

Does it integrate VBA?

VBA bases are covered for Expert certification.

Where do sessions take place?

ITTA has three centers in French speaking Switzerland: in Geneva (Carouge, Route des Jeunes 35), in Lausanne at the Flon (Rue des Cotes de Montbenon 16) and at Lausanne Mon-Repos (Avenue de Mon-repos 24). The training is also available in virtual classroom.