Excel Dynamic Named Ranges (w/ Tables) = Chart Automation June 8, 2013

The single post on this blog that has, for several years now, consistently driven the most traffic to this site, is this one that I wrote almost three years ago. ...... Continue »

Converting a Date in Excel to Week, Bi-Week, Month, and More January 15, 2013

I often find myself getting data out of one system or another (or multiple systems, and then combining them) as “daily” data — a series of metrics by day for ...... Continue »

Small Charts in Excel: Beyond Sparklines, Still Economical January 1, 2013

I’m a fan of Stephen Few; pretty much, always have been, and, pretty much, always will be. When developing dashboards, reports, and analysis results, it’s not uncommon at all for ...... Continue »

Sorting with Formulas for Bounce Rate – Excel Tip October 24, 2012

During my career I have developed a ton of Excel tricks that enabled me to mold data just the way I like it. It all began when I took an ...... Continue »

Excel Tables — Overlooked, Yet Awesome July 2, 2012

Tables in Microsoft Excel are one of those features that you can be totally unaware of and get along without just fine. But, once you stumble across them, you wonder ...... Continue »

Facebook Status Updates: Exploring Optimal Timing February 14, 2012

NOTE: This post is no longer current. An updated version of the post, including an updated spreadsheet, is posted here. Although Facebook has unofficially admitted that there seems to be little ...... Continue »

Excel Dropdowns Done Right: Data Validation and Named Ranges May 10, 2011

NOTE: There is an updated version of this post posted here. I recommend reading that one rather than this one. Every once in a very rare while, I find myself not ...... Continue »

Excel Dynamic Named Ranges Redux — Multiple Series in One Chart March 14, 2011

In one of the more consistently popular posts I’ve written, I went into detail about how to set up charts that would update based on a value selected from a ...... Continue »

Data Visualization Tips and Concepts (Monish Datta calls it "stellar")* September 26, 2010

Columbus Web Analytics Wednesday was sponsored by Resource Interactive last week, and it was, as usual, a fun and engaging event: We tried a new venue — the Winking Lizard on ...... Continue »

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

[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 »