Contents
- Organize tables.
- Link formatting to conditions.
- Monitor formulas and cell contents.
- Working with areas.
- Create different types of diagrams.
- Work professionally with diagrams.
- Use reference functions skillfully.
- Calculations in cell areas (matrices).
- Create and customize pivot tables.
- New powerful functions in Excel 365.
- Create dynamic matrix formulas
- Analyze data.
- Import or export data.
- Queries from multiple data sources.
- Getting started with Power Query and Power Pivot.
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 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.
- You will get a first introduction to Power Query and Power Pivot.
Methods
experts, practical tasks and exercises.
Please use a notebook with Excel 365 installed.
Online training: In order to participate well, we recommend that you work with two screens.
Recommended for
Everyone who works with Microsoft Excel 365 (Windows).
Further recommendations for "Microsoft Excel 365: Advanced Course"
Attendees comments
"I particularly liked the super clear explanations and the time the trainer took for the individual cases."

"I particularly liked the trainer's expertise, the practical relevance and the simple explanations. I took away a lot for practical application."

Seminar evaluation for "Microsoft Excel 365: Advanced course"







Start dates and details

Monday, 11.08.2025
09:00 am - 5:00 pm
Tuesday, 12.08.2025
08:30 am - 4:30 pm

Monday, 01.09.2025
09:00 am - 5:00 pm
Tuesday, 02.09.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, 10.11.2025
09:00 am - 5:00 pm
Tuesday, 11.11.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, 12.02.2026
09:00 am - 5:00 pm
Friday, 13.02.2026
08:30 am - 4:30 pm

Monday, 16.03.2026
09:00 am - 5:00 pm
Tuesday, 17.03.2026
08:30 am - 4:30 pm