General discussion

  • Creator
    Topic
  • #2080787

    Project mgmt w MS Office?

    Locked

    by tplas ·

    Is anyone aware of any add-ins to MS Office tools, probably for Excel or maybe Word, that provide decent project mgmt help? Even if it’s just a simple tool to help with Gantt charts, sort of like Microsoft’s Org Chart tool provides specialized charting within Office. That might provide a basic level of project mgmt support, if one has MS Office but not MS Project.

All Comments

  • Author
    Replies
    • #3892165

      Project mgmt w MS Office?

      by jim_rau ·

      In reply to Project mgmt w MS Office?

      Visio is something that will build nice charts like this. Now that they are owned by Microsoft they should be even better integrated than the past. I use version 5.0 and it works well for this. Visio 2000 is available.

      But it isn’t project management software to speak of. You can do a Gantt chart but it isn’t like Microsoft Project (which I also have). In project you build the tasks and the chart comes out of that, if a task changes the chart will too.

      So if the boss wants charts … Visio is great. If you just got promoted to project manager for the long haul then it may be better to get a real application from Microsoft or someone else (others are available).

      Good luck on you projects !

      • #3784721

        Project mgmt w MS Office?

        by tplas ·

        In reply to Project mgmt w MS Office?

        Thanks, but I was looking for something that cost _LESS_ than MS Project, not more.

    • #3892158

      Project mgmt w MS Office?

      by larry h. ·

      In reply to Project mgmt w MS Office?

      Article #Q73281 in the Microsoft Knowledgebase at

      http://support.microsoft.com/support/kb/articles/Q73/2/81.ASP?LN=EN-US&SD=gn&FR=0

      has instructions on how to use Excel to create Gantt Charts.

      • #3784722

        Project mgmt w MS Office?

        by tplas ·

        In reply to Project mgmt w MS Office?

        Bingo! That’s the kind of simple thing I was hoping for. Thanks.

    • #3894822

      Project mgmt w MS Office?

      by s snow ·

      In reply to Project mgmt w MS Office?

      You might check http://www.portalsoft.com. They offer software that works out of Microsoft Outlook. I have a copy, but haven’t started using it yet, so I can’t tell you how good it is. They were giving away some free copies, but I don’t know for how long.

      • #3784723

        Project mgmt w MS Office?

        by tplas ·

        In reply to Project mgmt w MS Office?

        Interesting approach. Not quite what I had in mind, but perhaps worth checking out. Thanks.

    • #3894821

      Project mgmt w MS Office?

      by s snow ·

      In reply to Project mgmt w MS Office?

      You might check http://www.portalsoft.com. They offer software that works out of Microsoft Outlook. I have a copy, but haven’t started using it yet, so I can’t tell you how good it is. They were giving away some free copies, but I don’t know for how long.

    • #3776451

      Project mgmt w MS Office?

      by garyd ·

      In reply to Project mgmt w MS Office?

      Back in the old days of Lotus Symphony and 123, the tutorials included a spreadsheet using vlookup and max and min to do forward and backward start and end dates calculations for tasks. The spreadsheet had the following columns: task name, duration, start date and end date. The start date of the first task and end date of the last task where fixed. The rest were computed using vlookup to find the max of the start dates and min of the end dates. You can then create a bar chart (Gantt chart)of the results.

      • #3784725

        Project mgmt w MS Office?

        by tplas ·

        In reply to Project mgmt w MS Office?

        Thanks. I was hoping for a little less of the some-assembly-required, but is nice to know it’s that do-able if necessary.

    • #3776377

      Project mgmt w MS Office?

      by mmh ·

      In reply to Project mgmt w MS Office?

      Software Program Manager’s network @ http://spmn.com/index.html has a decent FREE project management add-on (Project Control Panel) for Excel–gives a good visual overview of the project status in many areas. If you have MS Project, you could also import from Project to this tool.

      • #3784726

        Project mgmt w MS Office?

        by tplas ·

        In reply to Project mgmt w MS Office?

        WOW!!! That’s PRECISELY what I was after. I wasn’t exactly expecting free. Thanks!!!

Viewing 5 reply threads