How I Manage Projects with Outlook and Excel

PMThere are a LOT of theories and ideas floating around to help with time management and productivity.  Classes and seminars are offered, books are published, and websites and blogs are posted all to try to help us better manage our lives.  For this author there has been no one method to help with time and productivity management.   In fact before I knew about these methods I was trying to come up with things on my own that many of these methods suggest.

In today’s posting I am going to give some insight on how I manage my projects using Microsoft Outlook, ClearContext’s IMS, Nelson’s Email Organizer (NEO) and Excel.   My goal has been to try to get everything I do that is work related consolidated into a single location and while Outlook is getting pretty close, my work environment requires some additional reporting structures that keep me away from my single trusted system.

For those of you familiar with Getting Things Done (GTD) by David Allen, or Total Workday Control (TWC)by Michael Linenberger it is all about changing the way that we work.  This can be as simple as the little things like grouping like things together and working on them all at the same time to much more complex and time consuming changes like rebuilding your workspace, developing filing systems, etc.   The key for me was to latch on to an idea or two and work with them, integrate them into your life and then add more once I had mastered the ideas I was working on.

When I started managing projects I found rather quickly that the medium that people wanted to use for communication was email.  I quickly went from an email box of 20-30 pieces of significant email every day to 200-300 pieces of email every day.  Combine that with customer face time and limited access to email and I soon found I was not keeping up.  I needed a solution that could help me manage and find things much easier than I had in the past.   The solution I found at the time was Nelson Email Organizer.  This is a great tool and one that I use to this day for email searches and correspondent management right from within Outlook.  NEO It was my first attempt at managing each piece of email in my Inbox, giving it a home, and knowing and being comfortable with the fact that I was going to be able to find it again if needed.   Another KEY feature of NEO for me was the ability to search across multiple mail stores.  Remember that 2GB limit that Outlook used to have?  My solution to that was to create separate Archives and move messages into those archives.   The down side to that is the messages were no longer search-able in Outlook unless I loaded each of the archives one at a time and performed the search.  Because NEO creates its own set of indexes that are super fast, this restriction was removed and I could keep years worth of email and search through 10s of thousands of messages in a matter of seconds.

WorkflowNEO and Outlook worked well for me for quite awhile but NEO didn’t help me with managing tasks and so I went on the hunt once again for web solutions for project management.  Ultimately I stumbled across GTD (Getting Things Done) and TWC (Total Workday Control).  Take a look at the graphic.  The concept with these systems is that as messages come into your inbox you need to make a decision about them.  Ask yourself if you need to do something with this email… If not you probably just need to file it away as a reference or better yet if it isn’t going to be needed just delete it. (NEO would help me with this so this was nothing new.)  The other side of the equation however is more difficult to deal with.  If I need to do something with it, what is it that needs to be done, who should do it, when should it be done, etc… all start entering into the picture.   As you can see from the graphic there really are 3 choices… I do it now, I delegate it to someone else, or I hold onto it until a future date.  It was something that hit me as being so simple yet almost unbearable to manage.  That is where ClearContext’s IMS product entered the picture for me.  With IMS not only are the non-actionable items manageable but the actionable items become manageable as well and all linked to the appropriate projects and people.  I downloaded it, installed it and I’ve never looked back.  Keep in mind that I don’t claim to be a GTD or TWC guru and I don’t do all of the things that I’m supposed to do nor will I probably ever do them all.  I don’t even use all of the functionality that exists within ClearContext’s IMS product (yet).  That isn’t the point.  The point is I use what works for me and as I fine tune my process I may also find I use more of their concepts or in the case of the software their tools. 

The last tool that I have started using pretty extensively is Excel.  I find that I can use it to keep track of a lot of information in an organized form and have at my fingertips information about each project that I use on a day to day basis.  With Excel I am able to streamline common project tasks information on the items that are repeated for each project that I work on.  The members at Excelforum  have really helped me in this end goal by helping me to create scripts that help me keep track of tasks that are completed, scripts that help me to create new task spreadsheets with limited numbers of key-presses, and most recently with a script that helps me to create Outlook tasks for each and every item  of a project that I need to be tracking.

While my methods are not perfect… the goal is and has always been to increase my productivity and reducing the amount of work that I have to perform.   I’m always looking for great new ideas so if you have any to share please do so.   In the next few weeks I hope to share with you some of the scripts that I use in my Excel workbook.  I also encourage you to read my reviews on ClearContext or better yet go to their website and download the application and give it a try.

About the Author

Bill

I am a project manager for a software company. Currently my focus is on system implementation and training. My background also includes training development including web based and self-paced instructional materials. I have an extensive background in retail information systems including Point of Sale, Inventory Control and Business Management.

6 Responses to “ How I Manage Projects with Outlook and Excel ”

  1. [...] presents How I Manage Projects with Outlook and Excel | Projects Possible posted at Projects [...]

  2. I use EasyProjectPlan which is an Excel Project Plan that syncs with Outlook and MSProject.

    http://www.EasyProjectPlan.com

  3. I can only assume that Angello is the developer or is in some way related to Easy Project Plan but hey every opportunity to help streamline the process good. I am seeking more information about his products… Perhaps I will make additional comments about what I find.

  4. Im actually not affiliated with the company.

    I found your article and thought you would be interested in the software I use to manage my projects.

    You stated in your article that your “goal is and has always been to increase my productivity and reducing the amount of work that I have to perform.”

    EasyProjectPlan has accomplished this for me on every project I have managed.

  5. Angello, thanks for the insight… I have visited the website and I am intrigued by their offering. I did download the demo and have played with it a bit… If my understanding is correct each project would have a separate worksheet but those can roll-up to a main sheet somewhere? Do you use that capability? Do you also use it to send out Tasks to other team members and have them report back… Seems as if you can also send them the worksheet and have it imported back in when they return it to you.

    How do you actually use the app?

    What did you think of the price? Seems a bit expensive to me.

  6. The license allows the PM to distribute EPP files to an unlimited number of team members. This allows me to distribute my project plans in an Excel format that can be viewed by all my team members.

    Most of the companies I work for have no PM task management system so EPP allows me to walk onto any project and immediately distribute and collect task information to all team members. I can do all this with s single license. Compare that to a Project server license (70K) or a Project Viewer license which is required for every team member computer.

    I use the Outlook and Calendar sync to distribute and collect task information and I distribute the Excel file to all team members either by email or I post it in a shared folder.

Leave a Reply

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <blockquote cite=""> <code> <em> <strong>