Spreadsheet Trainings

Excel: a fast-evolving sector

Excel remains the most used business tool in French-speaking Switzerland, particularly in finance, controlling, HR, procurement, marketing and data analysis functions. Advanced Excel mastery has become a central recruitment criterion and a differentiating factor for internal evolution. Beyond basic formulas, pivot tables, Power Query, Power Pivot and VBA macros sustainably structure the productivity of professionals exploiting business data.

Deep Excel training represents a particularly rewarding professional investment: greater autonomy, daily time savings, ability to structure and reliably analyse data, and differentiation in hiring on administrative and finance positions. ITTA offers a catalogue of training courses in this sub-domain, delivered by Excel expert trainers active in data analysis and automation projects for Swiss organisations.

Whether you are discovering Excel, preparing the MOS Excel Expert certification, or wanting to automate your processing via Power Query and VBA, our sessions in Geneva and Lausanne cover your full path from beginner to expert mastery.

The axes of our Excel catalogue

Excel beginner and intermediate

For profiles discovering Excel or wishing to consolidate the basics, Excel beginner training covers the interface, data entry, formatting, basic formulas and charts. Excel intermediate training deepens advanced functions (VLOOKUP, INDEX-MATCH, nested IF), structured tables and validation tools. These courses target assistants, administrative profiles and reskilling employees seeking autonomy on their daily entry and simple analysis tasks.

Advanced Excel and pivot tables

Advanced Excel training covers complex functions (XLOOKUP, LET, LAMBDA, dynamic array functions), pivot tables and pivot charts. Pivot tables have become the essential tool for controllers, financial analysts and marketing managers to quickly explore large data volumes and produce visual summaries. Our advanced pivot table course covers custom calculations, date grouping, slicer filtering and dashboard creation.

Power Query and Power Pivot for modelling

Power Query (Get & Transform) automates data collection, cleaning and transformation from multiple sources (Excel files, CSV, databases, web). Power Pivot extends Excel with a true relational modelling engine (table relationships, DAX measures, hierarchies). These two tools transform Excel into a powerful data analysis platform and represent an important step before Power BI. Our Power Query and Power Pivot training targets analysis-oriented profiles exceeding classic spreadsheet limits.

VBA macros and automation

VBA macros (Visual Basic for Applications) automate repetitive tasks, create custom user interfaces and connect Excel to other applications. Our VBA training covers macro recording, structured VBA code writing, userform usage, event handling and database interaction. These courses target Excel super users and profiles industrialising their recurring processing to save time and reliable outputs.

Microsoft Access and office databases

Microsoft Access remains relevant for advanced users building business applications without a developer: entry forms, structured queries, reports and shared databases. Our Access training covers modelling, SQL queries, forms and reports, as well as the bridge to SQL Server for profiles transitioning to more robust databases.

Which path for which professional goal

A beginner or reskilling profile follows Excel beginner then Excel intermediate to acquire basic autonomy. An assistant or controller adds advanced Excel and pivot tables to handle business data. A financial analyst or BI manager moves to Power Query, Power Pivot and the data model to handle larger volumes. A super user wishing to automate their processing follows the VBA training. To officially validate the path, MOS Excel Associate then Expert are particularly valued certifications on the French-speaking Switzerland market.

Excel in a skills ecosystem

Excel naturally extends to other skills. Data analysis and BI training introduces Power BI, which complements Excel for visual dashboard creation and enterprise sharing. AI training brings an essential complementary dimension with Microsoft Copilot in Excel, which automates certain analyses and generates VBA code or complex formulas. Office productivity certifications (MOS Excel) officially validate your level. The analytics and data management hub deepens SQL Server for profiles exceeding Excel capabilities.

Excel evolutions to know

Several evolutions structure Excel in 2026. Microsoft Copilot in Excel transforms productivity with automatic complex formula generation, natural language analysis (“What are the 10 biggest customers of the year?”), automatic pivot table creation and VBA code writing. Dynamic array functions (FILTER, SORT, UNIQUE) profoundly modernise analysis patterns. LAMBDA and LET introduce custom functions without VBA. Power Query continues to enrich with new native connectors to cloud sources. Excel remains central, particularly in Swiss finance, despite the rise of Power BI.

Practical aspects of our Excel training

All our Excel training courses are available on-site in our Geneva (Route des Jeunes 35) and Lausanne (Avenue de Mon-Repos 24) centres, as well as in interactive virtual classroom. Our session calendar, organised in 5-week cycles, allows for swift registration. Our limited group sizes enable genuinely personalised pedagogical support, and each course includes hands-on exercises on real business cases (financial analysis, sales tracking, HR, project management) enabling immediate transposition of learnings into your daily work.

What sets us apart in Excel

ITTA is a certified training centre based in French-speaking Switzerland, partner of Microsoft Office and approved exam centre for MOS Excel certifications. Our trainers are Excel experts active in data analysis and automation projects for Swiss organisations, allowing them to share current concrete cases and adjust content to your business reality. The spreadsheet sub-domain contains training courses covering the full Excel path, from beginner to expert. Several funding paths are possible according to your professional profile.

Featured courses in this catalogue

Here is a selection of reference training courses in this catalogue, accessible directly:

• Office 2021 – What’s New
• Excel – Fundamentals
• Excel – Becoming more efficient
• Excel – Formulas and Functions
• Excel – Preparing for data analysis
• Excel – Charts and Graphs
• Excel – Formulas and Functions Advanced
• Excel – Analyze your data

FAQ

Which Excel training to choose based on my level?

If you are discovering Excel, start with beginner level. If you use basic functions but want to progress on advanced formulas and pivot tables, aim for intermediate then advanced level. For expert functions (Power Query, Power Pivot, VBA, data modelling), follow the advanced modules.

Do I need to master VBA to automate Excel tasks?

Not necessarily: Power Query and dynamic array functions enable automating much processing without VBA. VBA remains relevant for complex automation, custom user interfaces and integration with other Microsoft 365 applications. Microsoft Copilot in Excel today complements both approaches.

How long to become an Excel expert?

Plan 5 days for Excel beginner then 5 days for advanced/pivot tables, and 3 to 5 additional days for Power Query/Power Pivot or VBA. With regular practice on real cases, expect 6 to 12 months to reach expert level and pass the MOS Excel Expert certification.

What professional funding options are available?

Several professional funding solutions can be considered depending on your situation and your employer. Our team helps you identify the options that fit your profile.