http://www.brighthub.com/office/project-management.aspxenhttp://www.brighthub.com/office/project-management/articles/8708.aspxThu, 29 Oct 2009 12:37:09 GMTb133e95a-c263-4882-8f2a-b24547eff78e:8708mmcdonoughIf you want to make a Pareto chart to use in your project presentation but don’t have access to high-powered project management software, don’t panic. With these step-by-step instructions, you can use the more commonplace Microsoft Excel to create your Pareto chart. What is a Pareto Chart? A Pareto chart is a tool commonly used in S...http://www.brighthub.com/office/project-management/articles/3418.aspxThu, 29 Oct 2009 12:33:53 GMTb133e95a-c263-4882-8f2a-b24547eff78e:3418mmcdonoughAlthough Excel 2007 doesn't have a built-in Gantt chart wizard like the ones found in other software products, it's still possible to create this useful project management tool within the spreadsheet application. Excel Gantt Charts The Gantt chart is a very helpful and popular tool in the field of project management. A Gantt chart is just o...http://www.brighthub.com/office/project-management/articles/52901.aspxTue, 20 Oct 2009 15:13:07 GMTb133e95a-c263-4882-8f2a-b24547eff78e:52901Xintel2001Are you planning a small project and need to identify the Critical Path to create a project schedule? Are you teaching a course on Project Management and need your students to understand the Critical Path concept? Microsoft Excel 2007 might be the best software for such situations. Introduction Microsoft Excel 2007 neither has a component t...http://www.brighthub.com/office/project-management/articles/14642.aspxThu, 13 Aug 2009 21:40:22 GMTb133e95a-c263-4882-8f2a-b24547eff78e:14642RondaRobertsMicrosoft Excel can be a powerful tool in tracking the status of project action items. By combining careful communication with careful record keeping, it is possible Excel will fulfill your project management needs. Read on to find out how to utilize Excel as a register to track project action items Develop a System for Gathering Action Items While...http://www.brighthub.com/office/project-management/articles/32868.aspxTue, 28 Jul 2009 18:30:16 GMTb133e95a-c263-4882-8f2a-b24547eff78e:32868mmcdonoughThe versatility of Microsoft Excel makes it an excellent choice for many project management needs. Here, we’ll take a look at the number of free Excel project management tutorials and templates available at Bright Hub. Free Excel Project Management Templates There are a number of project management software choices on the market, and even tho...http://www.brighthub.com/office/project-management/articles/36053.aspxSat, 23 May 2009 12:47:04 GMTb133e95a-c263-4882-8f2a-b24547eff78e:36053mmcdonoughPreparing a graphical project timeline is a great way to give an overview of all that needs to be accomplished in a project as well as how much time it will take to complete. In this article, we’ll show how to construct such a timeline in Excel 2007. Project Timelines A Gantt chart may be a great tool to use when wanting to see a complete tim...http://www.brighthub.com/office/project-management/articles/36051.aspxSat, 23 May 2009 12:21:16 GMTb133e95a-c263-4882-8f2a-b24547eff78e:36051mmcdonoughThere are several methods that can be used to construct a workflow process diagram in Excel 2007, including taking advantage of the new SmartArt graphics. We’ll describe how to create such a chart that can be used in project planning and evaluation processes. Workflow Process Diagrams One of the best ways to provide a graphic representation o...http://www.brighthub.com/office/project-management/articles/36049.aspxSat, 23 May 2009 12:03:05 GMTb133e95a-c263-4882-8f2a-b24547eff78e:36049mmcdonoughWhether you have access to other project management software or not, you can still construct a professional-looking PERT chart in Microsoft Excel 2007. In this tutorial, we'll show how. How to Create a PERT Chart There are actually a number of ways that you can create a PERT Chart in Excel 2007, but I’m going to walk through the steps of one of...http://www.brighthub.com/office/project-management/articles/35768.aspxThu, 21 May 2009 15:14:17 GMTb133e95a-c263-4882-8f2a-b24547eff78e:35768mmcdonoughFishbone diagrams are great tools when trying to analyze inefficiencies in workflow processes. In this tutorial, we’ll show how to create a fishbone diagram in Excel 2007 that can be adapted to almost any project. Fishbone Diagrams in Excel Fishbone, or cause and effect, diagrams are often used in project planning sessions to identify all of ...http://www.brighthub.com/office/project-management/articles/3080.aspxTue, 12 May 2009 23:12:14 GMTb133e95a-c263-4882-8f2a-b24547eff78e:3080thursdayJust about everyone has Microsoft Office these days, but not everybody uses it to its full potential. One of the greatest benefits of using Office software, such as Word or Excel, is that there are thousands of templates available, including hundreds just for project managers. Finding Project Management Templates Putting together a project risk man...http://www.brighthub.com/office/project-management/articles/2173.aspxThu, 23 Apr 2009 15:41:25 GMTb133e95a-c263-4882-8f2a-b24547eff78e:2173anngordonMS Word works well for creating status reports for only one project at a time. But if you work multiple projects at a time, it may be best to use Excel for your status report. This article explains the benefits of creating a status report with Excel and gives an example that you can turn into a template. Why use Excel for your Status Report If you ...http://www.brighthub.com/office/project-management/articles/31029.aspxWed, 01 Apr 2009 02:42:42 GMTb133e95a-c263-4882-8f2a-b24547eff78e:31029wrtsister2It absolutely is possible to achieve consistent, organized project planning utilizing an older software application such as Excel. Read on for help. Why Use Excel? Many project managers favor using Excel because it is a familiar, comfortable tool. The manager maintains focus on the parameters of the job or jobs at hand without the distraction o...http://www.brighthub.com/office/project-management/media/p/30534.aspxThu, 20 Aug 2009 09:30:30 GMTb133e95a-c263-4882-8f2a-b24547eff78e:30534wrtsister2For project management, this Excel workbook is already formatted to calculate your time, fiscal, and staffing usage. As you enter dates and amounts in the primary worksheet, charts in additional worksheets become populated with your data, and you are prompted to identify basic information relevant to your project. For more information on how to use...http://www.brighthub.com/office/project-management/articles/29707.aspxSun, 22 Mar 2009 15:41:48 GMTb133e95a-c263-4882-8f2a-b24547eff78e:29707RondaRobertsThis is a simple, how to article directing readers to the specifics of creating a WBS in Excel. Prelimminary Step - Decompose the Project Before you begin to create your Work Breakdown Structure (WBS) in Microsoft Excel, you should first decompose your project. Decomposing your project means identifying deliverables, and breaking each deliverable d...http://www.brighthub.com/office/project-management/articles/28601.aspxSun, 08 Mar 2009 22:16:39 GMTb133e95a-c263-4882-8f2a-b24547eff78e:28601mmcdonoughIn the second part of this series looking at Six Sigma histograms, we'll show how to construct a chart of this type in Microsoft Excel 2007. Constructing a Histogram in Excel In Part 1 of this series, we gave a little background on how histograms are used in the Six Sigma quality process and described how to prepare the data for graphing. Now, ...http://www.brighthub.com/office/project-management/articles/28364.aspxThu, 05 Mar 2009 13:56:53 GMTb133e95a-c263-4882-8f2a-b24547eff78e:28364mmcdonoughWhen analyzing data in the Six Sigma quality process, a histogram can be used as a valuable tool. In the opening segment of this series, we'll discuss the usage of this type of chart and how to prepare the data that is to be represented in the histogram. Histograms and Six Sigma The gathering and analysis of data is a key aspect of the Six Sigm...http://www.brighthub.com/office/project-management/reviews/27026.aspxWed, 04 Mar 2009 19:57:45 GMTb133e95a-c263-4882-8f2a-b24547eff78e:27026mmcdonoughAre you looking for an inexpensive task scheduling application that will work in conjunction with Microsoft Office? This Excel add-in could save you a lot of time and money. Read on to find out more. Overview of Project Manager for Excel Version 3.2b Project Manager for Excel is a task management system that operates as an add-in for Microsoft ...http://www.brighthub.com/office/project-management/media/p/28181.aspxThu, 20 Aug 2009 10:13:31 GMTb133e95a-c263-4882-8f2a-b24547eff78e:28181mmcdonoughThis Excel 2007 histogram template is described in Michele McDonough's Microsoft Excel Six Sigma Histogram series. Feel free to download the file for your own personal use, and be sure to check out the two articles for a more detailed description of the histogram creation process.http://www.brighthub.com/office/project-management/articles/7638.aspxTue, 24 Feb 2009 21:07:29 GMTb133e95a-c263-4882-8f2a-b24547eff78e:7638NacieOne of the best features of the Microsoft Office product suite is the ability to integrate different data formats together easily and efficiently. If you have data in Excel format you want to turn into a Microsoft Office Project plan then read on to discover the best way to do so. Many project plans often start as spreadsheets assembled in Microsof...http://www.brighthub.com/office/project-management/articles/5789.aspxWed, 12 Nov 2008 15:52:34 GMTb133e95a-c263-4882-8f2a-b24547eff78e:5789dchiarella56This article introduces the reader to three software project management tools. Software tools for project management are called “Upper CASE” tools. CASE means C omputer A ided S oftware E ngineering. This article discusses three important types of project management software tools that are indispensable to the modern project and program manager. Ea...