...but related, since it concerns Data Visualisation.
Before you hit that charting button next time, you better take a look at these first!
Blogs
Moritz Stefaner
Infosthetics
Sites
What have I been listening to? from Lee Byron
America by Numbers
Excellent talk from Hans Rosling on 3rd world myths
Many of you will have wanted to use the COUNTIF and SUMIF functions on multiple columns but will have been annoyed about the necessity to introduce very long formulas or additional concatenation columns. This excellent hack allows you to perform COUNTIFs or SUMIFs on multiple columns using the SUMPRODUCT function. Credit to Charley Kyd over at ExcelUser for explaining this one:
SUMPRODUCT hack at ExcelUser
