Waterfall Charts using Excel
Learn how to create waterfall charts in Excel in this tutorial. Our guest author, Aaron, explains how to create cool looking waterfall charts with connectors. Waterfall charts are great, especially for visually showing the contribution of parts to a whole.
Excel Time Sheets and Resource Management [Project Management using Excel – Part 4 of 6]
Timesheets are like TPS reports of any project. Team members think of them as an annoying activity. For managers, timesheets are a vital component to understand how team is working and where the effort is going. By using Microsoft Excel capabilities you can create a truly remarkable timesheet tracking tool.
In this installment of project management using excel series, we will learn 3 things about timesheets and resource management using Excel
1. How to setup a simple timesheet template in excel?
2. How to make a more robust timesheet tracker tool in Excel?
3. How to use the timesheet data to make a resource loading chart?
Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)
In this installment of spreadcheats, we will learn how to use goal seek feature of excel. We will build a retirement savings calculator using excel. We will learn to use Excel’s FV() formula to estimate the corpus that can be accumulated by saving fixed amount every month.
Charting Lessons from Optical Illusions
The other day while doing aimless roaming on the dotcom alley, I have seen some cool optical illusions. There are so many valuable lessons optical illusions can teach us – chart makers. Don’t believe me? Look at the bubble chart illusion on the left and tell me which orange circle is bigger? What is your answer? Right or left. Well, my friend, the answer is both are of same size. Read the rest of this post to find some cool optical illusions and what they can teach us – chart makers.
Project Management: Show Milestones in a Timeline [Part 3 of 6]
Learn how to create a timeline chart in excel to display the progress of your project. Timelines are a good way to communicate about the project status to new team members and stake holders. Also, download the excel timeline chart template and make your own timeline charts.
Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
In today’s installment of project management using excel, we will learn about project tracking tool – to-do lists. Projects are nothing but a group of people getting together and achieving an objective – like building system or constructing a bridge. While it is important to have a overall project plan and vision, it is equally important to understand how various day to day project activities are going on. This is where to do lists can help you a lot. Read on…
Gantt Charts – Project Management Using Excel [Part 1 of 6]
This is a 6 part tutorial on project management using microsoft excel. These posts represent few of the things related to project management using excel that I have learned over the years. The first installment deals with Preparing & tracking a project plan using Gantt Charts in MS Excel.
The other parts I am planning are, Day to day operations – using to do lists, Preparing a project time line, Time sheets and Resource management, Tracking issues and risks, Project Status Reporting – Dashboard.
Read the first part of the article to learn how to make excel gantt charts / project plans.