TechRepublic : A ZDNet Tech Community

TR Dojo

by Bill Detwiler, Head Technology Editor
Contact

Microsoft Project is a robust, capable project management tool but, you can effectively manage small or midsize projects with Excel–saving yourself or your IT budget a pretty penny.

In 2002, Ken Brown, submitted what he labeled as a “low-budget Excel version of Microsoft Project.” At the time, Brown was an independent consultant working with Akibia Consulting in Dallas.

Excel project-planning spreadsheet

The project template contains sample tasks to get you started.

He said that two issues drove him to create his Excel project-planning template. Complexity was the first issue. Many of his team members were uncomfortable and/or unfamiliar with Microsoft Project. Cost was the second issue. “With this spreadsheet, we are able to lay out and manage small to medium-sized projects without the cost of deploying Project to all team members,” he said.

If you have a small to midsize project coming up, download the spreadsheet to quickly and easily organize your project.

Today’s lesson

What’s the takeaway from Brown’s experience? Use the right tool for the job. Unless you’re competing in Purdue University’s annual Rube Goldberg Machine Contest, there is no need to use a tool that’s more complex than the problem.

Bill DetwilerBill Detwiler is Head Technology Editor of TechRepublic. Previously, he worked as a Support Tech and IT Manager in the social research and energy industries. Read his full bio and profile. You can also follow him on Twitter.

Print/View all Posts Comments on this blog

What are you're favorite IT multifunction tools? Bill Detwiler - TechRepublicTechrepublic Moderator | 04/22/08
Word works too Lwood | 04/22/08
Project - easy once you know how a.sorr@... | 04/24/08
Sharepoint GSG | 04/24/08
Found Sharepoint to be slow - you? Bill Detwiler - TechRepublicTechrepublic Moderator | 04/24/08
Slow Hardware?... It's pretty fast for us. addicted2speed | 04/24/08
Not at all GSG | 04/24/08
Answer to Slowness GSG | 04/29/08
I like pictures SObaldrick | 04/25/08
Planner freeware also works pretty good natem@... | 04/28/08
Yes, I agree chris@... | 08/20/08
Tried EverNote before? pepoluan | 05/02/08
RE: Don't overcomplicate small IT projects--manage them with Excel 2rs | 04/24/08
try with OpenProj osocram@... | 06/04/08
Using Excel for years dean.owen | 04/25/08
RE: Don't overcomplicate...can be easy or not.... osocram@... | 06/04/08
RE: Don't overcomplicate small IT projects--manage them with Excel Ptero.4@... | 06/06/08
I use EasyProjectPlan (Excel Project Plan) APezz | 12/09/09

What do you think?

White Papers, Webcasts, and Downloads

Recent Entries

TR on Twitter

Archives

TechRepublic Blogs



Quick Reference: Linux Commands
Reduce stress and speed up resolutions with the easiest command references right at your fingertips. You'll receive a PDF file covering Linux, packed with the most common commands you'll need and use daily.
Buy Now
500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now

SmartPlanet

Click Here