1) The ‘Planned’ and ‘Actual’ input areas are tables. You can add more rows if you have more tasks. In sheet ‘3 Data’, go to cell BA25 and press the tab key. This will add a new row to the table. Now, do the same in the bottom right cell for the ‘Actual’ table (cell BA274).

In the spirit of steering your enterprise towards its zenith, we present the must-have "Plan vs Actual" template, a tool that encapsulates this dynamic interplay. This template is not just a spreadsheet of numbers; it's a compass guiding you through your business voyage.

Free Planned vs Actual Excel tool to create a time schedule for your projects free to download with steps.

Create a project plan easily using this free Project Planner Template for Excel. Simple to use. Shows Planned vs. Actual Schedules

Mynda Treacy has just released a great video tutorial on how to create your own Plan vs Actual Excel Dashboard. Not only is there a video explanation on how she built it, but she has also released the sample dashboard Excel Workbook file that is free to download. Check it out here: Plan v Actual Excel Dashboard.