🎉 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 1 / 17LESSON 1 OF 88

Welcome: the project workbook you will build

Module 0: Welcome · 7 min

In this lesson

Meet Brightline Dental Group: two dental clinics in Denver that are opening a third one in Cherry Creek. The partners want the new clinic open by June 30, 2027 and within a $450,000 budget. In this course you plan, schedule, track and report that project in Excel - and then share it in Google Sheets and Power BI.

  • A tour of the finished project workbook: charter, WBS, schedule, Gantt, resources, budget, EVM, RAID log and dashboards

Steps

  1. Open the complete workbook and click through every tab
  2. On the Setup tab change the project start date by one week and watch the schedule, Gantt and dashboard move
  3. Set it back before you close the file

Chapters

  • 00:00 Welcome
  • 00:15 Meet Brightline Dental Group
  • 00:38 One workbook, twenty three sheets
  • 00:52 The Setup sheet
  • 01:17 Charter and stakeholders
  • 01:40 The WBS
  • 01:56 The Schedule
  • 02:17 The schedule summary
  • 02:33 Three Gantt views
  • 02:54 Resources, load and RACI
  • 03:14 Costs and budget
  • 03:33 Tracking progress
  • 03:54 Earned value
  • 04:15 The RAID log
  • 04:34 The status report
  • 04:54 The sponsor dashboard
  • 05:15 The pivot sheet
  • 05:30 The portfolio
  • 05:42 Everything is linked
  • 06:06 How the course is built
  • 06:29 Your turn

Your turn

  • Find the planned opening date and the CPI on the Dashboard tab and write them down - you will rebuild both yourself

Practice files

Download Module-00-Welcome-Practice-Files.zip from the Practice resources tab and open the folder Lesson 0.1: Brightline_Complete_Project_Workbook.xlsx.

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.