Microsoft Excel Trainings

Microsoft Excel: the cornerstone of business data analysis

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.

Excel levels and themes covered by our catalogue

Excel Fundamentals

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 and Advanced

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.

Excel Power Query (data preparation and transformation)

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.

Excel Power Pivot (analytical modelling)

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 (macro automation)

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.

PivotTables and advanced formulas

Our catalogue covers specialised training on PivotTables, advanced formulas (LET, LAMBDA, dynamic array functions), and financial modelling on Excel.

Build your Excel path according to your profile

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.

Featured courses in this catalogue

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

• 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
• Excel – Giving visual impact to your spreadsheets

Excel and related skills

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.

Excel trends in 2026

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.

Excel training in Geneva, Lausanne and online

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.

Why choose ITTA

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.

FAQ

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.