Sie befinden sich hier: Computer science > User courses and web design > Microsoft programs, Windows > Excel courses (cert.)

Excel course: further education, training, offers and schools at a glance

to providers
(6) Infos, tips & tests Video stories
(2)

Are you looking for an Excel course to learn how to use the spreadsheet program to meet your needs? With Excel, you can calculate, use date and look-up functions, visualize data and consolidate worksheets/folders. In a course, you will learn how to use the most important and efficient functions of Excel and how to work efficiently with this program.

Here you will find suitable schools as well as further information, tips and resources for further training.

Would you like personal advice on the offer? Contact the provider of your choice via the "Free information on the topic..." button - without obligation, quickly and easily.

Download checklists

Checklist «Finding the right further training» » download here

Checklist «Choosing the right school» » download here

Excel course: manage and process data with the spreadsheet program

Excel from Microsoft Excel offers a wide range of options for data management and data processing. Whether as databases for addresses, account management, data collections, the basis for evaluations or calculations for budgets - the options that Excel offers are almost endless. Get to know the program better in an Excel course so that you can complete tasks efficiently.

Depending on the level of difficulty and duration, an Excel course covers the following topics, for example:

  • Excel basics and functions
  • Table structure
  • Spreadsheets
  • Cell functions and cell formats
  • Workbooks
  • Excel formulas for calculating, totaling and extracting
  • Cell references
  • Functions and matrix functions
  • Calculations
  • Formatting tables by grouping and sorting
  • Consolidate tables
  • List tables
  • Diagrams
  • Create templates (cell protection)
  • Create forms
  • Data visualization
  • Interactive dashboards
  • Data formatting
  • Page layout and printing
  • Bivot tables and data analysis
  • Data exchange and object integration
  • Various tools for data evaluation

Would you like to learn how to work with Excel or learn how to work more efficiently with the spreadsheet program? Then you should take a course to acquire basic knowledge, skills or even expert knowledge. Learn the most important formatting, functions and options for calculations, data summaries, data processing or evaluations in a course.

On the education platform Ausbildung-Weiterbildung.ch you will find a list of providers of Excel courses. You can quickly and easily order further information from the individual providers or register for an Excel course straight away.

Questions and answers

Most Excel courses include a course confirmation or course certificate. This briefly summarizes the content taught and certifies course participation including the date.

However, if you are looking for a recognized Excel course certificate according to international standards and already have basic knowledge, you should complete the ECDL Excel Spreadsheet module. There you learn:

  • Set up calculations of varying complexity
  • Structure tables and make them meaningful
  • Import and prepare data
  • Manage, sort and filter Excel databases
  • Evaluate data, even across multiple spreadsheets (pivot tables)
  • Building what-if scenarios
  • into meaningful diagrams
  • Create forms with fields and input checks
  • Automate processes
  • know the versatile functions and applications of Excel
  • use the efficient working methods

An alternative Excel course with certificate would also be the SIZ.

In an Excel basic course I learn the following:

  • Structure and mode of operation
  • Creating, opening and saving tables and tabs
  • Ribbon and its functions
  • Help under Excel
  • Working with formulas and predefined functions
  • Examples with absolute and relative references
  • Number and text formats

 

Learning Excel is quick with the right course.

To be able to learn Excel VBA, you already need in-depth experience with Excel. Only then can you get to know the basics of object-oriented programming VBA (Visual Basic for Applications). Everyday and recurring tasks can be solved efficiently with the VBA programming language. In an Excel Visual Basic course, participants learn the following:

  • Basic concepts
  • The Visual Basic Editor (VBE)
  • Macros (write code)
  • Basic syntax in modules
  • Procedures and functions
  • Variables and data types
  • Operators
  • Branches (IF... THEN... ELSE...)
  • Loops (FOR...NEXT, Do...Loop)
  • Error handling
  • Input Box

If you are looking for the "Learn Excel Advanced" option, you must already have basic PC skills and basic Excel knowledge. Practical experience with Excel is also required for the Excel Advanced course.

There are the following different Excel courses that can be completed at training providers and are frequently offered:

  • Excel basics course
  • Excel advanced course
  • Excel for advanced learners course
  • Excel refresher course
  • Excel Controlling course
  • VBA course
  • Pivot tables course
  • Power Pivot Course
  • Word Excel course
  • Microsoft Excel course or Microsoft Excel for Mac course

The following content is taught in an Excel Advanced course:

  • Apply complex formulas and functions
  • Linking tables
  • Conditional table format (colored cells due to calculation)
  • Graphic representations for advanced users
  • Automate workflows
  • Sort and filter lists
  • Evaluate database
  • Import and export of data

 

This Excel training course teaches you how to use Excel professionally.

To attend Excel courses for beginners, you need some computer skills including mouse operation and window technology. The use of the Ribbon and Explorer (file manager) is a prerequisite. To be on the safe side, find out about the admission requirements for each Excel course before attending.

Redaktionelle Leitung:

Stefan Schmidlin, Bildungsberatung, Content-Team Modula AG

Quellen

Website des Schweizerischen Sekretariats für Bildung, Forschung und Innovation SBFI , Website www.berufsberatung.ch (offizielles schweizerisches Informationsportal der Studien-, Berufs- und Laufbahnberatung) sowie Websites und anderweitige Informationen der Berufsverbände und Bildungsanbieter.

Overview of providers for Excel course

Erfahrungen, Bewertungen und Meinungen zur Ausbildung / Weiterbildung

Preview of the video «4 Schritte zur richtigen Weiterbildung»
Preview of the video «Warum Ausbildung-Weiterbildung.ch? Bildungsportal mit top Service für Bildungsinteressenten»

Haven't found the right training or further education yet? Benefit from educational advice now!

Further training is not only important in order to maintain or increase professional attractiveness, investing in training or further training is still the most efficient way to increase the chances of a pay rise.

The Swiss education system offers a wide range of individual training and further education opportunities - depending on your personal level of education, professional experience and educational goals.

Choosing the right educational offer is not easy for many prospective students.

Which training and further education is the right one for my path?

Our education advisory team will guide you through the "education jungle", providing specific input and relevant background information to help you choose the right offer.

Your advantages:

You will receive

  • Suggestions for suitable courses, seminars or training programs based on the information you provide in the questionnaire
  • An overview of the different levels and types of education
  • Information about the Swiss education system

We offer our educational counseling in the following languages on request: French, Italian, English

Register now and concretize your training plans.

 

Sofort zur richtigen Weiterbildung

Filter by teaching method:
Other (0)
Filter by region:
Address:
Fabrikweg 2
8306 Wangen-Brüttisellen
CT Academy AG
The CT Academy (CT = Customized Training) offers innovative learning solutions, managed training services and further education in the form of high-quality training courses. The focus is on the ICT sector for companies, public institutions and private individuals.

We take care of your training project from the strategic needs analysis to the design, implementation and subsequent evaluation. In doing so, we rely on partnerships with numerous manufacturers and experts to find the best learning solution for our customers that fits their budget.

We focus on our participants and their wishes. That is why we adapt the learning solution, language and learning content individually at all times. We are absolutely convinced of the quality of our training and therefore offer a satisfaction guarantee for our classroom training, online live webinars, blended learning, private workshops and company seminars.
Region: Westschweiz, Zürich
Sites: Wallisellen, Lausanne
Next start date
Wallisellen
possible at any time
Certifications, Memberships, Qualifications:
Firmenangebote
Receive free information on the topic Excel courses (cert.) immediately by email
Address:
Industriestrasse 30
8302 Kloten
act-Academy GmbH
For over 30 years, the act-Academy has been imparting targeted knowledge on the topics of office applications and IT administration - so that you, as an employee and as a company as a whole, can be successful in the job market. The focus is on the productivity of the trainees. We offer practice-oriented training and services on Microsoft Office, Windows, Microsoft Server, customer-specific projects, IT migrations, business administration and translations. Company training for individuals, small groups and entire classes is our specialty. Our trainers have practical know-how and many years of experience in the field of adult education.
With the act-Academy, you are guaranteed to achieve your goals - and therefore your personal success - several times over!
Region: Zürich
Sites: Kloten, Online Teilnahme bei allen Kursen möglich
Next start date
Kloten
13/05/2024
Receive free information on the topic Excel courses (cert.) immediately by email
Address:
Hirschengraben 43
6003 Luzern
eCertificate
eFachausweis is your partner for personal, competent and flexible online preparation for the professional examination.

We believe in contemporary and individualized higher vocational education and training. For us, contemporary means that we make use of current and future learning opportunities. These opportunities pave the way for personal, competent and flexible preparation for the professional examination.

Individualization is reflected in our offers and services. For example, depending on your needs and course, you can prepare for the professional examination either completely independently or in a class group. You will receive individual support from experts in the mentoring learning program. We offer you the opportunity to create your own personal examination documents for various courses.
Strengths: Thanks to online teaching with 100% flexibility, you can obtain a federally recognized certificate.
Region: Aargau, Basel, Bern, Liechtenstein, Ostschweiz, Tessin, Virtuelles Klassenzimmer, Westschweiz, Zentralschweiz, Zürich
Sites: Online
Certifications, Memberships, Qualifications:
Firmenangebote
Bildungsberatung
Blended Learning
Bundesbeiträge
eduQua
Innovative Ausbildungsmethoden
Online-Unterricht
Receive free information on the topic Excel courses (cert.) immediately by email
Address:
Hermetschloostrasse 77
8048 Zürich
WEKA Business Media AG
(5,4) Very good 15 15 Ratings (100% )
Praxisseminare.ch is the comprehensive seminar and congress program of WEKA Business Media AG. Our training courses are aimed at managing directors, executives, HR managers, accounting managers, bookkeepers, controllers, trustees, lawyers, architects, real estate managers, office managers and specialists from technical professions.
The current program currently comprises over 270 different specialist or management topics, all of which have a strong practical focus. We also offer many of these topics in French. Our locations are Zurich and Lausanne.

The main aim of our activities is to offer one-day formats with the greatest possible benefit for daily work practice: the focus is on acquiring methodological and practical skills. You benefit from the expertise, know-how and many years of practical experience of our speakers, with the guarantee that the focus is always on practical relevance and real customer needs.

Your Praxisseminare.ch team
Region: Zürich
Sites: Zürich
Next start date
SIB Schweizerisches Institut für Betriebsökonomie
continuous
Certifications, Memberships, Qualifications:
Firmenangebote
Online-Unterricht
Receive free information on the topic Excel courses (cert.) immediately by email
Address:
Limmatstrasse 50
8005 Zürich
Digicomp Academy AG
Region: Basel, Bern, Westschweiz, Zürich
Sites: Zürich
Receive free information on the topic Excel courses (cert.)
Address:
Jurastrasse 5
2540 Grenchen
VHS Adult Education Center Grenchen
Region: Bern
Sites: Grenchen
Receive free information on the topic Excel courses (cert.)

Schulen mit zertifizierter Bildungsberatung