PMP Formulas

This course is part of Microsoft Project Management Professional Certificate

Instructor: Microsoft

Sponsored by Abu Dhabi National Oil Company

4 modules

Gain insight into a topic and learn the fundamentals.

5.0

(15 reviews)

Beginner level

Recommended experience

16 hours to complete

3 weeks at 5 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

5.0

(15 reviews)

Beginner level

Recommended experience

16 hours to complete

3 weeks at 5 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Gain insight into the process of Earned Value Management for accurate project performance evaluation.
Learn to implement PMP formulas to monitor progress and optimize resource utilization in diverse project environments.
Learn to assess project Return on Investment (ROI) for prioritizing investments and maximizing organizational value.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

25 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your Business Strategy expertise

This course is part of the Microsoft Project Management Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

In this course, you'll learn about Earned Value Management, discover how to gauge project performance accurately, and use this information to make strategic decisions for project success. You'll also learn how to implement PMP formulas, equipping you with the tools to monitor progress and optimize resource utilization across diverse project environments. Additionally, you'll learn to assess project financial Return on Investment (ROI), honing your ability to evaluate project feasibility and prioritize investments to maximize organizational value.

This course aligns with the Microsoft Office Specialist: Associate (Microsoft 365 Apps): MO-210 exam, enhancing your spreadsheet skills. You'll focus on managing worksheets and workbooks, managing data cells and ranges, managing tables and table data, and using formulas and functions. After completing this course, you'll be able to: • Describe the process of Earned Value Management. • Implement the PMP formulas project environments. • Assess if a project has a sound financial Return on Investment. This course is ideal for preparing for the PMI® Authorized PMP® Exam and starting your journey towards mastering the Microsoft Office Specialist: Associate (Microsoft 365 Apps): MO-210 exam.

This module provides a comprehensive overview of Earned Value Management (EVM) and cost management, including EVM Variance Analysis and forecasting. You'll learn about essential PMP formulas and how to apply them to evaluate project performance and manage costs throughout the project lifecycle. From understanding formula concepts to hands-on calculations, you will gain the expertise to utilize PMP formulas effectively.

What's included

9 videos9 readings7 assignments1 discussion prompt

9 videosTotal 47 minutes

Introduction to the Course: PMP Formulas5 minutesPreview module
EVM and Cost Management Overview5 minutes
Planned Value (PV), Earned Value (EV), and Actual Cost (AC)5 minutes
Variance Analysis and Performance Indicators5 minutes
EVM Forecasting Overview5 minutes
Estimate at Completion (EAC)5 minutes
Estimate to Complete (ETC)5 minutes
To-Complete Performance Index (TCPI)5 minutes
Module Summary: PMP Formulas4 minutes

9 readingsTotal 85 minutes

Course Syllabus: PMP Formulas10 minutes
How to be successful in this course10 minutes
EVM and Cost Management Formulas10 minutes
Exploring Variance Analysis with Examples10 minutes
EVM Forecasting Formulas10 minutes
Exploring EAC and ETC Forecasting with Examples10 minutes
TCPI Formulas10 minutes
PMP Formulas Cheat Sheet10 minutes
Additional Resources: PMP Formulas5 minutes

7 assignmentsTotal 105 minutes

Module Quiz: PMP Formulas30 minutes
Activity: EVM and Cost Management Formulas10 minutes
Knowledge Check: EVM and Cost Management Formulas15 minutes
Activity: Forecasting Formulas10 minutes
Knowledge Check: Forecasting Formulas15 minutes
Activity: EVM Assessing Performance10 minutes
Knowledge Check: EVM Assessing Performance15 minutes

1 discussion promptTotal 10 minutes

Discussion Prompt: What do you hope to learn?10 minutes

In this module, you will explore and apply key schedule management formulas within the context of project management, enabling you to effectively plan, monitor, and control project schedules. This session covers the Critical Path Method (CPM), Schedule Variance (SV), Schedule Performance Index (SPI), and other relevant formulas for comprehensive schedule and estimation management.

What's included

16 videos6 readings8 assignments

16 videosTotal 91 minutes

Introduction to Schedule Management Formulas4 minutesPreview module
Critical Path Analysis Overview7 minutes
Excel based Simulation: Forward and Backward Pass6 minutes
Float & Slack6 minutes
Excel based Simulation: Float & Slack5 minutes
Introduction to Estimation 4 minutes
PERT Estimating 5 minutes
PERT Concepts4 minutes
Excel based Simulation: PERT Distribution6 minutes
Triangular Distribution6 minutes
Excel Based Simulation4 minutes
Introduction to Contingency Reserves5 minutes
Management Reserves6 minutes
Risk Analysis vs Estimation of Cost and Schedule5 minutes
Risk Planning vs Estimation of Cost and Schedule5 minutes
Module Summary: Scheduling and estimating5 minutes

6 readingsTotal 55 minutes

Schedule Development Tools and Techniques10 minutes
PMP Schedule Management Formulas cheat sheet10 minutes
PMP Estimation Formula Cheat Sheet10 minutes
Contingency Reserves10 minutes
Monitoring and Adjusting Reserves10 minutes
Additional Resources: Project risk and reserve management5 minutes

8 assignmentsTotal 115 minutes

Module Quiz: Scheduling and estimating30 minutes
Activity: Critical Path Analysis10 minutes
Knowledge Check: Critical Path Analysis15 minutes
Activity: PERT Estimating10 minutes
Activity: Triangular Distribution10 minutes
Knowledge Check: Estimating Techniques15 minutes
Activity: Reserve Management10 minutes
Knowledge Check: Project risk and reserve management15 minutes

In this module, you will apply key Investment Analysis & Procurement Management formulas, equipping you with the skills to appraise project investment opportunities. You’ll also explore essential concepts, techniques, and strategies for assessing project investment and procurement.

What's included

18 videos7 readings8 assignments

18 videosTotal 90 minutes

Introduction to Investment Forecasting and Analysis7 minutesPreview module
Net Present Value (NPV) Overview5 minutes
Net Present Value (NPV) Excel example4 minutes
Future Value (FV) Overview5 minutes
Future Value (FV) Excel example2 minutes
Internal Rate of Return (IRR) Overview7 minutes
Internal Rate of Return (IRR) Excel example1 minute
Introduction to Project Selection4 minutes
Benefit-cost ratio (BCR) Overview4 minutes
Benefit-cost ratio (BCR) Excel example3 minutes
Discounted Cash Flow Overview5 minutes
Discounted Cash Flow (DCF) Excel example5 minutes
Payback Period Overview4 minutes
Payback Period Excel example5 minutes
Overview of Investment Analysis5 minutes
Expected Monetary Value (EMV) Overview6 minutes
Expected Monetary Value (EMV) Excel example3 minutes
Module Summary: Investment Analysis & Procurement6 minutes

7 readingsTotal 65 minutes

PMP Investment Forecasting Formula Cheat Sheet10 minutes
PMP IRR Formula Cheat Sheet10 minutes
PMP Project Selection Formula Cheat Sheet10 minutes
PMP Discounted Cash Flow Formula Cheat Sheet10 minutes
PMP Investment Analysis Formula Cheat Sheet10 minutes
PMP Expected Monetary Value Formula Cheat Sheet10 minutes
Additional Resources: Investment Analysis & Procurement5 minutes

8 assignmentsTotal 115 minutes

Module Quiz: Investment Analysis & Procurement30 minutes
Activity: Net Present Value (NPV)10 minutes
Activity: Future Value (FV)10 minutes
Knowledge Check: Internal Rate of Return (IRR)15 minutes
Activity: Benefit-cost ratio (BCR) calculation10 minutes
Activity: Discounted cash flow10 minutes
Knowledge Check: Project Payback Period15 minutes
Knowledge Check: Investment Analysis15 minutes

In this module, you’ll put your skills into practice. You’ll reflect on the key learning points that you reviewed during the course and complete the final assessment and hands-on activity.