ideas Category
Date with my sheet - 10 tips on using date / time in excel

Excel date time features are very handy and knowing them a little in depth can help you save a ton of time in your day to day spreadsheet chores. Let us prepare for your date with the sheet using these 10 handy tips.
Before jumping on to the tips, it helps to know how excel represents [...]
5 wonderful visualizations you must see [Aug 22]
Every week Pointy Haired Dilbert celebrates the art of chart making by sharing 5 of the most beautiful, innovative and effective infographic ideas from various sites. Click here to see the visualizations featured earlier.
Pop, Soda or Coke? - Countywise terms used for sweetened carbonated water
The pop-vs-soda map tells how marketers have been effective and creating [...]
Read More >>Tiger Woods walks on water to please a fan - Awesome advertising
By Chandoo at 21 August, 2008, 8:04 pm | 0 Comments
Look at the power of conversation. A fan posted on youtube showing an apparent glitch in Tiger Woods 08 video game that you can walk on water to hit a golf ball. What did Electronic Arts and Tiger Woods do? They post a response to that video advertising Tiger Woods 09 saying that “its not [...]
Read More >>Display symbols in excel chart axis
By Chandoo at 21 August, 2008, 6:14 pm | 6 Comments

Here is a quick excel tip to make your charts look professional by showing symbols in the axis labels instead of text.
Just follow these 4 simple steps:
First identify the symbols you want to show on the axis or as data label from symbol fonts like webdings, wingdings or a custom dingbat font like company [...]
Read More >>Creating KPI Dashboards in Microsoft Excel [Part 1 of 4]
By Chandoo at 20 August, 2008, 5:31 pm | 16 Comments
Creating KPI Dashboards in Microsoft Excel is a series of 4 posts by Robert from Munich, Germany. Robert has been using excel for last 18 years starting with MS Excel version 3.0 in 1990. He has huge passion for data visualization and presentation using excel. When I got a mail from him 2 weeks back [...]
Read More >>It is show time baby! - better designer clocks to display time in your spreadsheets

My polar clock using donut charts in excel started a conversation and readers have been awesome enough to download the excel and create their own clocks to show time. Even though the idea of this blog is share the little that I know with you, it is amazing how much I have learned from you [...]
Read More >>Excel Links of the week - What do you dream about? [Aug 19]
By Chandoo at 19 August, 2008, 10:42 am | 0 Comments
The other day my wife told me that we dream about a total of 6 years in our life, an average of 2 hours for everyday you sleep. [Source: wikipedia on dreams]. That is almost as much time as you would work in 30 years (30*50*40/24/365, assuming you work 40 hours a week for 50 [...]
Read More >>