Sales Funnel Charts in Excel – Tutorial
Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that project report.
Automatically insert timestamps in excel sheet using formulas
Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate timestamps.
Excel Basics – What are Combination Charts and How to Make One?
A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph combination.
Great News: Chandoo becomes MVP
I have received 2009 Microsoft MVP Award.
The award is presented for Excel community contributions made in the past and includes a complimentary subscription to MSDN (and or Technet). It is a great feeling to know about this.
I am very thankful to this site and all the things I could learn and share through it. Special thanks to the anonymous MVP for nominating my name.
Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]
Here is a very quick spreadcheat for the new year.
If you need to select all the cells in a series (either row-wise or or in columns) you can use one of these 2 shortcuts (and avoid unnecessary scrolling)
1. Select the first cell in the series
2. Press Shift + Ctrl + Down arrow
Or
1. Select the first cell in the series
2. Hold down SHIFT and Double click on the edge of cell in the direction you want to select
Excel 2007 Review – 10 things that WOWed me
After a really long wait finally I have used … Excel 2007 (drum roll) and contrary to what many people think, I have found Excel 2007 to be a very well designed piece of software. Of course there are various issues with it and I am sure folks at MS are working on them so that next versions of MS Office are much more pleasant and simpler to use.
I wanted to share 10 wow factors in Excel 2007 that may convince you to try it.
Excel Links of the week – the Christmas edition
It is the holiday week, that means less posts and more fun. We went to a friend’s wedding yesterday and had wonderful time. We are planning to celebrate Christmas at home with friends this year. How are you celebrating the holidays this year?