The advanced Excel training gives you the keys to go far beyond the basics of the spreadsheet and fully exploit the power of complex formulas. In one intensive half day, you learn to chain nested functions, work with absolute and relative references reliably, and use lookup functions like VLOOKUP to combine data across sheets. A skill that has become central in most analytical roles in French speaking Switzerland.
Move from simple calculations to advanced Excel formulas that save real time
In organizations across Geneva and Lausanne, building advanced Excel formulas makes the difference between a workbook that updates itself and a file you have to fix every week. This advanced Excel training favors hands on practice: conditional financial calculations, named ranges, nested logical functions, lookup functions. By the end of the training, you take home reflexes you can apply immediately to your own files, plus course materials to dig deeper at your own pace.
Module 1: Setting up complex calculations
Module 2: Range names
Module 3: Functions
Mastering Excel basics is no longer enough in most finance, HR or administrative roles. Recruiters and managers now expect real fluency with advanced formulas: VLOOKUP, nested logical functions, named ranges, conditional functions. This advanced Excel training takes you from the everyday user level to a true operational level on complex files in just half a day.
The goal is not to memorize a list of functions but to develop the right reflexes: when to use a single IF rather than a nested IF, how to make a reference reliable with a named range, how to avoid the classic calculation errors. The advanced Excel training is designed for users already comfortable with the basics who want to take the next step.
The training covers the functions that make up the daily work of analysts and management controllers: nested IF for multiple conditions, AND and OR to combine criteria, COUNTIF and SUMIF for conditional counts and totals, VLOOKUP to look up information from another table. These functions are practiced on real cases: commission calculations, budget tracking, analytical breakdowns.
You also learn how to combine several functions in a single formula (nested functions) and how to handle absolute, relative and mixed references. These notions are essential as soon as an Excel file needs to be copied across rows or columns without breaking the calculations.
Microsoft has been evolving Excel functions over the past few years. The training mentions XLOOKUP, which is gradually replacing VLOOKUP with simpler and more robust syntax. Modern dynamic array functions like FILTER and UNIQUE now make it possible to extract or deduplicate data in a single formula. To go further on these modern Excel 365 functions, the Excel array formulas course takes the relay.
The training is designed for Excel users who produce increasingly complex files: management controllers consolidating multiple sheets, HR staff cross referencing payroll data, assistants automating their reporting, project managers tracking budgets and schedules, self employed professionals running their own activity. The condition: regular Excel use and a desire to go beyond the basic functions.
At our ITTA centers in Carouge and Le Flon, this advanced Excel training runs as an intensive half day with an expert instructor and a small group to ensure personalized follow up. You work on real workbooks, you test each formula on your own examples, and you leave with course materials to reproduce the steps at your desk.
What is the difference between basic Excel training and advanced Excel training?
The basic level covers data entry, formatting and simple calculations. The advanced Excel training focuses on complex formulas, nested functions, lookup functions and named ranges. It is the level expected in most analytical roles.
Which Excel functions are covered in this advanced training?
VLOOKUP, IF, AND, OR, COUNTIF, SUMIF, ROUND, date functions, text functions. The training also focuses on nested functions and absolute or relative references.
VLOOKUP or XLOOKUP: which one to learn in advanced Excel training?
VLOOKUP is still the most widespread function in business and the training covers it. XLOOKUP is more recent and is now recommended by Microsoft. The training mentions XLOOKUP and the Excel Array Formulas course takes this further.
Do I need to know Excel basics for this advanced training?
Yes. You should be able to enter data, apply formatting and use simple formulas like SUM or AVERAGE. If not yet, the Excel Formulas and Functions course is a better starting point.
Is this advanced Excel training delivered in Geneva?
Yes, the training takes place at the ITTA center in Carouge in Geneva, as well as at Le Flon in Lausanne and in a virtual classroom for participants attending remotely.
How long does it take to master Excel at an advanced level?
The key concepts are acquired in a structured half day. Real mastery comes with practice on your own files and gradual application of the formulas learned.
Does advanced Excel training prepare for a certification?
This training is non certifying. To prepare for an Excel certification, the Microsoft Office Specialist – MOS Excel Expert course takes over with a dedicated program.
Analyst, controlling, finance, operations profiles wanting to master advanced Excel functions (XLOOKUP, FILTER, LET, modern array functions, nested functions). 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.
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.
An analyst replacing VLOOKUPs with XLOOKUP gaining simplicity and reliability. A controller mastering FILTER and UNIQUE for dynamic analyses. A consultant structuring complex formulas with LET for readability. The course adapts exercises to your context with personalized trainer feedback, and each participant leaves with an action plan calibrated to their own situation.
Combines well with Excel Fundamentals, Excel Dynamic Array formulas, Excel PowerQuery for data preparation. Many participants enroll in one of these courses in the following trimester, according to their current priority and professional context.
Excel has profoundly evolved since 2020 with dynamic array functions (FILTER, UNIQUE, SORT, SEQUENCE) and modern functions (XLOOKUP, LET, LAMBDA). These evolutions transform calculation methods and unlock previously impossible use cases. This training targets advanced users wanting to master this modernity.
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.
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.
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.
Does it cover XLOOKUP and FILTER?
Yes, these modern functions are at the course core.
Need Excel 365 license?
Yes, modern functions are not in Excel 2019 perpetual.
Is LAMBDA addressed?
Yes, LAMBDA is introduced for very advanced users.
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.
Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00
ITTA
Route des jeunes 35
1227 Carouge, Suisse
Monday to Friday, from 8:30 am to 06:00 pm.
