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
(5) 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

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

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.

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

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.

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.

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.

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.

Overview of providers for Excel course

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»
Overview of providers for Excel course

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)
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
» Company conditions and cooperation opportunities
Region: Zürich
Sites: Zürich
Next start date
SIB Schweizerisches Institut für Betriebsökonomie
continuous
Certifications, Memberships, Qualifications:
Firmenangebote
Online-Unterricht
Download info
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.
» Company conditions and cooperation opportunities
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
Download info
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!
» Company conditions and cooperation opportunities
Region: Zürich
Sites: Kloten, Online Teilnahme bei allen Kursen möglich
Next start date
Kloten
12/9/2024
Download info
Address:
Limmatstrasse 50
8005 Zürich
Digicomp Academy AG
Region: Basel, Bern, Westschweiz, Zürich
Sites: Zürich
Order info
Address:
Jurastrasse 5
2540 Grenchen
VHS Adult Education Center Grenchen
Region: Bern
Sites: Grenchen
Order info

Diese Lehrgänge könnten Sie auch interessieren:

Office courses (cert.) Basic course / preliminary course in accounting (cert.) Word courses (cert.) Excel in Controlling (Cert.) Powerpoint courses (cert.) Computer science basics (cert.)

Schulen mit zertifizierter Bildungsberatung

Attraktive Services für SKO Mitglieder

Kostenlose Services

» Bildungsberatung (Wert: CHF 150.–)
Bildungs- und Businessratgeber (Wert: CHF 175.–)

» Rabatte

Attraktive Rabattierungen seitens der Bildungsanbieter.

Massgeschneiderte Bildungsangebote

Ohne grossen Zeitaufwand den besten Trainer, Coach oder Schulungsanbieter finden

Bildungsangebot Schweiz

Aus über 700 Bildungsanbietern das richtige Bildungsangebot finden