Category Archives for "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

How to Create a SWOT Analysis

Career , Personal Performance , Project Management , Strategy , SWOT Analysis and Action Plan , SWOT Analysis and Action Plan

A SWOT analysis can help you discover the best direction to move, strengths you can take advantage of, and weaknesses you need to avoid or shore up. Making a SWOT analysis worthwhile takes brainstorming, discussion, arguing, prioritizing, and finally, executing an action plan. It should break new ground and create new insights into developing a […]

Continue reading

Analyzing Business with SWOT Analysis

Project Management , Strategy , SWOT Analysis and Action Plan

The following lists are meant to get you started thinking about topics in each of the four quadrants. You may want to limit each quadrant to the most impactful five issues. So, although it’s easy to come up with many topics, you will want to choose the ones that are most critical to your objective. […]

Continue reading

How to Create a SWOT Action Plan

Career , Personal Performance , Project Management , Strategy , SWOT Analysis and Action Plan , SWOT Analysis and Action Plan

There’s not much point in creating a SWOT analysis unless it causes change. If the SWOT analysis just produces a lot of good discussion and then gets put away in a book, it’s not of much value. You need a system where the SWOT analysis will drive action. That system is the SWOT Action Plan. […]

Continue reading

Where SWOT Analysis Go Wrong

Career , Personal Performance , Project Management , Strategy , SWOT Analysis and Action Plan , SWOT Analysis and Action Plan

One best practice tool that’s almost always used (or should be used) before making a change in organizations, projects, or even personal life and career is a SWOT analysis. SWOT stands for Strengths, Weaknesses, Opportunities, and Threats. When done correctly a SWOT can give you the insights you’d get from a big brother (or sister) […]

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