Tabellab

Excel for Project Coordinators: Task Lists, Timelines, Budgets & Status Reports

20 hands-on labs for project coordinators and PMO assistants on one office-move project: WORKDAY task lists, % complete and status flags, a formula Gantt chart, milestones, resource hours, budget vs actual, change requests, a RAID log, action items, earned value basics and a weekly status report – plus supplier quote scoring, PO and invoice matching, internal labour cost, a seat plan, crate and van planning, the move-weekend schedule, the snag list, a staff survey and a close-out dashboard.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course follows one fictional office move through 20 hands-on Excel labs for project coordinators and PMO assistants. You build a task list with WORKDAY and holidays, % complete and status flags, a formula Gantt chart, a milestone tracker, resource hours with SUMIFS, budget versus actual with a chart, a change request log, a RAID log, action-item ageing, earned value basics and a weekly status report. The second part covers the rest of the move: scoring supplier quotes, matching purchase orders and invoices, internal labour cost by phase, a seat plan by floor, crate and van planning with ROUNDUP, the move-weekend schedule in hours and minutes, the snag list after the move, a staff survey with % favourable and a close-out dashboard with RAG statuses. Every cell is checked instantly; all names and figures are fictional.

Lessons

  1. Task List: End Dates with WORKDAY and HolidaysLabFree
  2. Percent Complete and Status Flags with IFLab Locked
  3. A Simple Gantt Chart with Formulas and Conditional FormattingLab Locked
  4. Milestone Tracker: Days Late and Late FlagsLab Locked
  5. Resource Hours by Person: SUMIFS, Load and Over-AllocationLab Locked
  6. Budget vs Actual by Phase: SUMIF, Variance and a ChartLab Locked
  7. Change Request Log: Approved Cost, Revised Budget and FinishLab Locked
  8. RAID Log: Counting Open Risks, Issues and High PrioritiesLab Locked
  9. Action Items: Days Open and Who to ChaseLab Locked
  10. Earned Value Basics: PV, EV, AC, CPI and SPILab Locked
  11. Weekly Status Report: Planned vs Actual, RAG and a Line ChartLab Locked
  12. Choosing a Mover: Total Quotes, Weighted Scores and the Best ValueLab Locked
  13. Purchase Orders vs Invoices: Matching, Over-Billing and Missing InvoicesLab Locked
  14. Internal Labour Cost: Hours × Rates by Role and PhaseLab Locked
  15. Seat Plan: Desks Needed per Team, Desks per Floor and Space LeftLab Locked
  16. Crate Planning: Crates per Team, Spares, Van Trips and CostLab Locked
  17. Move-Weekend Schedule: End Times, Crew Overlaps and the Buffer Before ClosingLab Locked
  18. Snag List After the Move: Days to Fix, Open Snags by Floor and the Fix TargetLab Locked
  19. Post-Move Survey: Responses, % Favourable, Average Score and Response RateLab Locked
  20. Final Project: Close-Out Dashboard – Budget, Milestones, Snags, Survey and RAGLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy