Category Archives for "Excel Project Management"

Time and Project Management with an Even More Advanced Gantt Chart in Excel

Charts , Excel , Excel Project Management , Project Management , Project Management , Time Management

This advanced Gantt Chart in Excel has the basic scrolling Gantt Chart and custom weekends and holidays, but it also includes alerts for percent complete, email links to task leads, Work Breakdown Structure numbering (WBS), and filters to show only the tasks and date ranges you want. If you are managing personal tasks or small […]

Continue reading

Time and Project Management with an Advanced Gantt Chart in Excel

Charts , Excel , Excel Project Management , Functions , Project Management , Project Management , Time Management

This tutorial shows you how to take the basic Excel Gantt Chart and add conditional formatting so the Gantt chart shows today’s date, custom holidays, and custom weekends. Changing the WORKDAYS.INTL function will also adjust the end date to account for non-working custom weekends and holidays. A Gantt Chart in Excel is a powerful way […]

Continue reading

How to Build a Gantt Chart in Excel

Charts , Dashboards , Excel , Excel Project Management , Functions , Project Management , Project Management

Gantt charts help you track the progress of tasks in a project. This and the following tutorials will show you how to create a Gantt chart in Excel and then enhance it with robust features. The tutorial starts with a simple Gantt chart using conditional formatting and a few functions and evolves into a project […]

Continue reading

Excel’s Four Quadrant – Matrix Model Chart : Don’t Make a Decision without It!

Analysis , Balanced Scorecard , Charts , Dashboards , Decision Making , Excel , Excel Project Management , Personal Performance , Project Management , Strategy , Time Management

The Four Quadrant or Matrix Model is one the most valuable and widely used tools for decision making. This article has short descriptions of a few famous Four Quadrant – Matrix Model charts. The related article shows you how to create the two most used types using Excel charts. You can’t be a successful consultant […]

Continue reading

Creating Dynamic Excel Timelines that Scroll

Analysis , Charts , Dashboards , Excel , Excel Project Management , Personal Performance , Project Management , Project Management , Time Management

Last week’s newsletter described how to create a static event timeline in an Excel chart. In this article you’ll learn how to make the timeline dynamic so you can scroll the timeline through a database of events or project due dates. Timelines are great for project management in Excel, event management, and editorial or marketing […]

Continue reading

Create an Excel Timeline Chart to Manage Your Projects and Events

Charts , Dashboards , Excel , Excel Project Management , Personal Performance , Project Management , Time Management

Excel timeline charts are a great tool in any professional’s toolkit. You can insert Excel timelines in your Excel workbooks where you manage projects, show resources and expenses, schedule marketing events, etc. They make communication and detection of conflicts much easier. In the following article you’ll learn how to make a static timeline. In the […]

Continue reading

Finding the Right Metrics for Your Excel Dashboard

Analysis , Charts , Dashboards , Excel , Excel Project Management , Metrics and Measures

I’ve noticed that dashboards often get started when a manager says something like, “We have to get a handle on these numbers. Let’s make an Excel dashboard so we can all see the trends and changes.” The question that follows is, “Should we track the same metrics?” To which someone else asks, “Well what metrics […]

Continue reading