ITTA offers a complete catalogue of Microsoft Excel training: Excel Fundamentals, Excel Intermediate, Excel Advanced, Excel Power Query, Excel Power Pivot, Excel VBA for automation, Excel PivotTables, Excel advanced formulas and MOS Excel (Microsoft Office Specialist) certification preparation. Our Excel training is delivered in Geneva, Lausanne and virtual classroom by trainers expert in data analysis.
FILTER BY
- Domains
- Editors
- Location
- Format
- Level
- Certifying
- Confirmed training
Beginner Excel training in Geneva and Lausanne. 1 day to master Microsoft Excel, calculations and tables at ITTA Switzerland.
Excel productivity training in Geneva and Lausanne. Half a day to master shortcuts and time-saving techniques at ITTA Switzerland.
Excel Formulas and Functions training in Geneva and Lausanne. Master core calculations and essential Excel functions in half a day with ITTA.
Power Query training in Geneva and Lausanne. Half a day to prepare, clean and transform your Excel data before analysis at ITTA Switzerland.
Excel charts training in Geneva and Lausanne. Half a day to master professional Excel charts and graphs at ITTA Switzerland.
Advanced Excel training in Geneva and Lausanne. Master complex formulas, VLOOKUP and nested functions in just half a day with ITTA Switzerland.
Pivot table training in Geneva and Lausanne. Analyze your Excel data with pivot tables, slicers, timelines and pivot charts at ITTA Switzerland.
Excel formatting training in Geneva and Lausanne. Showcase your tables with conditional formatting, charts and themes in half a day at ITTA.
Excel array formulas training in Geneva and Lausanne. Master FILTER, UNIQUE, SORT and Excel 365 dynamic array functions at ITTA Switzerland.
Excel dashboard training in Geneva and Lausanne. Build your dashboards with charts, KPIs and visual indicators in half a day at ITTA Switzerland.
Excel macros training in Geneva and Lausanne. Half a day to automate Excel with the macro recorder and start with VBA at ITTA Switzerland.
Excel forms training in Geneva and Lausanne. Half a day to master ActiveX controls and Excel forms at ITTA Switzerland.
Microsoft Excel is, in 2026, widely used data analysis tool in nearly all Swiss companies. Budget tracking, management control, sales reporting, HR analysis, financial modelling, data processing: Excel mastery constitutes a highly demanded skill in all support and business functions. In Geneva, Lausanne and across French-speaking Switzerland, private banks, international organisations, public services, hospitals and industrial companies now expect a true professional level on Excel for most functions.
Following a recognised Excel training opens access to skills valued in all functions: executive assistants, management controllers, HR, lawyers, project managers, consultants, executives, financial analysts. The Microsoft Office Specialist (MOS) Excel certification provides an official benchmark appreciated by recruiters in office support, management control, support functions and finance. Investing in a MOS Excel certification enhances your profile on the French-speaking Swiss market.
ITTA offers a catalogue dedicated to Microsoft Excel, from Fundamentals level to advanced usages (Power Query, Power Pivot, VBA, PivotTables, dynamic array formulas). Each session is built around practical cases inspired by the daily work of Swiss companies, with to enable personalised support.
Whether you are an assistant, management controller, HR, project manager, consultant, financial analyst or evolving Excel user, our Excel training in Geneva and Lausanne provides the practical skills to sustainably gain efficiency, professionalise your analyses and pass the MOS certification if you target it.
The Excel Fundamentals training lays the basics: interface, data entry, formatting, simple formulas, common functions (SUM, AVERAGE, IF, VLOOKUP), basic tables and charts. This training suits beginner profiles and all those wishing to revisit basics before tackling advanced usages.
Excel Intermediate deepens calculation functions (XLOOKUP, INDEX/MATCH, date and text functions), PivotTables, advanced charts, conditional formatting and data validation. Excel Advanced deepens dynamic array formulas (LET, LAMBDA), database functions, names and dynamic ranges, and complex workbook auditing.
Power Query is the data preparation and transformation tool integrated into Excel. Our training covers import from multiple sources (files, SQL databases, web), transformations (pivot, unpivot, merge, aggregate), the creation of reusable data models and connection to cloud services. This skill is highly valued for management controllers and data analysts.
Power Pivot brings in-memory analytical modelling to Excel, with the DAX language. Our training covers relational models, DAX measures, hierarchies and KPI scorecards. This skill naturally extends Power Query towards self-service BI complementing Power BI.
Excel VBA is Excel’s macro language, particularly useful to automate repetitive tasks, develop internal tools and extend Excel. Our training covers VBA language basics, macro recording, event management and best practices.
Our catalogue covers specialised training on PivotTables, advanced formulas (LET, LAMBDA, dynamic array functions), and financial modelling on Excel.
A beginner follows Excel Fundamentals then Excel Intermediate to gain current ease. A management controller progresses to Excel Advanced then Power Query and Power Pivot to structure analyses. An executive assistant regularly producing reports adds PivotTables. A financial analyst follows Excel Advanced and financial modelling. A profile wishing to automate tasks follows Excel VBA. For official recognition, the MOS Excel certification validates the entire foundation.
Here is a selection of reference training courses in this catalogue, accessible directly:
Excel training fits into a broader office automation and data ecosystem. The office automation sub-domain covers all Office usages. The office automation certifications sub-domain leads to the internationally recognised MOS exams. Data analysis BI training brings Power BI, naturally complementary to Excel Power Query and Power Pivot. The Access database management sub-domain covers Access for profiles exceeding Excel. The no-code development domain covers Power Platform, integrated with Excel.
Several evolutions are shaping Excel in 2026. Microsoft Copilot integrates natively into Excel for LET, LAMBDA functions, data analysis and PivotTable generation. Power Query and Power Pivot continue to modernise data analysis in Excel. Connection to cloud services (Azure SQL, Dataverse, OneDrive, SharePoint) becomes native. Dynamic array formulas transform classic approaches. Shared workbook governance via SharePoint and OneDrive becomes a structuring topic. Our pedagogical content regularly integrates these evolutions to remain aligned with current company practices.
All our Excel training courses are available on-site in our Geneva and Lausanne centres, as well as in interactive virtual classroom with a live trainer. Our sessions are organised in 5-week cycles. Short formats, from half a day to two days, suit the busy agendas of executives and assistants. Customised corporate training is also possible at your premises, in Geneva, Lausanne, Vaud and across French-speaking Switzerland, with a programme adapted to your internal templates.
ITTA offers a training catalogue, official partner of Microsoft Office. Our Excel trainers are management controllers, financial analysts and consultants active in Swiss companies, allowing them to share proven templates and best practices directly usable. The Excel catalogue regroups our training courses covering all levels and themes. Our pedagogical team supports you in choosing the right path, preparing the MOS Excel certification and identifying the funding solutions adapted.
Do I need Excel knowledge before Excel Fundamentals?
No. Excel Fundamentals is designed for profiles without prior experience. Good general IT ease is sufficient. For users already comfortable with the basics, our Intermediate, Advanced, Power Query, Power Pivot, VBA or PivotTables training courses quickly bring valuable skills.
What is the difference between Power Query, Power Pivot and VBA?
Power Query prepares and transforms data before analysis. Power Pivot models analytically in memory with DAX. VBA automates Excel actions via macros. The three are complementary: Power Query and Power Pivot for no-code data, VBA for classic automation. Our pedagogical team guides you according to your use cases.
Is the MOS Excel certification useful?
Yes. The Microsoft Office Specialist Excel certification is internationally recognised and appreciated by recruiters in office support, management control, support functions and finance. It constitutes an official benchmark particularly useful for profiles in career evolution.
Are your Excel courses available for companies?
Yes, the entire Excel catalogue is available in-house, in Geneva, Lausanne and in virtual classroom, with a programme adapted to your internal templates. Our team builds the specifications with you and organises sessions according to your calendar.
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.
