Learning a few excel formulas can greatly improve the productivity of a project manager.
How to make Project Management Dashboards in Excel?Įxcel shines again as the perfect tool for creating project dashboards. A Project Management Dashboard provides all the crucial information about a project in a snapshot.
Are we on track with respect to budget, resources etc?įrom my project stake-holders and sponsorship team.Īnswering these questions will be very easy if you have prepared a good project management dashboard.What are the important issues we should worry about?.When I was leading projects, I used to get questions like, Reporting is one of the most important aspects of project management. Project Reporting and Project Management Dashboards Gantt Chart using Excel Stacked Bar Chart.A Simple Gantt Chart using Excel Conditional Formatting.Since Excel is a very common software and most managers know how to use it, using excel to prepare and maintain gantt charts can be very productive and easy. We can use Excel features like Conditional Formatting and Formulas to prepare a comprehensive gantt chart depicting almost any project. Preparing Gantt Charts in Microsoft Excel:Įxcel, because of its grid nature provides a great way to prepare and manage project plans. Gantt Charts can provide these optional information too, Intersection of an activity and date cell is highlighted if that activity is to be done on that date. It shows activities on the left and dates on top. Gantt Charts & Project Planning using MS ExcelĪ Gantt Chart is a traditional way to prepare and track a project plan.