Software training

Microsoft Excel 365: Advanced course

Including new functions and possibilities of Excel 365

This software training course is held in German.
Working with MS Office 365: How to create large Excel spreadsheets, evaluate them quickly and present the results clearly is what this training is all about. Excel 365 offers new functions and possibilities, especially for analyzing data from lists. This training covers the content and techniques you need for working with multiple tables, large amounts of data and pivot tables. Among other things, you will training how to use pivot tables and pivot charts sensibly and efficiently. You will also receive many practical tips and tricks for practical use.

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

Open Badges - Show what you can do digitally too.

Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

Read more

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

Vanessa Fuchs
Fashion Digital GmbH & Co KG

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

Jonny Köcher
August Storck KG

Seminar evaluation for "Microsoft Excel 365: Advanced course"

4.6 from 5
with 60 ratings
training content:
4.6
Content comprehensibility:
4.7
Practical relevance:
4.1
Trainer expertise:
4.9
Participant orientation:
4.8
Method variety:
4.5
Joint online training
Booking number
35476
€ 980,- plus VAT
2 days
Online
7 Events
German
Events
Train several employees internally
Pricing upon request
  • Customized training courses according to your needs
  • Directly at your premises or online
  • Cost advantage from 5 participants
  • We contact you within 24 hours (Mon-Fri)
2 days
In-person or Online

Start dates and details

  Select time period
0 events
11.08.2025
Live-Online
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 11.08.2025

09:00 am - 5:00 pm

Tuesday, 12.08.2025

08:30 am - 4:30 pm

01.09.2025
Live-Online
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 01.09.2025

09:00 am - 5:00 pm

Tuesday, 02.09.2025

08:30 am - 4:30 pm

06.10.2025
Live-Online
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 06.10.2025

09:00 am - 5:00 pm

Tuesday, 07.10.2025

08:30 am - 4:30 pm

10.11.2025
Live-Online
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 10.11.2025

09:00 am - 5:00 pm

Tuesday, 11.11.2025

08:30 am - 4:30 pm

15.12.2025
Live-Online
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 15.12.2025

09:00 am - 5:00 pm

Tuesday, 16.12.2025

08:30 am - 4:30 pm

12.02.2026
Live-Online
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Thursday, 12.02.2026

09:00 am - 5:00 pm

Friday, 13.02.2026

08:30 am - 4:30 pm

16.03.2026
Live-Online
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 16.03.2026

09:00 am - 5:00 pm

Tuesday, 17.03.2026

08:30 am - 4:30 pm

Sufficient places are still free.
Don't wait too long to book.
Fully booked.
Training is guaranteed to take place
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Details
2 days
Limited number of participants
Booking number: 35476
€ 980,- plus VAT.
€ 1,166.20 incl. VAT.
Details
2 days
Limited number of participants
Book later
You are welcome to make a non-binding advance reservation.
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
Also bookable as in-house training
demand-oriented adaptations possible
on-site or live online for multiple employees
save time and traveling expenses
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

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

2,500+ further training
600,000+ apprentices per year
Over 95% positive reviews
2,500 trainers and coaches
17,500+ training courses held per year
Call us or send an email

Do you have any questions?

We are there for you Monday to Friday 8:00 a.m. - 5:00 p.m.

Stephanie Göpfert

Head of Customer Service

*Mandatory fields
FAQs

Questions & Answers

In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.