Here’s a little secret for you -- everybody does it. At one point or another during their careers, every project manager will use Microsoft Excel to manage one of their projects!
That in itself is not surprising. After all, budgets are often tight and companies may not want to invest into full blown project management software. And if they have such a software there are only a limited number of licenses available, which means many stakeholders cannot access the tool. So we project managers make due with what we have. And practically everyone has Microsoft Office.
But what is surprising is the fact that we just improvise. We will simply use Excel to the best of our often mediocre knowledge in order to somehow force a project schedule into those cells.
Well... enter Doug Hong (http://www.linkedin.com/in/doughong/en) and his series of seven free Microsoft Excel tutorials, that you can find at http://www.exceltraining101.com/excel-project-management/. In these seven short videos Doug shows you how to use MS Excel and create professional Gantt charts, work breakdown structures, checklists, pareto charts and more. All for free.
And because I liked the free approach I decided to invite Doug and ask him when and how we should use MS Excel, what Excel features we should learn about to better use it for our projects, and how we can identify the moment in our projects when Excel is really no longer the right tool and we have to upgrade to something more solid.
Until Next Time,
Cornelius Firchtner, PMP, CSM
Every Friday we present to you a free item for your PMP Exam Preparation.
This is a free lesson from The PM PrepCast.
In this lesson, we describe the aspects of the assets, which the project manager has at his or her disposal. We see how organizational process assets can be used throughout the project management process groups and are used in all 10 project management knowledge areas. We look at examples of processes and procedures and discuss the information flow and examples of corporate knowledge bases.
http://youtu.be/_Nyl_jNK1Ow - This free video from The PM PrepCast is only available for a limited time. If you are preparing for your PMP exam and like this video then consider using The PM PrepCast that gives you over 50 hours of videos of this kind.
Only this weekend: We are opening to the public this free episode of the PrepCast where we give you an overview of the Project Integration Management Knowledge Area. We review what the knowledge area contains, what the general concepts of its processes are, we discuss project interactions, the charter, the PM Plan, historical files and many other concepts. The PM PrepCast™ contains one episode like this for all 9 knowledge areas in the PMBOK® Guide 4th edition. We want you to be well prepared.