Microsoft Excel: Using formulas and functions efficiently

training

Favorite Share Open as PDF (German) PDF FILE

This training is held in German.

Working with MS Office: Do you already use Microsoft Excel in your day-to-day work? Learn how to use formulas and functions efficiently in this training. This will save you a lot of time in the future. You will also receive lots of practical tips and tricks.

Explanation of the components of a formula.
Structure & effective use of formulas.
Absolute/relative addressing.
Working with names.
Calculations with ranges.
Newer functions in Excel (XVERWEIS, WENNS etc.).
Nesting of functions.
Using database functions.
Tips and tricks for using Microsoft Copilot.

Learning environment

In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.

Your benefit

You can build and nest formulas and functions.
You will learn how to carry out more complex calculations efficiently.
You will save time in your day-to-day work in the future.

trainer

Antonio Argibay da Silva

Methods

Presentation, expert input, practical tasks, and exercises.

Please use a notebook with the Microsoft Office program (version 2016/2019/365) for Windows installed.

We recommend working with two screens so that you can participate in the training in the best possible way.

Recommended for

Anyone who works with Microsoft Excel 2016/2019/365 or the corresponding Microsoft Office versions for Windows.

Basic knowledge is required.

Open Badges - Show what you can do digitally too.

Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

Joint online training

Booking number
31225

€ 660,- plus VAT

Details

1 day

Online

7 Events

German

Events

Train several employees

Price upon request

1 day

In-person or Online

Appointment scheduled on an individual basis

Customized training courses
Direct application in practice
Efficient use of time and resources

100% non-binding inquiry

Feedback within 24 hours

Start request

Further recommendations for "Microsoft Excel: Using formulas and functions efficiently"

You might also be interested in:

Loading recommendations

Ratings and feedback from our participants

4.6

117 Ratings

training content:

4.5

Content comprehensibility:

4.8

Practical relevance:

4.1

Trainer expertise:

4.9

Participant orientation:

4.8

Method variety:

4.7

Raisa Alina Kienast

Confirmed participation

Sojitz SOLVADIS GmbH

Very good lecturer with a high level of expertise.

Mario Bergner

Confirmed participation

Fresenius Kabi Germany GmbH

Thanks to the trainer for his flexibility. He captured our experiences very well in order to respond precisely to our needs.

Jenny Piesker

Confirmed participation

Münchner Wohnen Service GmbH

I particularly liked the fact that everything was clicked live. The training offers a good mix of exercises and theory."

Phillip Bert

Confirmed participation

JobRad GmbH

It was a motivated and competent speaker, a relaxed atmosphere and practical.

Ulrike Eller

Confirmed participation

Sartorius CellGenix GmbH

I can recommend the training because of the good content, good trainers and good handling.

Elisabeth Stinnes

Confirmed participation

Kinexon GmbH

I particularly liked that it was very well structured, with lots of examples and well explained.

Start dates and details

19.05.2026

Live-Online

Details

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Tuesday, 19.05.2026

09:00 am - 5:00 pm

29.06.2026

Live-Online

Details

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Monday, 29.06.2026

09:00 am - 5:00 pm

05.08.2026

Live-Online

Details

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Wednesday, 05.08.2026

09:00 am - 5:00 pm

18.09.2026

Live-Online

Details

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Friday, 18.09.2026

09:00 am - 5:00 pm

20.10.2026

Live-Online

Details

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Tuesday, 20.10.2026

09:00 am - 5:00 pm

30.11.2026

Live-Online

Details

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Monday, 30.11.2026

09:00 am - 5:00 pm

24.02.2027

Live-Online

Details

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 day

Limited number of participants

Wednesday, 24.02.2027

09:00 am - 5:00 pm

Sufficient places are still free.

Don't wait too long to book.

Fully booked.

Training is guaranteed to take place

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Plan course

1 day

Limited number of participants

Booking number: 31225

€ 660,- plus VAT.

€ 785.40 incl. VAT.

Plan course

1 day

Limited number of participants

Book later

You are welcome to make a non-binding advance reservation.

Book in advance

No suitable date?

You are welcome to be notified by e-mail as soon as new dates are released.

e-mail notification

Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

About us - The Haufe Akademie

Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.

Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.

A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.

Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.

3,500+ further training

620,000+ apprentices per year

Over 95% positive reviews

2,600+ trainers and coaches

18,000+ training courses held per year

Call us or send an email