Here is a blog post on the Microsoft official Excel blog talking about tracking small projects in Microsoft Office Excel:
It goes without saying that Microsoft Project is THE program to use if you need to manage large projects. But what if you need to track and manage smaller projects? Can you do that in Excel? Sure, but life will be easier if you start with a template.
With that in mind, PowerPoint expert Glenna Shaw created a free project plan template that you can use to track projects in Excel. In addition to being a Most Valuable Professional (MVP) for PowerPoint, Glenna is a Project Management Professional (PMP). For more information about the template, see PowerPoint 2010 and Excel 2010: Perfect partners for tracking projects.
To get started, go to the project plan template on Glenna’s SkyDrive. The template is designed for use in the Excel desktop application, so you can ignore the message about unsupported features in the browser. In the message, just click Open in Excel and follow the prompts to save a copy of the template to your own computer.
Once you open the template in Excel, you can use it to:
- Estimate time and costs
- Create a project schedule
- Monitor schedule and budget
- Manage resources and risks
- Document lessons learned
- Create charts for use in presentations and reports
About Advanced Network Consulting:
For companies with 5-75 employees, Advanced Network Consulting is the ideal solution for providing onsite, ongoing technology support. Serving Southern California small and medium size businesses for nearly 20 years, our Certified IT Consultants provide desktop and network support, network security, server maintenance and upgrades. For a complimentary onsite evaluation of your system, call 562.903.3992. We look forward to meeting and forming a technology plan to grow your business.