In this video, learn what to do when one person has too much work to do. Different examples include duties being moved to another person, time, or both. Additionally, learn how you can use Excel to manage this process.
- Let's take another look at my three views…of the cube, as described in the previous video.…By the way, I've included a copy of the spreadsheet…in the exercise files, so that you can download it…and play around with it.…So, looking at the three views, it's clear…that they are all interlinked.…And in fact, I've color coded it so that you can see…Fred's workload spread across the three projects in yellow.…Project A's February activity spread across…the people's diaries in green,…and Sally's work on project B,…spread across the months in orange.…
The question is, which screen to work with.…If you really do need to track all three screens,…because you have many projects, many people,…and many months to plan ahead, I would like to suggest…the following process.…First, use the Gantt view as the place…where you input your data,…who is doing what in each month for each project.…Remember that you could use a database for this,…but then it all becomes impossible…to really understand the workings,…which is why I'm suggesting using Excel.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- What is program management?
- Planning from the bottom up vs. top down
- Resource planning
- Managing projects, resources, and time
- Getting the staff you need
- Self-organizing teams