Contents
Basics
- Set-up main process project controlling.
- Graphical data model for Excel-supported project controlling.
- Generic process of Excel-based project controlling.
Controlling deadlines and resources
- Gross and net project durations.
- Schedule and resource deviations.
- Milestone trend analysis.
Control project progress
- Degrees of completion according to different methods: milestone, quantity, time and residual value estimation method.
- Monitor scope of services, change requests.
Controlling costs and margins
- Cost variances.
- Cost trend analysis.
- Margin and updated margin.
Controlling risks
- Risk register.
- Risk prioritization.
Report project status
- Holistic view with the earned value analysis.
- Transparent traffic light system.
- Approach to expanding individual project KPI systems.
- The project status as a one-pager.
- Status reports for different target groups.
- Project review.
Tips, tricks and checklists for practical use
Please bring your own laptop to the training . You can find more detailed installation instructions under Methods.
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
- Following the training , you will receive the project controlling tool based on MS Excel (from version 2010) for free use.
- You will learn how Excel-supported work can make your project controlling easier.
- You are able to customize and further develop the Excel template for your projects or your project environment.
- You will work on performance, deadline, cost and resource variances using practice cases in order to better understand and grasp correlations.
Methods
Presentation, practical examples, exercises and case study on the PC, checklists.
You will need your own laptop to participate.
Please observe the following installation instructions:
Microsoft Excel from version 2016 (at least Professional) or higher or Office 365. You also need Acrobat Reader.
Recommended for
controllers, project controllers, specialists and managers with project responsibility and managers who want to use Excel efficiently in project controlling.
Attendance conditions
Basic knowledge of MS Excel 2010 is required. Find out here which Excel skills are required for this training . The required basic knowledge is also taught in the"Excel for controllers" training .
Further recommendations for "Professional project controlling with Excel"
Attendees comments
"I particularly liked the variety between theory and practice."

"I can recommend the good quality and the smooth process. I liked the fact that our questions were answered in detail."

"The examples were well explained and I gained further knowledge in Excel."


Seminar evaluation for "Professional project controlling with Excel"







2539
Start dates and details

Friday, 29.08.2025
09:00 am - 5:30 pm

Wednesday, 15.10.2025
09:00 am - 5:30 pm
Monday, 15.12.2025
09:30 am - 5:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.

Monday, 02.03.2026
09:00 am - 5:30 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.