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.
- 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
- Task List: End Dates with WORKDAY and HolidaysFree
- Percent Complete and Status Flags with IF Locked
- A Simple Gantt Chart with Formulas and Conditional Formatting Locked
- Milestone Tracker: Days Late and Late Flags Locked
- Resource Hours by Person: SUMIFS, Load and Over-Allocation Locked
- Budget vs Actual by Phase: SUMIF, Variance and a Chart Locked
- Change Request Log: Approved Cost, Revised Budget and Finish Locked
- RAID Log: Counting Open Risks, Issues and High Priorities Locked
- Action Items: Days Open and Who to Chase Locked
- Earned Value Basics: PV, EV, AC, CPI and SPI Locked
- Weekly Status Report: Planned vs Actual, RAG and a Line Chart Locked
- Choosing a Mover: Total Quotes, Weighted Scores and the Best Value Locked
- Purchase Orders vs Invoices: Matching, Over-Billing and Missing Invoices Locked
- Internal Labour Cost: Hours × Rates by Role and Phase Locked
- Seat Plan: Desks Needed per Team, Desks per Floor and Space Left Locked
- Crate Planning: Crates per Team, Spares, Van Trips and Cost Locked
- Move-Weekend Schedule: End Times, Crew Overlaps and the Buffer Before Closing Locked
- Snag List After the Move: Days to Fix, Open Snags by Floor and the Fix Target Locked
- Post-Move Survey: Responses, % Favourable, Average Score and Response Rate Locked
- Final Project: Close-Out Dashboard – Budget, Milestones, Snags, Survey and RAG Locked
Learner reviews
Be the first to review this course.