Excel courses (cert.)  (Region Zürich):
4 Provider

To participate in Excel courses for beginners, initial computer skills including mouse operation and window technology are required. The use of the Ribbon and Explorer (file manager) is a prerequisite. To be on the safe side, find out about the entry requirements before attending the Excel course.

An advanced Excel course builds on the basics and provides in-depth knowledge for professional use. The aim is to analyze complex data efficiently, create automated workflows and design visually appealing evaluations.

Typical learning content in an Excel course for advanced users:

• Apply complex formulas and functions
• Linking tables with each other
• Use conditional formatting to visually highlight values
• Using diagrams and graphical representations in a targeted manner
• Create automations with macros and other tools
• Sort, filter and analyze data in a targeted manner
• Using database functions
• Importing and exporting data

An advanced course in Excel not only imparts technical knowledge, but also strengthens the understanding of data-based decisions and more efficient processes in everyday working life.

Important: Each school or educational institution can set its own priorities. The actual course content may therefore vary. To make sure what is actually taught in the respective course, it is worth asking directly. Use our contact form to do this - the inquiry will be automatically forwarded to the desired school

If you are looking for an Excel course with a certificate, you have various options in Switzerland - from simple confirmations of attendance to internationally recognized qualifications. In most cases, after completing an Excel course, you will receive a course confirmation or a course certificate that documents your participation, the time period and the content taught. This certificate is ideal as proof of your continuing education, further training and can be attached to your job application.

However, if you would like to obtain a recognized Excel certificate according to international standards and already have basic knowledge, you should complete the ECDL module "Excel Spreadsheet" (European Computer Driving Licence). This certificate is internationally recognized and confirms your ability to use Excel professionally and efficiently. In the ECDL Excel module you will learn, among other things:

• Build calculations of varying complexity
• Structure tables clearly and make them visually appealing
• Import, edit and analyze data
• Manage, sort and filter Excel databases
• Evaluate data across multiple spreadsheets with pivot tables
• Create and calculate what-if scenarios
• Convert data into meaningful diagrams
• Design forms with input fields and checks
• Automate processes and use macros
• use the various functions of Excel efficiently

Another option is the SIZ certificate (Swiss IT Certificate), which also certifies practice-oriented Excel skills at various levels. Both certificates - ECDL and SIZ - are recognized as proof of sound Excel skills in business, administration and education. With this Excel course with certificate, you can not only prove your skills, but also improve your career opportunities and qualify yourself specifically for data-oriented tasks.

If you want to expand or refresh your Excel skills in a targeted manner, there are numerous course options available to you. Many training providers in Switzerland offer Excel courses at different levels and specializations - from basic courses to professional training with VBA. You can choose from the following course types depending on your learning goal, previous knowledge and professional field of application:

• Excel basics course: Ideal for beginners who want to get to know the most important functions, formulas and table layouts.
• Excel advanced course: deepens the knowledge from the basic course and covers topics such as advanced formulas, charts, data analysis and formatting.
• Excel for advanced users Course: For experienced users who want to work with complex functions, links and dynamic tables.
• Excel refresher course: Perfect if you want to update your existing knowledge or use it again with confidence.
• Excel Controlling course: Especially for finance and controlling experts, with a focus on key figure analyses, reports and automated evaluations.
• VBA course: Learn how to create your own macros and automate processes with Visual Basic for Applications (VBA).
• Pivot tables course: Teaches the targeted use of pivot tables and pivot charts for professional data analysis.
• Power Pivot course: Ideal for data analysts who want to efficiently link and analyze large amounts of data.
• Word-Excel course: Combines the most important applications from both programs for everyday office use.
• Microsoft Excel course or Excel for Mac: Teaches the general Excel functions - either for Windows or macOS.

This wide selection allows you to find the right Excel course for your personal or professional goals. Many providers offer Excel courses in face-to-face classes, online or as a hybrid course, so you can learn flexibly and from any location. With a suitable Excel certificate, you can improve your career opportunities and work more efficiently with data, figures and reports in the future.

If you already have a good knowledge of Excel and want to make your work more efficient, a "Learn Excel VBA" course is the ideal next step. VBA stands for Visual Basic for Applications and is the programming language with which you can automate processes in Excel, create your own functions and customize work processes. In such an Excel Visual Basic course, you will learn how to simplify and speed up recurring tasks, complex calculations or data processing with self-written code.

A "Learn Excel VBA" course teaches the following content in a practical way:

• Basic concepts of object-oriented programming and the VBA structure
• The Visual Basic Editor (VBE): Introduction to the development environment in which you write and edit VBA code
• Recording macros and writing code: First steps towards automating simple tasks
• Basic syntax in modules: How commands and structures are built correctly in VBA
• Procedures and functions: Writing and structuring reusable code blocks
• Variables and data types: Saving data and processing it in code
• Operators: Using arithmetic and comparison operations in VBA
• Branches (IF... THEN... ELSE...): Programming decision logic
• Loops (FOR...NEXT, DO...LOOP): Automate repetitive processes
• Error handling: Strategies for avoiding and handling runtime errors
• Input Box: interactively query and process user input

After completing such an Excel Visual Basic course, you will be able to develop your own macros, create automated reports and significantly optimize Excel workflows. Many VBA courses in Switzerland are offered on a part-time basis, online or as classroom training - ideal for anyone who wants to apply their knowledge in their day-to-day work. You will not only learn how to program, but also how to use Excel as a powerful, customizable tool in the future.

If you are interested in the "Learn Excel Advanced" course, you should already have basic PC and Excel skills. Practical experience in using Excel is also required for the Excel Advanced course. However, please enquire at the educational institution of your choice about the respective requirements.

A basic Excel course teaches the most important basics for working confidently with the spreadsheet program. The following topics are usually covered:

• Basics of the structure and operation of Excel
• Create, open and save workbooks and tables
• Navigation and functions of the multifunction bar
• Use of the integrated Excel help
• Introduction to formulas and predefined functions
• Working with relative and absolute cell references
• Number and text formatting for a structured presentation

A basic Excel course lays the foundation for effective use in everyday working life, at university or for private organization. It explains step by step how to create tables, process data and perform simple calculations.

The specific content may vary slightly depending on the educational institution. Each school or academy determines the focus of the course itself. To be sure which content is taught, we recommend contacting the respective school directly.

A contact form is available for this purpose, which can be used to forward questions specifically to the desired educational institution. Make a non-binding inquiry now and get clarity!