Contents
- Consolidation of basic knowledge
- Working with names for cells or areas.
- Organize and structure tables.
- Link formatting to conditions.
- Complex formulas and functions in various tasks.
- Skillfully use S, W and X references (Excel 365).
- Nested functions.
- Date calculations.
- Monitor formulas and cell contents.
- Use special filters.
- Use Excel as a database.
- Combine and consolidate data.
- Introduction to data analysis with pivot tables.
- Create and customize pivot tables.
- Use of data slices.
- Calculations with cell ranges (matrices).
- Create different types of diagrams.
- Work professionally with diagrams.
- Use dynamic diagrams.
- Import or export data.
Linking worksheets and files.
Tips and tricks.
Tips and tricks for using Microsoft Copilot.
Learning environment
Your benefit
- You can work confidently with formulas and functions.
- You can create, edit and link large tables sensibly and efficiently.
- You can use pivot tables and pivot charts sensibly and efficiently.
- You can quickly visualize data with suitable chart types.
- You can make good use of S, W and X references.
Methods
experts, practical tasks and exercises.
Please bring your own notebook with the corresponding Microsoft Office program for Windows (version 2016/2019/2021/O365) installed.
experts, practical tasks and exercises.
Please use a notebook with the Microsoft Office program for Windows (version 2016/2019/2021/O365) installed.
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/2021/O365 or the corresponding Microsoft Office versions for Windows.
Further recommendations for "Microsoft Excel: Advanced Course"
Microsoft 365: Using Teams & other tools efficiently in everyday life
Microsoft Excel: Basics course
Microsoft Excel: Using pivot tables and filters professionally
Microsoft Excel: Working with large tables
Microsoft Excel: Work and present successfully with dashboards
Attendees comments
"Very varied training that wasn't dry at all! I particularly liked working on the sample tasks, which were very close to practice."

"Great structural design. I got to know many practical shortcuts and also learned a lot about using pivot tables."

"Very well structured event! All the participants' questions were answered. I was able to apply what I learned directly to my everyday work!"

"I particularly liked the trainer's individual approach to the participants' questions."

"I can recommend the training as it is a great course with a dedicated trainer."

"I can recommend the training because of the competent, friendly trainer, the good learning materials and the good group size."

"I particularly liked the many tips and tricks."

"I particularly liked the way the lecturer conveyed the knowledge. He has a calm, slow, clear and easy-to-understand way of conveying content."

Seminar evaluation for "Microsoft Excel: Advanced Course"







30143
Start dates and details
Monday, 02.06.2025
09:30 am - 5:30 pm
Tuesday, 03.06.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 05.06.2025
09:00 am - 5:00 pm
Friday, 06.06.2025
08:30 am - 4:30 pm

Monday, 16.06.2025
09:00 am - 5:00 pm
Tuesday, 17.06.2025
08:30 am - 4:30 pm
Wednesday, 25.06.2025
09:30 am - 5:30 pm
Thursday, 26.06.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 26.06.2025
09:00 am - 5:00 pm
Friday, 27.06.2025
08:30 am - 4:30 pm
Monday, 07.07.2025
09:30 am - 5:30 pm
Tuesday, 08.07.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Monday, 07.07.2025
09:00 am - 5:00 pm
Tuesday, 08.07.2025
08:30 am - 4:30 pm
Thursday, 10.07.2025
09:30 am - 5:30 pm
Friday, 11.07.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 17.07.2025
09:00 am - 5:00 pm
Friday, 18.07.2025
08:30 am - 4:30 pm

Monday, 28.07.2025
09:00 am - 5:00 pm
Tuesday, 29.07.2025
08:30 am - 4:30 pm

Thursday, 07.08.2025
09:00 am - 5:00 pm
Friday, 08.08.2025
08:30 am - 4:30 pm

Monday, 18.08.2025
09:00 am - 5:00 pm
Tuesday, 19.08.2025
08:30 am - 4:30 pm
Monday, 25.08.2025
09:30 am - 5:30 pm
Tuesday, 26.08.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 28.08.2025
09:00 am - 5:00 pm
Friday, 29.08.2025
08:30 am - 4:30 pm

Thursday, 04.09.2025
09:00 am - 5:00 pm
Friday, 05.09.2025
08:30 am - 4:30 pm
Thursday, 11.09.2025
09:30 am - 5:30 pm
Friday, 12.09.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 18.09.2025
09:00 am - 5:00 pm
Friday, 19.09.2025
08:30 am - 4:30 pm

Monday, 29.09.2025
09:00 am - 5:00 pm
Tuesday, 30.09.2025
08:30 am - 4:30 pm
Wednesday, 01.10.2025
09:30 am - 5:30 pm
Thursday, 02.10.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Wednesday, 01.10.2025
09:00 am - 5:00 pm
Thursday, 02.10.2025
08:30 am - 4:30 pm

Monday, 06.10.2025
09:00 am - 5:00 pm
Tuesday, 07.10.2025
08:30 am - 4:30 pm

Monday, 13.10.2025
09:00 am - 5:00 pm
Tuesday, 14.10.2025
08:30 am - 4:30 pm

Monday, 20.10.2025
09:00 am - 5:00 pm
Tuesday, 21.10.2025
08:30 am - 4:30 pm
Thursday, 23.10.2025
09:30 am - 5:30 pm
Friday, 24.10.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 23.10.2025
09:00 am - 5:00 pm
Friday, 24.10.2025
08:30 am - 4:30 pm

Monday, 27.10.2025
09:00 am - 5:00 pm
Tuesday, 28.10.2025
08:30 am - 4:30 pm

Wednesday, 05.11.2025
09:00 am - 5:00 pm
Thursday, 06.11.2025
08:30 am - 4:30 pm

Thursday, 06.11.2025
09:00 am - 5:00 pm
Friday, 07.11.2025
08:30 am - 4:30 pm
Monday, 10.11.2025
09:30 am - 5:30 pm
Tuesday, 11.11.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Wednesday, 12.11.2025
09:00 am - 5:00 pm
Thursday, 13.11.2025
08:30 am - 4:30 pm
Monday, 17.11.2025
09:30 am - 5:30 pm
Tuesday, 18.11.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 20.11.2025
09:00 am - 5:00 pm
Friday, 21.11.2025
08:30 am - 4:30 pm

Monday, 24.11.2025
09:00 am - 5:00 pm
Tuesday, 25.11.2025
08:30 am - 4:30 pm

Thursday, 27.11.2025
09:00 am - 5:00 pm
Friday, 28.11.2025
08:30 am - 4:30 pm

Monday, 01.12.2025
09:00 am - 5:00 pm
Tuesday, 02.12.2025
08:30 am - 4:30 pm
Thursday, 04.12.2025
09:30 am - 5:30 pm
Friday, 05.12.2025
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 04.12.2025
09:00 am - 5:00 pm
Friday, 05.12.2025
08:30 am - 4:30 pm

Monday, 08.12.2025
09:00 am - 5:00 pm
Tuesday, 09.12.2025
08:30 am - 4:30 pm

Thursday, 11.12.2025
09:00 am - 5:00 pm
Friday, 12.12.2025
08:30 am - 4:30 pm

Monday, 15.12.2025
09:00 am - 5:00 pm
Tuesday, 16.12.2025
08:30 am - 4:30 pm

Thursday, 15.01.2026
09:00 am - 5:00 pm
Friday, 16.01.2026
08:30 am - 4:30 pm

Monday, 26.01.2026
09:00 am - 5:00 pm
Tuesday, 27.01.2026
08:30 am - 4:30 pm
Monday, 02.02.2026
09:30 am - 5:30 pm
Tuesday, 03.02.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Monday, 09.02.2026
09:00 am - 5:00 pm
Tuesday, 10.02.2026
08:30 am - 4:30 pm

Monday, 23.02.2026
09:00 am - 5:00 pm
Tuesday, 24.02.2026
08:30 am - 4:30 pm
Thursday, 05.03.2026
09:30 am - 5:30 pm
Friday, 06.03.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 12.03.2026
09:00 am - 5:00 pm
Friday, 13.03.2026
08:30 am - 4:30 pm

Thursday, 26.03.2026
09:00 am - 5:00 pm
Friday, 27.03.2026
08:30 am - 4:30 pm

Thursday, 09.04.2026
09:00 am - 5:00 pm
Friday, 10.04.2026
08:30 am - 4:30 pm
Monday, 13.04.2026
09:30 am - 5:30 pm
Tuesday, 14.04.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Tuesday, 14.04.2026
09:00 am - 5:00 pm
Wednesday, 15.04.2026
08:30 am - 4:30 pm
Monday, 20.04.2026
09:30 am - 5:30 pm
Tuesday, 21.04.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Monday, 20.04.2026
09:00 am - 5:00 pm
Tuesday, 21.04.2026
08:30 am - 4:30 pm

Monday, 27.04.2026
09:00 am - 5:00 pm
Tuesday, 28.04.2026
08:30 am - 4:30 pm

Thursday, 07.05.2026
09:00 am - 5:00 pm
Friday, 08.05.2026
08:30 am - 4:30 pm

Monday, 11.05.2026
09:00 am - 5:00 pm
Tuesday, 12.05.2026
08:30 am - 4:30 pm

Monday, 18.05.2026
09:00 am - 5:00 pm
Tuesday, 19.05.2026
08:30 am - 4:30 pm
Wednesday, 20.05.2026
09:30 am - 5:30 pm
Thursday, 21.05.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Monday, 08.06.2026
09:00 am - 5:00 pm
Tuesday, 09.06.2026
08:30 am - 4:30 pm
Wednesday, 17.06.2026
09:30 am - 5:30 pm
Thursday, 18.06.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Wednesday, 17.06.2026
09:00 am - 5:00 pm
Thursday, 18.06.2026
08:30 am - 4:30 pm

Thursday, 25.06.2026
09:00 am - 5:00 pm
Friday, 26.06.2026
08:30 am - 4:30 pm
Monday, 06.07.2026
09:30 am - 5:30 pm
Tuesday, 07.07.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Monday, 06.07.2026
09:00 am - 5:00 pm
Tuesday, 07.07.2026
08:30 am - 4:30 pm

Tuesday, 14.07.2026
09:00 am - 5:00 pm
Wednesday, 15.07.2026
08:30 am - 4:30 pm

Thursday, 23.07.2026
09:00 am - 5:00 pm
Friday, 24.07.2026
08:30 am - 4:30 pm

Wednesday, 05.08.2026
09:00 am - 5:00 pm
Thursday, 06.08.2026
08:30 am - 4:30 pm

Tuesday, 11.08.2026
09:00 am - 5:00 pm
Wednesday, 12.08.2026
08:30 am - 4:30 pm
Wednesday, 12.08.2026
09:30 am - 5:30 pm
Thursday, 13.08.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 20.08.2026
09:00 am - 5:00 pm
Friday, 21.08.2026
08:30 am - 4:30 pm

Wednesday, 02.09.2026
09:00 am - 5:00 pm
Thursday, 03.09.2026
08:30 am - 4:30 pm

Monday, 07.09.2026
09:00 am - 5:00 pm
Tuesday, 08.09.2026
08:30 am - 4:30 pm
Thursday, 10.09.2026
09:30 am - 5:30 pm
Friday, 11.09.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Monday, 14.09.2026
09:30 am - 5:30 pm
Tuesday, 15.09.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 17.09.2026
09:00 am - 5:00 pm
Friday, 18.09.2026
08:30 am - 4:30 pm

Monday, 28.09.2026
09:00 am - 5:00 pm
Tuesday, 29.09.2026
08:30 am - 4:30 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.