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
Your benefit
- You can build and nest formulas and functions.
- You will learn how to perform more complex calculations efficiently.
- You will save time in your day-to-day work in the future.
Methods
Presentation, expert input, practical tasks and exercises.
Please use a notebook with the Microsoft Office program installed (version 2016/2019/365).
We recommend that you work 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.
Further recommendations for "Microsoft Excel: Using formulas and functions efficiently"
Attendees comments
"I particularly liked the fact that it was very well structured, with lots of examples and well explained."

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

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

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

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

"Very good lecturer with a high level of expertise."

Seminar evaluation for "Microsoft Excel: Using formulas and functions efficiently"







Start dates and details

Friday, 18.07.2025
09:00 am - 5:00 pm

Monday, 15.09.2025
09:00 am - 5:00 pm

Wednesday, 26.11.2025
09:00 am - 5:00 pm

Wednesday, 17.12.2025
09:00 am - 5:00 pm

Monday, 09.02.2026
09:00 am - 5:00 pm

Friday, 27.03.2026
09:00 am - 5:00 pm