PMP Formulas

This course is part of Microsoft Project Management: Build Job-Ready Skills Professional Certificate

Instructor: Microsoft

Access provided by Assam down town University

6,118 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

50 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

50 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 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.

Skills you'll gain

Tools you'll learn

Microsoft Excel

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

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Business Strategy expertise

This course is part of the Microsoft Project Management: Build Job-Ready Skills 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

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 videos Total 48 minutes

Introduction to the Course: PMP Formulas 5 minutes
EVM and Cost Management Overview 6 minutes
Planned Value (PV), Earned Value (EV), and Actual Cost (AC) 6 minutes
Variance Analysis and Performance Indicators 5 minutes
EVM Forecasting Overview 6 minutes
Estimate at Completion (EAC) 5 minutes
Estimate to Complete (ETC) 5 minutes
To-Complete Performance Index (TCPI) 6 minutes
Module Summary: PMP Formulas 4 minutes

9 readings Total 85 minutes

Course Syllabus: PMP Formulas 10 minutes
How to be successful in this course 10 minutes
EVM and Cost Management Formulas 10 minutes
Exploring Variance Analysis with Examples 10 minutes
EVM Forecasting Formulas 10 minutes
Exploring EAC and ETC Forecasting with Examples 10 minutes
TCPI Formulas 10 minutes
PMP Formulas Cheat Sheet 10 minutes
Additional Resources: PMP Formulas 5 minutes

7 assignments Total 105 minutes

Module Quiz: PMP Formulas 30 minutes
Activity: EVM and Cost Management Formulas 10 minutes
Knowledge Check: EVM and Cost Management Formulas 15 minutes
Activity: Forecasting Formulas 10 minutes
Knowledge Check: Forecasting Formulas 15 minutes
Activity: EVM Assessing Performance 10 minutes
Knowledge Check: EVM Assessing Performance 15 minutes

1 discussion prompt Total 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 videos Total 92 minutes

Introduction to Schedule Management Formulas 5 minutes
Critical Path Analysis Overview 7 minutes
Excel based Simulation: Forward and Backward Pass 6 minutes
Float & Slack 6 minutes
Excel based Simulation: Float & Slack 5 minutes
Introduction to Estimation 5 minutes
PERT Estimating 5 minutes
PERT Concepts 5 minutes
Excel based Simulation: PERT Distribution 6 minutes
Triangular Distribution 6 minutes
Excel Based Simulation 5 minutes
Introduction to Contingency Reserves 6 minutes
Management Reserves 7 minutes
Risk Analysis vs Estimation of Cost and Schedule 6 minutes
Risk Planning vs Estimation of Cost and Schedule 6 minutes
Module Summary: Scheduling and estimating 6 minutes

6 readings Total 55 minutes

Schedule Development Tools and Techniques 10 minutes
PMP Schedule Management Formulas cheat sheet 10 minutes
PMP Estimation Formula Cheat Sheet 10 minutes
Contingency Reserves 10 minutes
Monitoring and Adjusting Reserves 10 minutes
Additional Resources: Project risk and reserve management 5 minutes

8 assignments Total 115 minutes

Module Quiz: Scheduling and estimating 30 minutes
Activity: Critical Path Analysis 10 minutes
Knowledge Check: Critical Path Analysis 15 minutes
Activity: PERT Estimating 10 minutes
Activity: Triangular Distribution 10 minutes
Knowledge Check: Estimating Techniques 15 minutes
Activity: Reserve Management 10 minutes
Knowledge Check: Project risk and reserve management 15 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 videos Total 91 minutes

Introduction to Investment Forecasting and Analysis 7 minutes
Net Present Value (NPV) Overview 6 minutes
Net Present Value (NPV) Excel example 4 minutes
Future Value (FV) Overview 6 minutes
Future Value (FV) Excel example 3 minutes
Internal Rate of Return (IRR) Overview 7 minutes
Internal Rate of Return (IRR) Excel example 1 minute
Introduction to Project Selection 5 minutes
Benefit-cost ratio (BCR) Overview 5 minutes
Benefit-cost ratio (BCR) Excel example 4 minutes
Discounted Cash Flow Overview 6 minutes
Discounted Cash Flow (DCF) Excel example 5 minutes
Payback Period Overview 5 minutes
Payback Period Excel example 5 minutes
Overview of Investment Analysis 6 minutes
Expected Monetary Value (EMV) Overview 6 minutes
Expected Monetary Value (EMV) Excel example 4 minutes
Module Summary: Investment Analysis & Procurement 6 minutes

7 readings Total 65 minutes

PMP Investment Forecasting Formula Cheat Sheet 10 minutes
PMP IRR Formula Cheat Sheet 10 minutes
PMP Project Selection Formula Cheat Sheet 10 minutes
PMP Discounted Cash Flow Formula Cheat Sheet 10 minutes
PMP Investment Analysis Formula Cheat Sheet 10 minutes
PMP Expected Monetary Value Formula Cheat Sheet 10 minutes
Additional Resources: Investment Analysis & Procurement 5 minutes

8 assignments Total 115 minutes

Module Quiz: Investment Analysis & Procurement 30 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) calculation 10 minutes
Activity: Discounted cash flow 10 minutes
Knowledge Check: Project Payback Period 15 minutes
Knowledge Check: Investment Analysis 15 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.

What's included

2 videos3 readings2 assignments1 discussion prompt1 plugin

2 videos Total 10 minutes

Course recap: PMP Formulas 7 minutes
Congratulations 3 minutes

3 readings Total 50 minutes

About the final project and assessment 10 minutes
Exercise: Develop a project financial analysis report 30 minutes
Next Steps 10 minutes

2 assignments Total 120 minutes

Course Quiz: PMP Formulas 90 minutes
Self-review: PMP Formulas 30 minutes

1 discussion prompt Total 10 minutes

Reflect on learning 10 minutes

1 plugin Total 10 minutes

Exemplar: PMP Formulas 10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(6 ratings)

Microsoft

287 Courses 2,317,051 learners

Offered by

Microsoft

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
84%
4 stars
12%
3 stars
0%
2 stars
0%
1 star
4%

Showing 3 of 50

Reviewed on Dec 10, 2024

These formulas help assess project performance, estimate future outcomes, and analyze project risk.

Reviewed on Nov 11, 2025

I really apricate to Microsoft thanks it means a lot to me love from Pakistan to Microsoft such a incredible course contents

Reviewed on May 1, 2025

The course presents quantitative techniques in project managment clearly and comprehensively in a simple, straight forward manner with examples and illustrations.

View more reviews