Posts Tagged ‘dynamic ranges’

Excel Dynamic Named Ranges = Never Manually Updating Your Charts

17th August 2010 by Tim Wilson No Comments

I’ve had a pretty good run of theoretical posts about the nature of marketing measurement of late, so it seemed like I was due for a more down-in-the-weeds-Excel-efficiency-tactics write-up.  This blog isn’t really focussed on all of the myriad ways that Excel can be contorted to represent data effectively, but I’m a big believer in [...]

Calculating Trend Indicators

5th October 2009 by Tim Wilson 7 Comments

Put this down as one of my more tactical posts, brought on by a fit of lingering annoyance with the use (and by “use” I mean “grotesque misuse”) of trend indicators on reports and dashboards. The trouble is that trends are a trickier business than they seem at first blush, and, at the same time, [...]