PRINCE2®: Foundation & Practitioner in Project Management with Excel for Advanced Learners

The course provides in-depth PRINCE2® knowledge and prepares participants specifically for the Foundation and Practitioner exams. The scalable IT project management method provides practice-oriented recommendations for every project phase. The course also covers the basics of artificial intelligence and advanced spreadsheet topics using Excel.
  • Certificates: Certificate "PRINCE2® 7 Foundation in Project Management"
    Certificate "PRINCE2® 7 Practitioner in Project Management"
    Certificate "Microsoft Excel for advanced users"
  • Examination: Practical project work with final presentations
    PRINCE2® 7 Foundation in Project Management
    PRINCE2® 7 Practitioner in Project Management
  • Teaching Times: Full-time
    Monday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
  • Language of Instruction: German
  • Duration: 6 Weeks

PRINCE2® 7 Foundation in Project Management

Introduction to project management based on PRINCE2® (approx. 1 day)

Definition and characteristics of a project

Project control cycle of project management and the six project dimensions

Challenges in project management - why do projects fail?

Advantages of the PRINCE2® project management method

Customer-supplier environments

Projects in a commercial environment

Structure of the PRINCE2® method and its five integrated building blocks


The PRINCE2® basic principles (approx. 1 day)

The seven basic principles of PRINCE2®

Statements and contents of the basic principles

Relationship between the basic principles and the PRINCE2® topics

Adaptation of PRINCE2® to the project environment


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


The importance of people for PRINCE2® projects (approx. 1 day)

Change management

Leadership and management

Communication in the project


The seven topics of PRINCE2® (approx. 3 days)

Business case (benefits management approach and sustainability management approach)

Organization (project structure, roles and responsibilities)

Creation of plans

Quality planning and quality control

Risk management

Issue management

Controlling the progress of the project


The seven PRINCE2® processes (approx. 2 days)

Interaction of the seven PRINCE2® processes in the project process

Activities in the respective PRINCE2® processes

Preparing, steering and initiating a project

Controlling a phase

Managing product delivery

Managing phase transitions

Closing a project


Project work, certification preparation and certification exam (approx. 2 days)

PRINCE2® is a registered trademark of AXELOS Limited, used with the permission of AXELOS Limited. All rights reserved.

PRINCE2® 7 Practitioner in Project Management

Introduction (approx. 1 day)

Overview of the PRINCE2® methodology and the Practitioner exam

Differences to the Foundation exam


Applying personnel management in projects (approx. 1 day)

Leadership approaches

Communication management approach

Change management approach


PRINCE2® principles (approx. 1 day)

Business justification

Learning from experience

Roles, responsibilities and relationships

Step-by-step management

Management by exception

Product focus

Customized solution


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


PRINCE2® practices (approx. 2.5 days)

Business scenario

organization

Plans

quality

risks

Problems

Progress


PRINCE2® Processes (approx. 1.5 days)

Starting a project

Steering a project

Initiating a project

Controlling a phase

Managing product delivery

Managing a phase transition

Closing a project


Application of PRINCE2® in practice (approx. 1.5 days)

Adapting PRINCE2® to different projects

Dealing with deviations and risk management

Practical application of topics, principles and processes


Project work, certification preparation and certification exam (approx. 1.5 days)

PRINCE2® is a registered trademark of AXELOS Limited, used with the permission of AXELOS Limited. All rights reserved.

Microsoft Excel for advanced users

Spreadsheet calculation with Excel (approx. 8 days)

Using Excel as a database: Selecting (auto and special filters), sorting, evaluating lists (tables)

Using functions, performing calculations with functions, getting to know references

Matrix functions: SREFERENCE, WREFERENCE, XREFERENCE

Working with names or named ranges

Creating, editing and evaluating pivot tables

Special functionalities such as conditional formats, validity rules, user-defined formats

Calculations with cell ranges (matrices)

Creating different chart types

Macro recording


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Project work (approx. 2 days)

To consolidate the content learned

Presentation of the project results



Changes are possible. The course content is updated regularly.

Basic knowledge of Microsoft Excel is required for this course.

You will gain a comprehensive understanding of the PRINCE2 methodology and learn all the important principles, topics and processes that you need to apply PRINCE2 in real projects. Through practical examples and a structured approach, you will learn how to apply PRINCE2 flexibly to different project situations.

You also understand the concept of spreadsheets and can use Excel quickly and confidently. You can work confidently with formulas and functions and create, edit and evaluate large tables. You will also be able to use pivot tables and make good use of references.

The course is aimed at project managers, team leaders, project participants and consultants who already have knowledge of project management and would like to expand their skills. The course is particularly suitable for people who have already acquired the PRINCE2 Foundation certification and would now like to deepen their skills in order to take the PRINCE2 Practitioner exam.

PRINCE2 is a globally recognized project management method and as more and more companies rely on standardized methods, PRINCE2-certified specialists are in high demand. This is particularly true in industries where structured project methods are important, such as IT, construction, finance, consulting and public administration.

Your PRINCE2 7 Foundation and PRINCE2 7 Practitioner certificates prove that you can apply the methodology practically and responsibly in complex projects.

With in-depth knowledge of Microsoft Excel, you will also expand your professional expertise, which will further increase your chances on the job market.

Didactic concept

Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).

You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.

 

Virtual classroom alfaview®

Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face lessons via video technology.

 

The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).

We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm
free of charge from all German networks.
Contact
We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm free of charge from all German networks.