Home

Excel for Project Management

%3CLINGO-SUB%20id%3D%22lingo-sub-309084%22%20slang%3D%22en-US%22%3EExcel%20for%20Project%20Management%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309084%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20new%20to%20this%20platform.%20I%20stumbled%20onto%20this%20site%20in%20search%20for%20help%20creating%20an%20Excel%20worksheet%20(or%20book)%20to%20track%20vacation%20requests%20for%20a%20team%20of%2010%20directors.%20I'm%20sure%20this%20is%20simple%20enough%20for%20many%20of%20you%2C%20but%20I%20have%20limited%20use%20with%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20asked%20all%20of%20my%20directors%20to%20send%20me%20their%20vacation%20plans%20for%20the%20entire%202019%20calendar%20year.%20The%20objective%20is%20to%20track%20all%20vacation%20requests%20submitted%20during%20a%202%20month%20period.%20At%20the%20end%20of%20the%20two%20months%2C%20we'll%20approve%20the%20requests%20on%20a%20first%20come%20basis.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20tracking%20system%20that%20recognizes%20the%20date%20the%20individual%20submitted%20the%20request%2C%20the%20days%20they're%20requesting%20off%2C%20and%20whether%20it%20falls%20on%20or%20around%20a%20major%20holiday.%20My%20tracking%20system%20will%20be%20presented%20at%20the%20review%20meeting.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20things%20I'm%20also%20considering%20is%20whether%20or%20not%20my%20tracking%20system%20should%20also%20recognize%20any%20major%20team%20meetings%20or%20conferences%20that%20are%20scheduled.%20This%20way%20we%20have%20full%20visibility%20of%20our%20team's%20commitments%20and%20availability.%20Would%20this%20be%20helpful%2C%20or%20is%20it%20unnecessary%20to%20the%20task%20I've%20been%20assigned%3F%20Also%2C%20should%20by%20excel%20Book%20include%20an%20actual%20calendar%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20a%20template%20I%20can%20use%2C%20or%20can%20you%20recommend%20a%20template%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20HELPP!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309084%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
itsstevi
Occasional Visitor

Hello All,

 

I'm new to this platform. I stumbled onto this site in search for help creating an Excel worksheet (or book) to track vacation requests for a team of 10 directors. I'm sure this is simple enough for many of you, but I have limited use with Excel. 

 

I've asked all of my directors to send me their vacation plans for the entire 2019 calendar year. The objective is to track all vacation requests submitted during a 2 month period. At the end of the two months, we'll approve the requests on a first come basis. 

 

I want to create a tracking system that recognizes the date the individual submitted the request, the days they're requesting off, and whether it falls on or around a major holiday. My tracking system will be presented at the review meeting. 

 

Some things I'm also considering is whether or not my tracking system should also recognize any major team meetings or conferences that are scheduled. This way we have full visibility of our team's commitments and availability. Would this be helpful, or is it unnecessary to the task I've been assigned? Also, should by excel Book include an actual calendar? 

 

Does anyone have a template I can use, or can you recommend a template? 

 

 

 

Please HELPP!