Microsoft Excel: Advanced course
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.
To get the most out of the training, we recommend working with two screens and a camera.
Recommended for
Anyone who works with Microsoft Excel 2016/2019/2021/O365 or the corresponding Microsoft Office versions for Windows.
30143
- Customized training courses
- Direct application in practice
- Efficient use of time and resources
Further recommendations for "Microsoft Excel: Advanced Course"
You might also be interested in:
Start dates and details

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.

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.

Thursday, 25.06.2026
09:30 am - 5:30 pm
Friday, 26.06.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: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.

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, 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.

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

Monday, 12.10.2026
09:30 am - 5:30 pm
Tuesday, 13.10.2026
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 26.10.2026
09:30 am - 5:30 pm
Tuesday, 27.10.2026
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Tuesday, 03.11.2026
09:30 am - 5:30 pm
Wednesday, 04.11.2026
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Thursday, 12.11.2026
09:30 am - 5:30 pm
Friday, 13.11.2026
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 23.11.2026
09:30 am - 5:30 pm
Tuesday, 24.11.2026
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Thursday, 03.12.2026
09:30 am - 5:30 pm
Friday, 04.12.2026
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 14.12.2026
09:30 am - 5:30 pm
Tuesday, 15.12.2026
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Thursday, 28.01.2027
09:30 am - 5:30 pm
Friday, 29.01.2027
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Tuesday, 02.03.2027
09:30 am - 5:30 pm
Wednesday, 03.03.2027
08:30 am - 4:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
