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 from an experienced expert.
Information on the use of 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
Expert input, practical tasks and exercises.
Please bring a notebook with the corresponding Microsoft Office program for Windows (version 2016/2019/2021/O365) installed.
Expert input, 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 take part 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"
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."

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

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

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

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

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

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

"I particularly liked the many tips and tricks."

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

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

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

"In this training you will find the instructions to make your work easier. Questions were always answered."

"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, 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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Monday, 14.09.2026
09:30 am - 5:30 pm
Tuesday, 15.09.2026
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.