Tabellab
Intermediate

Project Management with Excel

Plan, schedule, budget and track one real project end to end: PERT estimates, workday schedules, critical path, S-curve, earned value, risk register and RAG status in 8 labs.

8 lessons 8 labs 2.1 h Certificate

The first lesson is free — no account needed.

About this course

Project management with Excel, built on one real project from start to finish. You estimate work with three-point (PERT) estimates, schedule dates with WORKDAY and dependencies, find the critical path and slack, load resources into a cost budget and S-curve, track progress with earned value and forecast EAC, ETC and TCPI, score a risk register and report RAG status with IFS.

Lessons

  1. Work Breakdown & Three-Point (PERT) EstimatesLab14 minFree
  2. Schedule Dates with WORKDAY & DependenciesLab15 min Pro
  3. Critical Path: Forward Pass, Backward Pass & SlackLab18 min Pro
  4. Resource Loading, Cost Budget & the S-CurveLab16 min Pro
  5. Earned Value: PV, EV, AC, Variances & IndicesLab16 min Pro
  6. Forecasting with Earned Value: EAC, ETC, VAC & TCPILab14 min Pro
  7. Risk Register: Scoring, Expected Monetary Value & RankingLab15 min Pro
  8. Status Report KPIs & RAG Status with IFSLab15 min Pro