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.
Read More >>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?
Watch this video tutorial to learn how to do both in less than 15 seconds.
Watch it on youtube: Creating combination charts and adding secondary axis - video tutorial
Read More >>I am very happy to share this exciting news with you. June, 2009 has been the best month ever since I started this blog. We have received 239,000+ page views from 95,000+ visitors and our community had 800 new members. We now have 4,300+ of you have signed up for our RSS feeds and e-mail news letters. Read the post to find out more.
Read More >>
This column chart shows daily, weekly or monthly data depending on the user’s choice. In daily the columns are displayed properly, but in weekly & monthly mode the columns are a fraction of the width they should be - why, and how can this be avoided? Bonus points if you can describe how to use an INDIRECT formula on the x-axis labels which is another problem. Go fix it.
Read More >>Create a number sequence for each change in a column in excel [Quick Tip]
Here is a quick formula trick you can use to generate sequence numbers that only increment when there is a change.
Assuming the sequence of values are in column C from C3,
you can write the following formula in B4 onwards (B3 will be 1, wake up…)
=IF(C4=C3,B3,B3+1)
Now just copy paste the formula over the entire range [...]
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…
Read More >>In this edition of Excel Links, we feature a new excel blog on the blog, named bacon bits. We also share links about interesting articles like generating tinyurls using vba, making maps using xy charts, designing filters for your dashboards and more.
Read More >>It is very surprising that so many of us are still not aware of this extremely powerful tool in Excel 2007. Just with a click of the button, you can remove all the duplicate values from a list / table. To remove duplicates, (1) Just select the list of values from which you want to remove duplicates (2) Go to Data ribbon (3) Hit the Remove Duplicates button (4) Bingo…
Read More >>











