Webinar

4.9

(1)

Excel snack: Automate calculations without programming knowledge

Favorite Share Open as PDF (German) PDF FILE

Content

trainer

Reviews

Events

Contact

This webinar is held in German.

For a long time, there was only one tool for automating calculations in Excel or creating user-defined calculation functions in Excel: VBA. In recent years, however, a number of tools have been implemented in the spreadsheet that can be used to solve such tasks in a different way. The advantage for all users: No programming knowledge is required to achieve the goal. The module presents examples of the new tools using various practical examples.

Choose 4 Excel snacks!

Automate filtering and sorting processes with dynamic matrix functions.
Create user-defined functions in controlling with the help of LET().
Use the LAMBDA function for recursive functions.
Use ChatGPT in Excel to automate tasks.

Please note:

The module is part of the webinar series "Excel snacks in controlling" and cannot be booked individually. Select a total of four "Excel snacks" and improve your Excel knowledge in a targeted manner.

Learning environment

Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.

Your benefit

You will receive a brief and concise overview of the topic and compact knowledge of the new options that Excel offers for the individualization and automation of calculations.
They reduce the amount of work involved in repetitive tasks when dealing with large volumes of data.
You will learn how to easily summarize frequently required calculation steps and call them up again at any time.
The webinar will take place live and you will have the opportunity to ask your questions and benefit from the discussions in the group.

trainer

Stephan Nelles

Methods

Live online webinar with presentation, discussion of sample solutions, tips and tricks, question and answer session.

Recommended for

The webinar is suitable for controllers who have a sound knowledge of Excel and would like to expand their Excel knowledge in a targeted and customized manner.

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.

Seminar evaluation for "Excel snack: Automate calculations without programming knowledge"

4.9 from 5

with 1 rating

training content:

Content comprehensibility:

Practical relevance:

3.7

Trainer expertise:

Participant orientation:

Method variety:

Joint online training

Booking number
35320

€ 172,- plus VAT

Details

1 module of 1.5 ...

Online

2 Events

German

Events

Train several employees internally

Pricing upon request

Customized training courses according to your needs
Directly at your premises or online
Cost advantage from 5 participants
We contact you within 24 hours (Mon-Fri)

1 module of 1.5 hours each.

In-person or Online

Request

This training is available as part of course:

Excel snacks in controlling

Start dates and details

02.06.2025

Live-Online

Details

Booking number: 35320

€ 172,- plus VAT.

€ 204.68 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 module of 1.5 hours each.

Monday, 02.06.2025

2:00 pm - 3:30 pm

17.09.2025

Live-Online

Details

Booking number: 35320

€ 172,- plus VAT.

€ 204.68 incl. VAT.

Course

zoom

Technical notes

We use various software to conduct our online events.

To the system check

Days & Times

1 module of 1.5 hours each.

Wednesday, 17.09.2025

2:00 pm - 3:30 pm

Sufficient places are still free.

Don't wait too long to book.

Fully booked.

Training is guaranteed to take place

The next booking ensures this course will take place

Booking number: 35320

€ 172,- plus VAT.

€ 204.68 incl. VAT.

Details

1 module of 1.5 hours each.

Booking number: 35320

€ 172,- plus VAT.

€ 204.68 incl. VAT.

Details

1 module of 1.5 hours each.

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.

2,500+ further training

600,000+ apprentices per year

Over 95% positive reviews

2,500 trainers and coaches

17,500+ training courses held per year

Call us or send an email