How I Manage Projects with Outlook and Excel

Written by Bill on December 19th, 2007 – 8:46 pm -

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.

Related posts


Tags: , , , , , , , , , ,
Posted in How To, Office Tools, Professional, Work On |

One Comment to “How I Manage Projects with Outlook and Excel”

  1. Being SMART About Setting Goals | Time Management & Goal Setting UNITED STATES WordPress 2.3.3 Says:

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

Leave a Comment



RSS

  • Slideshow

    Get the Flash Player to see the slideshow.
  • Stats

    • Pages displayed : 36271
    • Unique visitors : 13359
    • Pages displayed in last 24 hours : 248
    • Unique visitors in last 24 hours : 75