Contents
Excel lists
- Comfortable and efficient management.
- Perfect design.
- Calculate automatically.
- Reader-friendly printing.
- Summarize and structure large amounts of data.
- Insert filter.
Create meaningful and attractive evaluations
- Detect errors and check formulas.
- The most important formulas and functions, e.g. IF, SEQUENCE, SUMIF.
- Automatically mark and monitor data with traffic lights and symbols.
- Practical examples for optimal forecasts and reports.
Quick analysis and pivot tables
- Automatic subtotals and partial results.
- Evaluate and summarize lists with pivot tables.
- Create statistics quickly and professionally with pivot tables.
- Interactively display various evaluation scenarios via data section.
Graphical representation of data
- Create diagrams.
- Clear and interactive presentation with pivot tables.
Excel shortcuts and tips for daily work
Please bring a Windows laptop with Microsoft Office 2010 or higher installed to the training .
Learning environment
In your online learning environment, you will find useful information, downloads and extra services for this qualification measure after you have registered.
Your benefit
In this training , you will learn about the most important features and Excel tools for mastering extensive tables. You will receive tips on how to set up tables correctly, avoid errors and correct existing errors. Step by step, you will work your way through the most frequently used tools, from sorting and filtering to pivot tables. Using practical examples, you will practise using important Excel functions and learn how to set up formulas efficiently. You will gain an insight into the evaluation and representative presentation of data with pivot tables and charts.
- You will learn how to recognize and avoid typical mistakes when setting up tables.
- You will learn how to sort, filter and organize using simple tools.
- You will learn the most important functions such as IF and SEQUENCE.
- You will receive specific tools for analyzing large tables with pivot tables.
- You can not only analyze your data, but also present it in an appealing way with diagrams.
Methods
Trainer input, exercises, partner exercises, discussion, exchange of experience, work aids, checklists.
Notes on the face-to-face event:
Please bring a Windows laptop with Microsoft Office 2010 or higher installed to the training .
Notes on the online event:
You will need a laptop/computer and a stable internet connection.
It would also be very helpful to use two screens or two devices to recreate the face-to-face seminar environment: One screen or tablet would show the video image of the trainer analogous to the screen in the face-to-face seminar and on the other screen/laptop you can use your computer to implement or practice what has been shown. If necessary, a single large screen would also help to split 2 programs on the right and left half of a screen.
Recommended for
Assistants, office managers and all Employees who work with extensive Excel spreadsheets and want to professionalize their use of Excel. Basic knowledge of Excel is a prerequisite.
Further recommendations for "Excel tools for the assistant"
Attendees comments
"It was technically very good, very practice-oriented and questions were answered individually. Nice round!"

"The number of participants was very good, so there was time for questions and examples from day-to-day business. The interaction with each other was great, we learned from each other."

Seminar evaluation for "Excel tools for the assistant"







2459
Start dates and details

Thursday, 21.08.2025
09:00 am - 5:00 pm
Friday, 22.08.2025
09:00 am - 5:00 pm
Thursday, 25.09.2025
09:00 am - 5:00 pm
Friday, 26.09.2025
09:00 am - 5:00 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Monday, 17.11.2025
09:00 am - 5:00 pm
Tuesday, 18.11.2025
09:00 am - 5:00 pm
Monday, 26.01.2026
09:00 am - 5:00 pm
Tuesday, 27.01.2026
09:00 am - 5:00 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Monday, 09.03.2026
09:00 am - 5:00 pm
Tuesday, 10.03.2026
09:00 am - 5:00 pm

Monday, 01.06.2026
09:00 am - 5:00 pm
Tuesday, 02.06.2026
09:00 am - 5:00 pm
Tuesday, 14.07.2026
09:00 am - 5:00 pm
Wednesday, 15.07.2026
09:00 am - 5:00 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.

Thursday, 03.09.2026
09:00 am - 5:00 pm
Friday, 04.09.2026
09:00 am - 5:00 pm
The participation fee includes
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.