flevyblog

Flevy Blog is an online business magazine covering Business Strategies, Business Theories, & Business Stories.
MANAGEMENT & LEADERSHIP STRATEGY, MARKETING, SALES OPERATIONS & SUPPLY CHAIN ORGANIZATION & CHANGE IT/MIS Other

Sick of Microsoft Project? Manage Your Project in Excel

Project management is not easy.  Keeping track of deadlines, status, risks, issues, and competing priorities is not piece of cake.  There are hundreds of articles and management gurus out there with tips and advice on effective project management.  However, few (that I have seen) provide tools to put the ideas they provide into action.

While a good PM tool does not guarantee success, a bad one guarantees frustration and increases chance of failure. The de facto management tool in the industry is MS Project. But unfortunately when I have used MS Project, I end up focusing more on keeping MS Project documents running smoothly, rather than the project itself. It feels like working with a complex home theater system: you spend more time fiddling with the settings and re positioning the speakers rather than enjoying the movie.

My biggest problems with MS Project are:

  1. Speed – When working with MS Project, expect long load times, slow updates, and frequent crashes.
  1. Compatibility – Many people do not have MS Project loaded on their computers by default. So, when working with MS Project, I either have to acquire licenses for all stakeholders (and this can be quite expensive) or make sure I export all my work into PDF/Excel (also a slow process).
  1. User Friendliness – There is definitely a learning curve new users will have to climb before getting comfortable with MS Project. But even now, after using the software on multiple projects and having been to multiple training sessions, I find it can be hard to figure out the simplest of things. Also, many of the hotkeys that are standard across MS PowerPoint, MS Excel, and MS Word are not transferable to MS Project.

About a year ago I got so frustrated with MS Project, I decided to start working with Excel. While Excel does not support all the functionality that MS Project provides, it more than sufficiently satisfies the basic requirements of any project management tool. Excel is also far more customizable and compatible than MS Project, allowing me to build reports and share my work more easily with others.

excel_microsoft_project

I recently uploaded a Project Management Tool, built in Excel, to flevy.com. I have gathered some of the most useful functions/templates I have built in the past and condensed them into one document. The tool includes:

  • Overview of a project management Framework I have used in the past.
  • The ability to document and connect requirements, projects, and tasks.
  • Fully functional and automatic Gantt Chart.
  • Built in program level completion and heat map reporting functionality.
Aside from the author’s Excel-based Project Management Tool, Flevy offers a number of other PM tools and methodologies, including: (Alternate) Excel-based Project Management Tool, Excel-based Project Prioritization Tool, and PRINCE2 Project Management Overview.

Although not as deep in functionality as MS Project, I find tools like this are far easier to use and manage, allowing me to focus on the project at hand. Most importantly, I can easily customize these documents to best fit the project’s needs.

About Priyank Pandey

Priyank is a Management Consultant, specializing in Risk Management. He has worked across multiple industries, including banking, capital markets, and healthcare. He is also the author of the blog Writing In Transit where he writes about his experiences as a consultant and his pursuit of an MBA.

, ,




  • ertmkdsdrt

    wqzheazwjes5ryk

    • ertmkdsdrt

      eawrbeytrd

      • ertmkdsdrt

        dhmdftymyrtym

        • ertmkdsdrt

          dfmktdymkkrs

          • ertmkdsdrt

            drkrytdrt7r

          • ertmkdsdrt

            fuktutdltud6u6y

        • ertmkdsdrt

          ftkutk7tfktftkjm

      • ertmkdsdrt

        tfkuftkuytl

        • ertmkdsdrt

          fkuyufluf,tuyji

    • ertmkdsdrt

      fdyumdftyk,dr

      • ertmkdsdrt

        ftulkfr7ltr6l

      • ertmkdsdrt

        tf;lyul,tdduytf

        • ertmkdsdrt

          ftkuyflftyutf;l

    • ertmkdsdrt

      dydkkrd7kl,m6r

      • ertmkdsdrt

        sdrtjsejrtj

      • ertmkdsdrt

        dkyrtl7drskor

        • ertmkdsdrt

          rk7dr7kr5kfdy

  • Martin_Ternouth

    I have been using Excel for Project Management since 1995 for the reasons given. See: http://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=000076 posting No. 4

    Martin Ternouth

  • Louis Marville

    Microsoft Project 2013 SP1 works very well along Sharepoint 2013. It is fully functional and customizable. The trick is you have to install Project Server 2013 as well

Complimentary Business Training Guides


Many companies develop robust strategies, but struggle with operationalizing their strategies into implementable steps. This presentation from flevy introduces 12 powerful business frameworks spanning both Strategy Development and Strategy Execution. [Learn more]   What does it take to achieve Operational Excellence? Read this guide and learn to build an integrated Business Execution System from Six Sigma Master Black Belt Frank Adler, co-founder of Operational Excellence Consulting. [Learn more]
The Fiaccabrino Selection Process (FSP) is a proven methodology for increasing sales and reducing turnover, developed by "Mr. Roche," Charles Fiaccabrino. Mr. Fiaccabrino is a Sales Executive with over 50 years of experience. [Learn more]   Learn this time-tested approach to Change Management authored by Ron Leeman, recipient of the Change Leader award by the World HRD Congress in 2012. Ron Leeman has been Change, Process and Project professional since 1974. [Learn more]
Recent Articles by Corporate Function

  

  

  

  

  


The Flevy Business Blog (http://flevy.com/blog) is a leading source of information on business strategies, business theories, and business stories. Most articles have been contributed for management consultants and industry executives with over 20 years of experience. If you would like to contribute an article, please email our editor David Tang at [email protected].

Flevy (http://flevy.com) is the marketplace for premium business documents, such as management frameworks, presentation templates, and financial models. Our documents are of the same caliber produced by top tier consulting firms, like McKinsey, Bain, Accenture, BCG, and Deloitte. Learn more about Flevy here.


Connect with Flevy:

   
  


About Flevy.com   /   Terms   /   Privacy Policy
© 2015. Flevy LLC. All Rights Reserved.