Microsoft Excel Gantt Charts Help You Map Out a New Project
If you are from the corporate world and you’ve needed to project manage a new implementation of something like a staff induction system, a new computer system, change in procedure you’ve probably used a project plan which highlights:
- People involved
- Communications strategy
- Tasks to complete
- Due date
- Other resources required
- Dependencies, etc
These plans can be huge and detailed and just like writing complicated tender proposals they require a good, thorough knowledge of some of the more advanced tools available in Microsoft Word. Despite all of the complexity you can display the stages, timeframes and dependencies using a Gantt chart and you can now do this using a template file in the latest version of Microsoft Excel. We are currently reviewing each of our courses in readiness for the creation of new content for these courses and we discovered this tool in the latest version of Microsoft Excel.
Other tools to help create Gantt charts
We use Smartsheet to managed detailed Gantt charts (where the dependencies can change regularly) and BaseCamp (a popular project management tool) to not only keep track of all the tasks, but also enable all team members to make comment, start discussions and mark their jobs complete. The downfall with these programs is they either cost money (and the price increases as you add team members) and you have to learn a whole new system, so it’s good to have a simple tool that’s included in a program you probably already have – Microsoft Excel.
We’ve used these project management tools to manage all the steps in the process of:
- Setting someone up in their new bookkeeping business for National Bookkeeping,
- Helping a real estate agent with their new website and digital strategy, and
- Provisioning an online induction for staff and contractors
Gantt charts enable us to systemise the process as well as enable remote workers to understand how the work they do fits into the framework of all the other tasks which need to be performed.
Microsoft Excel and Gantt Charts
In first looking at the Gantt Chart template file that is available in the latest version of Microsoft Excel it is fairly rudimentary and based on monthly milestones. If you are an existing Gantt chart user this might seem to basic, but it is fantastic if you want an introduction to them. I’ve used them as a tool to help identify why a staff members task is important and needs to be completed by a certain date and if you are struggling to meet deadlines because you’re counting on the work from other people this might be a great tool to help you work smarter and manage people better.
EzyLearn offers all levels of Excel training – from Absolute Beginners to Advanced – for the one price and the reason students choose us is because:
- They can start quickly (by 5pm next business day)
- They have access to all skill levels
- They can use the course as a resource for 12 months (or even lifetime)
- We use a combination of videos, workbooks, exercise files and knowledge reviews
- They can learn at their own pace
- They can learn from anywhere in the world
- We offer a 30 day money-back guarantee
- We offer a free sample course for 301 Beginners to Excel
If you’re interested in doing a course that is designed to take you on a learning journey from basics to advanced features, check out our Excel Courses page.
-- Did you like what you read? Want to receive these posts via email when they are published? Subscribe below.