Blog Archives
Excel Dynamic Named Ranges = Never Manually Updating Your Charts August 17, 2010 Excel Tips

[This post was written in 2010. I’ve made a new version of the post that takes advantage of Excel tables, which simplified the process a bit (it’s still kinda’ complicated). ...... Continue »

Answering the "Why doesn't the data match?" Question May 18, 2010 Analysis

Anyone who has been working with web analytics for more than a week or two has inevitably asked or been asked to explain why two different numbers that “should” match ...... Continue »