The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration

Microsoft Excel: Using formulas and functions efficiently

Online
1 day
German
Download PDF
€660
plus VAT.
€785.40
incl. VAT.
Booking number
31225
Venue
Online
6 dates
€660
plus VAT.
€785.40
incl. VAT.
Booking number
31225
Venue
Online
6 dates
Become a certified
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training just for your employees - exclusive and effective.
Inquiries
In cooperation with
In cooperation with
ITech Progress
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.
Contents
  • 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
Goetz Sattler
Frans Parren
Valentin Rausch
Arno Burger
Antonio Argibay da Silva
René Pukall
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.

 

 

Final examination
Recommended for

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

Basic knowledge is required.

Start dates and details

Form of learning

Learning form

18.9.2026
Online
Places free
Implementation secured
Online
Places free
Implementation secured
20.10.2026
Online
Places free
Implementation secured
Online
Places free
Implementation secured
30.11.2026
Online
Places free
Implementation secured
Online
Places free
Implementation secured
24.2.2027
Online
Places free
Implementation secured
Online
Places free
Implementation secured
21.6.2027
Online
Places free
Implementation secured
Online
Places free
Implementation secured
6.9.2027
Online
Places free
Implementation secured
Online
Places free
Implementation secured
No items found.
No items found.
*Mandatory fields

Do you have questions about training?

Call us on +49 761 595 33900 or write to us at service@haufe-akademie.de or use the contact form.

The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration