The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration
Microsoft Excel 365: Advanced course
Including new functions and possibilities of Excel 365
Online
2 days
German
€ 990,-
plus VAT.
€ 1.178,10
incl. VAT.
Booking number
35476
Venue
Online
.svg)
8 dates
€ 990,-
plus VAT.
€ 1.178,10
incl. VAT.
Booking number
35476
Venue
Online
8 dates
plus VAT.
incl. VAT.
Booking number
Venue
0 Dates
Become a certified
Machine Learning Engineer
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training just for your employees - exclusive and effective.
Inquiries
In cooperation with
In cooperation with
Working with MS Office 365: Create large Excel spreadsheets, analyze them quickly and present the results clearly - that's what this training is all about. Excel 365 offers new functions and possibilities, especially when 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 training learn how to use pivot tables and pivot charts sensibly and efficiently. You will also receive lots of 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 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.
trainer
Goetz Sattler
Frans Parren
Steffen Bürk
Georg Dahmen
Dr.
Arno Burger
René Pukall
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.
Final examination
Recommended for
Everyone who works with Microsoft Excel 365 Windows.
.svg)