Use This Excel Spreadsheet For Project Management

Full-blown project management demands dedicated software, but for simpler tasks a spreadsheet can do the job. Microsoft presentations and spreadsheet expert Glenna Shaw is sharing a project plan template which lets you plan your project and track milestones.

As well as letting you define project parameters, the spreadsheet is designed for easy integration with PowerPoint so you can easily produce update presentations on your progress. One detail to watch for: the spreadsheet calculates holiday dates for the US, so follow the instructions in Glenna's post for deleting those (and adding Australian ones if you wish).

PowerPoint 2010 and Excel 2010: Perfect Partners for Tracking Projects [via Excel Blog]


Comments

    I agree that for full blown PM a complex tool with all the reporting you can dream up can be generated, but anything simpler it seems like a tool like postfrenzy.com would be much better suited. It seems like a good trade-off for having to deal with the multiple versions while sharing a worksheet with someone else.

    I love the concept... I took it a few clicks further and created my own freely downloadable excel project scheduling template... complete with Gantt chart and all... take a peek over at http://www.mlynn.org/2012/05/excel-project-planning-spreadsheet/

Join the discussion!

Trending Stories Right Now