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 [...]
Conditionally play sounds when a cell value changes
Blog reader Richard asks through email:
I’m a non-programing user of Excel. I import stock prices, using what is called ( I believe) a dde link, into my spreadsheets,from a trading program.
I would like to add a feature to my spreadsheets that, like conditional formatting, alerts me to a price change in a cell, but with [...]
Become a Dashboard Ninja with Bullet Graphs
By Chandoo at 21 July, 2008, 4:59 pm | 5 Comments
Bullet graphs provide an effective way to dashboard target vs. actual performance data, the bread and butter of corporate analytics.
Howmuchever effective they are, the sad truth is there is no one easy way to do them in excel. I have prepared a short tutorial that can make you a dashboard ninja without writing extensive [...]
Partition Charts - Continuation - [More visualization fun]
By Chandoo at 10 July, 2008, 3:35 pm | 2 Comments
![Partition Charts - Continuation - [More visualization fun]](http://chandoo.org/wp/wp-content/uploads/2008/07/partition-charts-in-excel-revisited-150x142.gif)
Jon @ Peltiertech has taken a critical look at the partition charts suggested yesterday. You can read his review of the partition charts here. One of the commenters on his site said,
Jon, the partition chart is not that bad. It just needs to be defragmented…
So I de-fragmented my partition chart, this time it [...]
Want to be an Excel Conditional Formatting Rock Star ? Read this
By Chandoo at 13 March, 2008, 8:50 pm | 69 Comments
Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs from bunch of raw data in default fonts to something truly professional and good looking. Better still, you dont even need to be a guru [...]
Read More >>
