Project Management

Please login or join to subscribe to this thread

PM By Excel - Little Help

linkedin twitter facebook  
avatar
Alan Casey Senior Project Manager| Ford Motor Credit Company Dewitt, Mi, United States
Anyone have a decent template or advice for using Excel as a PM repository? Trying to solve a business challenge with something the client has and knows.

Any help would be great!
Sort By:
avatar
Olga Goloburda Specialist focused on Productivity Software Minsk, Belarus
Hi, Alan.
I’m with Easy Projects .NET (http://www.easyprojects.net) and I think our product might be a good fit for you (of course I’m biased :)

Let me know if you have any questions.
I’d be happy to help.
avatar
Tim Cermak Global Manager Business Planning and PMO -- Connected Car & Customer Experience| General Motors Highland, Mi, United States
Hi Alan, when you state "using Excel as a PM repository", can you provide some details as to what you are looking to capture in Excel? Tasks, pivot charting, etc.?
avatar
Alan Casey Senior Project Manager| Ford Motor Credit Company Dewitt, Mi, United States
@ Tim,

Imagine one spreadsheet per project, with tabs for each PM deliverable (Charter, Risk Plan, Communication Plan, etc.

Alan
avatar
Alan Casey Senior Project Manager| Ford Motor Credit Company Dewitt, Mi, United States
@ Olga,

Thanks for the suggestion - your product does look cool, but . . .

My client plans to implement a PPM took in the next 12 - 18 months and needs a stop gap method that allows for a data conversion into the new PPM.

One option on the table is "How about a spreadsheet per project . . ." That is what I am trying to wrap my brain around.

PS This is a large and mature corporation (just not so much in project/program management)
avatar
Rod Gwinn PM Consultant| CSG Government Solutions Salem, Or, United States
Here is one sample
avatar
Naomi Caietti Senior Project Manager | ePMO | Higher Education | Healthcare & IT| Linkedin.com/In/NaomiCaietti
Here is an excel based Toolkit from A - Z on management of a project.

http://www.cio.ca.gov/Government/IT_Policy...it_03072011.xls
avatar
Alan Casey Senior Project Manager| Ford Motor Credit Company Dewitt, Mi, United States
@Rod and @Naomi

Thanks for two "Excel" ant examples! This stuff is much better than I had hoped to find.

@Rod - I am honored to be associated with your first post - Welcome to the community.

You both Rock!

Alan
avatar
Naomi Caietti Senior Project Manager | ePMO | Higher Education | Healthcare & IT| Linkedin.com/In/NaomiCaietti
Alan;
You're welcome! Rod is doing some cool stuff too! Check out the State if Michigan website also. Their PMO is very mature and they have some great tools also.
avatar
Rod Gwinn PM Consultant| CSG Government Solutions Salem, Or, United States
Glad to be able to contribute.

Please login or join to reply

Content ID:
ADVERTISEMENTS

"There is no shame in not knowing; the shame lies in not finding out."

- Russian proverb

ADVERTISEMENT

Sponsors