training training

Professional project controlling with Excel

Practical knowledge with continuous case study

This training is held in German.
Microsoft Excel offers extensive functionalities for the implementation of efficient project controlling. With a professional application for projects that contains proven project management methods and key figures, you can make your project controlling more efficient and thus make an indispensable contribution to achieving all project goals. In this training , you will learn about the basic structure, individual customization options and the cyclical process of Excel-supported project controlling using a practical tool for small and medium-sized projects.

Contents

Direct implementation on your own laptop!

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 .

    Open Badges - Show what you can do digitally too.

    Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

    With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

    Read more

    Further recommendations for "Professional project controlling with Excel"

    Attendees comments

    "I particularly liked the variety between theory and practice."

    Swantje Heller
    DSI Aerospace GmbH

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

    Denny Meisel
    IKR GmbH

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

    Jose Gonzalez
    MOLDINO Tool Engineering
    "The competence of the lecturer is to be recommended. I particularly liked the explanations on the side and the fact that the course also took place online. I was able to work with several screens."
    Lars Misterek
    MENTOR GmbH & Co. KG

    Seminar evaluation for "Professional project controlling with Excel"

    4.3 from 5
    with 231 reviews
    training content:
    4.3
    Content comprehensibility:
    4.4
    Practical relevance:
    3.8
    Trainer expertise:
    4.6
    Participant orientation:
    4.6
    Method variety:
    4.2
    On-site training together
    Booking number
    2539
    € 790,- plus VAT
    1 day
    in Munich
    on 15.12.2025
    German
    In-person trainings
    Joint online training
    Booking number
    32303
    € 790,- plus VAT
    1 day
    Online
    3 Events
    German
    Live online events
    Train several employees internally
    Pricing upon request
    • Customized training courses according to your needs
    • Directly at your premises or online
    • Cost advantage from 5 participants
    • We contact you within 24 hours (Mon-Fri)
    1 day
    In-person or Online

    This training is available as part of course:

    Certified:r project controller

    Start dates and details

      Select time period
    0 events
    29.08.2025
    Live-Online
    Booking number: 32303
    € 790,- plus VAT.
    € 940.10 incl. VAT.
    Course
    zoom
    zoom
    Technical notes
    We use various software to conduct our online events.
    Days & Times
    1 day
    Limited number of participants

    Friday, 29.08.2025

    09:00 am - 5:30 pm

    15.10.2025
    Live-Online
    Booking number: 32303
    € 790,- plus VAT.
    € 940.10 incl. VAT.
    Course
    zoom
    zoom
    Technical notes
    We use various software to conduct our online events.
    Days & Times
    1 day
    Limited number of participants

    Wednesday, 15.10.2025

    09:00 am - 5:30 pm

    15.12.2025
    Munich
    Booking number: 2539
    € 790,- plus VAT.
    € 940.10 incl. VAT.
    Venue
    Hotel Excelsior by Geisel
    Hotel Excelsior by Geisel
    Schützenstr. 11, 80335 Munich
    Room rate: € 145,58 plus VAT.
    Arrival via Deutsche Bahn
    Train tickets to this event starting at € 51,90.
    Days & Times
    1 day
    Limited number of participants

    Monday, 15.12.2025

    09:30 am - 5:30 pm

    Fee includes
    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.
    02.03.2026
    Live-Online
    Booking number: 32303
    € 790,- plus VAT.
    € 940.10 incl. VAT.
    Course
    zoom
    zoom
    Technical notes
    We use various software to conduct our online events.
    Days & Times
    1 day
    Limited number of participants

    Monday, 02.03.2026

    09:00 am - 5:30 pm

    Sufficient places are still free.
    Don't wait too long to book.
    Fully booked.
    Training is guaranteed to take place
    The next booking ensures this course will take place
    Booking number: 2539
    € 790,- plus VAT.
    € 940.10 incl. VAT.
    Details
    1 day
    Limited number of participants
    Fee includes
    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.
    Booking number: 32303
    € 790,- plus VAT.
    € 940.10 incl. VAT.
    Details
    1 day
    Limited number of participants
    Book later
    You are welcome to make a non-binding advance reservation.
    No suitable date?
    You are welcome to be notified by e-mail as soon as new dates are released.
    Also bookable as in-house training
    demand-oriented adaptations possible
    on-site or live online for multiple employees
    save time and traveling expenses
    Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

    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.

    2,500+ further training
    600,000+ apprentices per year
    Over 95% positive reviews
    2,500 trainers and coaches
    17,500+ training courses held per year
    Call us or send an email

    Do you have any questions?

    We are there for you Mon - Fri 8 a.m. - 5:00 p.m.

    Stephanie Göpfert

    Head of Customer Service

    *Mandatory fields
    FAQs

    Questions & Answers

    In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.