All articles with 'resource management' Tag

Excel Time Sheets and Resource Management [Project Management using Excel – Part 4 of 6]

Published on Aug 5, 2009 in Charts and Graphs, Featured, Learn Excel
Excel Time Sheets and Resource Management [Project Management using Excel – Part 4 of 6]

Timesheets are like TPS reports of any project. Team members think of them as an annoying activity. For managers, timesheets are a vital component to understand how team is working and where the effort is going. By using Microsoft Excel capabilities you can create a truly remarkable timesheet tracking tool.

In this installment of project management using excel series, we will learn 3 things about timesheets and resource management using Excel
1. How to setup a simple timesheet template in excel?
2. How to make a more robust timesheet tracker tool in Excel?
3. How to use the timesheet data to make a resource loading chart?

Continue »