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
Important note:
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 training course once you have registered.
Your benefit
In this training , you will learn about the most important features and Excel tools for mastering large 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 experiences, 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 trainingtraining event:
You 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!"
"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."
"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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
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
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Thursday, 03.09.2026
09:00 am - 5:00 pm
Friday, 04.09.2026
09:00 am - 5:00 pm
Training is guaranteed to take place- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
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.
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
