Microsoft Excel 365: Advanced course
Including new functions and possibilities of Excel 365
4.6
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 will learn how to 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
Expert input, practical tasks, and exercises.
Please use a notebook with Excel 365 for Windows installed.
Online training: In order to participate well, we recommend working with two screens.
Recommended for
Everyone who works with Microsoft Excel 365 Windows.
Further recommendations for "Microsoft Excel 365: Advanced Course"
Further recommendations for "Microsoft Excel 365: Advanced Course"
Ratings and feedback from our participants
Start dates and details
Thursday, 07.05.2026
09:00 am - 5:00 pm
Friday, 08.05.2026
08:30 am - 4:30 pm
Monday, 22.06.2026
09:00 am - 5:00 pm
Tuesday, 23.06.2026
08:30 am - 4:30 pm
Monday, 20.07.2026
09:00 am - 5:00 pm
Tuesday, 21.07.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 next booking ensures this course will take placeAbout us - The Haufe Akademie
Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.
Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.
A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.
Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.
Do you have any questions?
We are there for you Monday to Friday 8:00 a.m. - 5:00 p.m.
Questions & Answers
In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.
Munzinger Str. 9
79111 Freiburg
- Planning security
- Free seminar places
- Quality standards
- Planning and locations
- Funding opportunities
- Training app
- Business Solutions
