Excel Project Management - FREE Templates, Resources, Guides & Information
Project Management is one of my favorite topics. In my earlier job I have been part of several projects and in almost all of them, we have used Microsoft Excel heavily to perform various project management tasks. In this page you can find some resources, help and articles on Project Management using MS Excel. Click on the links to access relevant section: Gantt Charts & Project Planning using MS Excel A Gantt Chart is a traditional way to prepare and track a project plan.
Gantt Charts, Completion Plans and Planning your Research
Currently Under Review As a student you are required to deliver an updated Gantt chart or a Completion plan as part of the formal review Milestones of your candidature to illustrate the various stages and activities of research in candidature, from commencement to completion. A Gantt chart helps you plan your activities, communicate with your supervisory team and the University, and helps you keep track of your progress.
Critical Path Method (CPM) Spreadsheet - PERT Algorithm
The Critical Path Method (CPM) provides a way for project managers to determine which tasks are critical (zero slack time) and which tasks can be delayed (and for how long). Normally, you'd need specialized software such as MS Project. Not any more.
Action Plans - Project Management Tools from MindTools
Small Scale Planning Simple projects can be completed with simple plans. © iStockphoto/AndrewJohnson Whether it's sending out an email newsletter, putting together a presentation for senior managers, or working on a special request for a client, many of us have to complete simple projects as part of our day-to-day responsibilities. These small- to medium-sized projects may, at first glance, not seem to need much thought. But, occasionally, we can overlook a key step or "to do" item that can derail all our efforts.
Excellent Rubric for Using Digital Portfolios in Class
December 22, 2014 Planning to integrate digital portfolios in your instruction? This list of tools is a good place to start with. It contains some useful web applications that you and your students can use to easily create e-portfolios. Using e-portfolios with your students has several educational pluses that include:
Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]
Posted on July 2nd, 2009 in Charts and Graphs , Excel Howtos - 8 comments Two most commonly asked or searched queries when it comes to charting are, How to combine two chart types in one chart, like a line chart combined with bar chart?How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis? Excel combination charts are a great way to combine two chart types in to one.
Use this Free Gantt Chart Excel Template
How to Easily Make a Gantt Chart in Excel Excel was traditionally created to be a data analytics and number crunching tool, but 60% of spreadsheets today contain no formulas. Its usage has now evolved to serving as a project management tool. While you can coordinate basic work tasks and manage lists, creating a Gantt chart in Excel, from scratch, can be a time-consuming and frustrating task.
Critical Path Analysis and PERT - Project Management Skills from MindTools.com
Planning and Scheduling More Complex Projects Related variants: AOA or Activity-on-Arc Diagrams Multiple activities often feed into other activities. © iStockphoto/Cybernesco Critical Path Analysis and PERT are powerful tools that help you to schedule and manage complex projects.
Gantt Charts - Project Management Tools from MindTools
Planning and Scheduling Team Projects The following are trademarks: Gantto (see gantto.com), MatchWare (see www.matchware.com/en), Microsoft Excel, and Microsoft Project (see www.microsoft.com). We have no association or connection with these organizations.
