Contents
Key personnel figures
- Key figures as a control and management tool.
- What key figures are there? Objectives, selection, benefits.
- Definition and creation of key personnel figures.
Excel as a controlling platform
- Development of a controlling platform.
- Excel functions for the personnel area.
- Areas of application and further Excel tips.
- Import data from external data sources (databases, SAP, Dynamics, SAP) and prepare it for key figures.
- Use BI tools in a targeted manner (Power Query, Power Pivot).
- Visualize key figures in dashboards.
- Practical examples/exercises.
Theory is good, practice is better
- Practical application: Implementation of basic personnel controlling with Excel.
- Pivot tables, pivot charts, tables and dynamic areas.
- Processing of specific tasks and questions from your company.
Learning environment
Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.
Your benefit
- You will expand your understanding of the objectives and tasks of personnel controlling.
- You will learn which key figures are necessary to put personnel controlling on a solid technical and Excel basis.
- You receive security for evaluations and statistics to be created at short notice.
- The relevant Excel functions are first explained to you. You will then practise these yourself on your PC.
- You can bring in specific tasks from your company to discuss them and develop solutions.
- You increase your own work efficiency.
This training is predominantly practice-oriented and builds on the theoretical foundations of personnel controlling. We recommend that you attend the training "Personnel Controlling Compact" (Webinfo No. 8773) beforehand.
Please note that the content of the seminar is based on the current MS Office package and is only designed for Windows users (not for macOS users).
After registering, you will find a how-to video in your learning environment explaining the relevant PC and Excel settings for the training . Please set up your PC accordingly before the seminar starts.
Methods
Basic exercises with lists and tables.
Development of key figure models based on extensive exercise data.
Step-by-step instructions in the seminar document for checking.
Practical tips and tricks.
Concrete solutions and implementation aids.
Recommended for
Specialists and managers from the HR department, HR controlling and payroll accounting. Basic knowledge of Excel is a prerequisite for participation.
Further recommendations for "Personnel controlling with Excel"
Attendees comments
"Very good documents, good organization."

Seminar evaluation for "Personnel controlling with Excel"







35479
Start dates and details
Friday, 06.06.2025
09:00 am - 5:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 21.07.2025
09:00 am - 5:00 pm

Friday, 12.09.2025
09:00 am - 5:00 pm

Thursday, 04.12.2025
09:00 am - 5:00 pm

Friday, 13.03.2026
09:00 am - 5:00 pm

Wednesday, 20.05.2026
09:00 am - 5:00 pm

Thursday, 03.09.2026
09:00 am - 5:00 pm
Thursday, 17.09.2026
09:00 am - 5:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.