Excel Tips
I have received a bunch of email the last few days from folks who have been directed to my Big Book of Key Performance Indicators and the companion spreadsheet. Since ...... Continue »
I build a lot of dashboards in Excel, and I’m a bit of a stickler when it comes to data visualization. This post walks through some of the ways that ...... Continue »
I use Adobe Report Builder a lot. It’s getting to the point where I have to periodically reassure my wife that my relationship with the tool is purely platonic. One of the ...... Continue »
[UPDATE 1/19/2015: A couple of comments have pointed out that COUNTIF would address this scenario in a single formula. That’s a great point…and one that had not occurred to me. ...... Continue »
Do you used in-cell dropdowns in your spreadsheets? I used them all the time. It’s both an ease-of-use and a data quality maneuver: clicking a dropdown is faster than typing ...... Continue »
This post has an unintentionally link bait-y post title, I realize. But, I did a quick thought experiment a few weeks ago after walking a client through the structure of ...... Continue »
Back in 2012, I developed an Excel worksheet that would take post-level data exported from Facebook Insights and do a little pivot tabling on it to generate some simple heat ...... Continue »
This post (the download, really — it’s not much of a post) is about dealing with exports from Facebook Insights. If that’s not something you do, skip it. Go back ...... Continue »
It was a fairly innocuous vent-via-Twitter tweet last week that inspired this post: I was surprised by the Twitter conversation it started, with several people noting that they had no idea ...... Continue »
I was recently building out a pretty involved dashboard where, ultimately, I had about 50 different metrics that were available through various drilldowns in Excel. Beyond just the number of ...... Continue »