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"
30143
Start dates and details
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.

Monday, 06.10.2025
09:00 am - 5:00 pm
Tuesday, 07.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.