+ Reply to Thread
Results 1 to 3 of 3

Making a Project Management Agenda

  1. #1
    Registered User
    Join Date
    04-20-2009
    Location
    Internet
    MS-Off Ver
    Excel 2007
    Posts
    7

    Making a Project Management Agenda

    I am looking to make an a project management calendar

    i am looking to fill dates on the side as due dates and have it show how many days remaining to said due date.

    however each project will have several sub categories ie

    if i had a big meeting as one project, a sub project of that would be to book the meeting room. I want a way to enter dates for the main project (big meeting) then set due dates for the sub project ie set it to be completed 10 days prior to due date.

    I have included a picture of how i've set everything up.

    I have no problem putting in the date for the main project then finding out how many days left. but i cant imagine how to implement the sub categories.

    please see attached.

    exe.jpg

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Making a Project Management Agenda

    My first recommendation is to bite the bullet and use MS Project. I have watched many project managers, including myself, try to use Excel for projects, but the spreadsheets always fall short. Project has its faults and frustrations, but it does work.

    If this spreadsheet is all you really need, then I would recommend you use Groups. It should be in the Data ribbon in the Outline section. Looking at your picture, the groups may interfere with your other tables, so you may need to relayout or use another solution.

    Pauley

  3. #3
    Registered User
    Join Date
    04-20-2009
    Location
    Internet
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Making a Project Management Agenda

    we dont have ms projects. unfortunately, still looking for any help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1