training
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.
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.
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.
Further recommendations for "Microsoft Excel: Using formulas and functions efficiently"
Joint online training
Ratings and feedback from our participants
4.6
99
Ratings
training content:
4.5
Content comprehensibility:
4.8
Practical relevance:
4
Trainer expertise:
4.9
Participant orientation:
4.8
Method variety:
4.7
Start dates and details
15.09.2025
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Monday, 15.09.2025
09:00 am - 5:00 pm
26.11.2025
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Wednesday, 26.11.2025
09:00 am - 5:00 pm
17.12.2025
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Wednesday, 17.12.2025
09:00 am - 5:00 pm
09.02.2026
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Monday, 09.02.2026
09:00 am - 5:00 pm
27.03.2026
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Friday, 27.03.2026
09:00 am - 5:00 pm
19.05.2026
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Tuesday, 19.05.2026
09:00 am - 5:00 pm
29.06.2026
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Monday, 29.06.2026
09:00 am - 5:00 pm
05.08.2026
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Wednesday, 05.08.2026
09:00 am - 5:00 pm
18.09.2026
Live-Online
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Course
zoom
Days & Times
1 day
Limited number of participants
Friday, 18.09.2026
09:00 am - 5:00 pm
Training is guaranteed to take place
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Details
1 day
Limited number of participants
Booking number:
31225
€ 660,- plus VAT.
€ 785.40 incl. VAT.
Details
1 day
Limited number of participants
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
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
Do you have any questions?
We are there for you Monday to Friday 8:00 a.m. - 5:00 p.m.
*Mandatory fields
FAQs
Questions & Answers
In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.
Haufe Akademie GmbH & Co. KG
Munzinger Str. 9
79111 Freiburg
Munzinger Str. 9
79111 Freiburg
A brand of
The company
About our offer
- Planning security
- Free seminar places
- Quality standards
- Planning and locations
- Funding opportunities
- Training app
- Business Solutions
Special offers
Contact & Support
