Training: Microsoft Office Specialist – MOS Excel Associate

Ref. MOS-EA

Download PDF

Duration:

jours

Exam:

Inclus

Level:

Fondamental

Funding:

Eligible

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

Microsoft Office Specialist - MOS Excel Associate Training

The MOS Excel training prepares you for the Microsoft Office Specialist Excel certification, the official Microsoft credential attesting to an intermediate to advanced level on Microsoft Excel. Over two intensive days, you cover all assessed competencies: workbook and worksheet management, cell and range management, table management, Excel formulas and functions. A certification that values analytical profiles in French speaking Switzerland.

Earn the MOS Excel certification to validate your level officially

For Swiss French speaking organizations, the MOS Excel certification is a differentiating asset for analytical profiles. This MOS Excel training focuses on full exam preparation: all assessed domains are covered with hands on practice.

Participant Profiles

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

Objectives

Manage Excel worksheets and workbooks per MOS standards
Master cells and data ranges at the MOS Associate level
Manage Excel tables and structured table data
Build formulas and use Excel functions expected at the exam
Prepare for the MOS Excel Associate exam under real conditions

Prerequisites

No prerequisites

Course Content

Module 1: Manage worksheets and workbooks

Import data into workbooks
- Import data from .txt files
- Import data from .csv files
Navigate within workbooks
- Search for data within a workbook
- Navigate to named cells, ranges, or workbook elements
- Insert and remove hyperlinks
Format worksheets and workbooks
- Modify page setup
- Adjust row height and column width
- Customize headers and footers
Customize options and views
- Customize the Quick Access toolbar
- Display and modify workbook content in different views
- Freeze worksheet rows and columns
- Change window views
- Modify basic workbook properties
- Display formulas
Configure content for collaboration
- Set a print area
- Save workbooks in alternative file formats
- Configure print settings
- Inspect workbooks for issues

Module 2: Manage data cells and ranges

Manipulate data in worksheets
- Paste data by using special paste options
- Fill cells by using Auto Fill
- Insert and delete multiple columns or rows
- Insert and delete cells
Format cells and ranges
- Merge and unmerge cells
- Modify cell alignment, orientation, and indentation
- Format cells by using Format Painter
- Wrap text within cells
- Apply number formats
- Apply cell formats from the Format Cells dialog box
- Apply cell styles
- Clear cell formatting
Define and reference named ranges
- Define a named range
- Name a table
Summarize data visually
- Insert Sparklines
- Apply built-in conditional formatting
- Remove conditional formatting

Module 3: Manage tables and table data

Create and format tables
- Create Excel tables from cell ranges
- Apply table styles
- Convert tables to cell ranges
Modify table
- Add or remove table rows and columns
- Configure table style options
- Insert and configure total rows
Filter and sort table data
- Filter records
- Sort data by multiple columns

Module 4: Perform operations by using formulas and functions

Insert references
- Insert relative, absolute, and mixed references
- Reference named ranges and named tables in formulas
Calculate and transform datas
- Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
- Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
- Perform conditional operations by using the IF() function
Format and modify text
- Format text by using RIGHT(), LEFT(), and MID() functions
- Format text by using UPPER(), LOWER(), and LEN() functions
- Format text by using the CONCAT() and TEXTJOIN() functions

Module 5: Manage charts

Create charts
- Create charts
- Create chart sheets
Modify charts
- Add data series to charts
- Switch between rows and columns in source data
- Add and modify chart elements
Format charts
- Apply chart layouts
- Apply chart styles
- Add alternative text to charts for accessibility

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-200 exam: Microsoft Excel 2019 / 365
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 Associate certification in 2026

The Microsoft Office Specialist Excel Associate certification is Microsoft’s official recognition of an intermediate to advanced Excel level. On a resume, it objectively attests to skills validated by a hands on exam. The MOS Excel training prepares you precisely for this exam over two intensive days.

The content of the MOS Excel Associate certification

The MOS Excel Associate exam covers five major domains: worksheet and workbook management, cells and ranges management, tables management, formulas and functions operations, charts management. The training follows this structure.

Excel worksheets, workbooks and cells management

The training places significant focus on managing Excel worksheets and workbooks per MOS standards. You learn to create, import and organize workbooks, navigate efficiently in Excel, save in different formats, manage display and printing options.

Excel tables, formulas and functions at MOS level

Excel tables and structured data are a key exam topic. The training details table creation, structured references, filters, sorts and associated formulas.

The Excel formulas and functions expected at the MOS Associate exam include SUM, AVERAGE, IF, COUNTIF, SUMIF, VLOOKUP and common date and text functions.

Geneva and Lausanne profiles who benefit from the certification

The MOS Excel Associate training is designed for junior management controllers, analysts, administrative assistants, HR, self employed professionals seeking a strong signal on their Excel level.

Practical MOS Excel training in Geneva and Lausanne

At our ITTA centers in Carouge and Le Flon, this MOS Excel training runs over two days. You work on exercises reproducing the exam format and leave ready to take the certification.

FAQ MOS Excel Associate training

What is the MOS Excel Associate certification?

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

What is the difference between MOS Excel Associate and Expert?

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

Do I need to master Excel before this MOS training?

Yes, regular and intermediate Excel use is required.

Is the MOS Excel exam practical or theoretical?

Practical. The exam asks you to perform concrete tasks on a provided Excel workbook.

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 Associate exam?

The training runs over two intensive days.

What is the professional benefit of the MOS Excel certification?

It objectively attests to a good Excel level and represents a strong signal to recruiters for junior and intermediate analytical roles.

Who this mos excel training is for

Financial, controlling, accounting, administrative profiles and any regular Excel user wanting to validate level via Microsoft certification. 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 Excel mastery for internal evolution. An assistant valuing skills on job market. A freelancer securing credibility with demanding clients. 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 Excel Fundamentals, other Microsoft MOS, MOS Excel Expert. 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 Associate certification validates mastery of Excel essential features in a globally recognized framework. This training specifically prepares for the exam with methodical review and typical test training.

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 of these features 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.

Is the exam included?

Billed separately. The course prepares specifically.

What level required?

Associate validates fundamental skills.

Recognition?

Yes, internationally.

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.