Microsoft Excel online: Working with formulas and functions

0,5 days

Next date

16.12.2025 | 13 - 16 | Online

all dates
Microsoft Excel online: Working with formulas and functions

Training Types

Open training

Online Live Trainer

0,5 days

7 Dates

Online

Price per participant
390,00 € ()
464,10 € incl. VAT

Good to know
Additional registrations for the same date 20% discount

Included in price

  • Participant certificate
  • Manual
  • 30-day E-Learning bonus program
  • Free hotline

Corporate Training

Presence or Online

0,5 days

Your preferred date

Flexible

Price
On request

Good to know
Content, formats and duration are adapted to your requirements

Languages

  • German
  • English

Trainer Hour

Presence or Online

0,5 days

Your preferred date

Flexible

Price
On request

Good to know
Your coach helps you specifically and automatically expands your knowledge - exactly where you need support.

Languages

  • German
  • English

Training Objectives

In this Excel online training, you will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user. We will show you all the powerful features and possibilities that allow you to quickly and effectively use calculation and spreadsheet functions. Participants will become familiar with the advanced math, statistics and lookup functions.

Course Description

  • Working with large worksheets,
  • Creating complex formulas
  • Relative and absolute reference
  • Using Excel function wizard
  • Creating and editing conditional formatting
  • Logical and Statistical functions: IF, VLOOKUP, SUMIF, COUNTIF
  • Useful tips and tricks

 

Course Prerequisites

The course is for individuals with basic Excel knowledge who are responsible for managing and creating large worksheets and models in Excel.

Our live online training is interactive, hands-on, taught by a live instructor, just like our in-person classes.

You can hear the instruction, see the teachers screen, ask questions, and share your screen—all in real-time.

Online Trainings mit echtem Live Trainer. Wir empfehlen die Nutzung eines HeadsetsOther prerequisites:

  • The product software, Excel on your computer
  • Internet connection
  • Either speakers and microphone, headset with microphone, or a speakerphonePC

All dates at a glance

16.12.2025
0,5 days | 13:00 - 16:00
Online

390,00 € ()
464,10 € incl. VAT

23.02.2026
0,5 days | 09:00 - 12:00
Online

390,00 € ()
464,10 € incl. VAT

16.04.2026
0,5 days | 13:00 - 16:00
Online

390,00 € ()
464,10 € incl. VAT

12.06.2026
0,5 days | 13:00 - 16:00
Online

390,00 € ()
464,10 € incl. VAT

12.08.2026
0,5 days | 13:00 - 16:00
Online

390,00 € ()
464,10 € incl. VAT

28.10.2026
0,5 days | 09:00 - 12:00
Online

390,00 € ()
464,10 € incl. VAT

16.12.2026
0,5 days | 13:00 - 16:00
Online

390,00 € ()
464,10 € incl. VAT

Places available only a few registrations possible already fully booked

Your data will not be shared. Free cancellation is possible up to 2 weeks before the start of the seminar.

Further details

Course services

  • Experienced trainers with professional and pedagogical training
  • Guaranteed learning success, clarification of your own questions
  • Detailed seminar documents for reference and further study
  • Participant certificate
  • Free hotline
    • Our hotline, which is included in the price, means that attending a training course entitles you to call us for help if you encounter any difficulties.
  • Small working groups with a maximum of ten participants

Book without risk

With us, you can plan safely and flexibly:

  • Free cancellation up to 14 days before the seminar begins.

  • Flexible rebooking: If you cancel up to 7 days before the start, only a small processing fee of 25% will be charged. After that, the full seminar fee is due.

  • Substitute possible: If a participant is unable to attend, their place can be easily transferred at any time.

  • Non-binding reservation: Secure your place on the seminar before booking – even if you are not authorised to book yourself.

  • Payment only after the seminar: You can conveniently settle the invoice after the training has taken place.

For your planning security: Many of our seminars take place with as few as one person – online, at our premises or as in-house training. In the rare event that the minimum number of participants is not reached, we will of course offer you an individual solution:
👉 either as individual training on the same or a suitable date in the near future – with an adjusted duration and tailor-made content.

This allows you to benefit from maximum flexibility and personal support – tailored to your goals.

What participants say

These courses could also be of interest to you