🎉 Black Friday: 40% OFF every course with code BF40 · ends 1 Dec  See courses →
A new chapter in practical learning · Now enrolling: Excel + AI Mastery, Excel Essentials in 2 Hours, Excel Pivot Tables & Dashboards, Excel VBA Basics with AI, Financial Modeling in Excel, Google Sheets Complete Course, Power BI and Project Management in ExcelView the courses ↗
← Course overviewProject Management in Excel: Plan, Schedule, Track & Report
Free preview lessonProject Management in Excel: Plan, Schedule, Track & Report88 lessons · 9h 32m · Certificate of completion
Regular price ₹5,999.00 ₹3,900.00
View course details
MODULE 2 / 17LESSON 3 OF 88

Project lifecycle and the triple constraint

Module 1: PM Basics for Excel Users · 9 min

In this lesson

Before the clinic project starts, the partners ask a simple question: if we add a children's play area to the scope, what happens to time and cost? That is the triple constraint.

  • The five-phase project lifecycle table
  • A triple-constraint calculator: extra scope -> extra days, extra cost, new finish date

Steps

  1. Read the lifecycle phases and their key outputs
  2. Enter the extra scope percentage
  3. Calculate the extra working days and the extra cost
  4. Calculate the new finish date with WORKDAY

Key formulas (first cell of each row - copy across / down)

SheetCellRowFormula
LifecycleD23Extra working days=ROUNDUP(D16*D20,0)
LifecycleD24Extra cost=D17*D20
LifecycleD25New plan - working days=D16+D23
LifecycleD26Base finish date=WORKDAY(D15,D16-1,$G$15:$G$17)
LifecycleD27New finish date=WORKDAY(D15,D25-1,$G$15:$G$17)
LifecycleD28New budget=D17+D24
LifecycleD29Time status=IF(D27<=D19,"Inside target","Late")
LifecycleD30Cost status=IF(D28<=D18,"Inside budget","Over budget")

Check your answers

ItemCellExpected
Extra working daysLifecycle!D2310
New finish dateLifecycle!D27Jun 24, 2027
New budgetLifecycle!D28$482,680
Time statusLifecycle!D29Inside target
Cost statusLifecycle!D30Over budget

Watch out for

  • Adding calendar days instead of working days to a finish date

Chapters

  • 00:00 Welcome
  • 00:23 The Lesson Guide
  • 00:43 What makes it a project
  • 01:03 Initiate and Plan
  • 01:29 Execute, Monitor and Close
  • 01:57 The key outputs
  • 02:18 Phases with a loop
  • 02:34 The triple constraint
  • 02:53 The calculator inputs
  • 03:28 Extra scope and holidays
  • 03:49 Pause and predict
  • 04:06 Extra working days
  • 04:31 Extra cost and new plan
  • 05:00 How WORKDAY reads
  • 05:17 Base finish date
  • 05:46 New finish date
  • 06:15 The most common mistake
  • 06:36 New budget
  • 06:52 Time and cost status
  • 07:26 The answer for the partners
  • 07:46 Check the work
  • 08:04 Your turn

Your turn

  • What scope increase still finishes by June 30, 2027?

Practice files

Download Module-01-PM-Basics-for-Excel-Users-Practice-Files.zip from the Practice resources tab and open the folder Lesson 1.1: Lesson_1_1_Practice.xlsx, Lesson_1_1_Solution.xlsx. The Practice file is where you start; the Solution file shows the finished result.

Brightline Dental Group and Maple & Pine Furniture are fictional businesses; all names and numbers are for training only.

FREE EXCEL LESSONS BY EMAIL

Not ready to enroll yet?

Join the Academy email list for practical Excel and AI tips, free preview lessons and news when a new course opens. Unsubscribe at any time.