229 Results Found for "excel"
The Power of Combining Number Formatting and Conditional Formatting in Excel By Analytics Demystified on September 25, 2015

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 ... read more »

Using Excel to Count Text Occurrences By Analytics Demystified on January 19, 2015

[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. ... read more »

Excel Dropdowns Done Right By Analytics Demystified on November 5, 2014

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 ... read more »

10 Tips for Building a Dashboard in Excel By Analytics Demystified on October 19, 2014

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 ... read more »

10 Things You Should ALWAYS Do (or Not Do) in Excel By Analytics Demystified on February 16, 2014

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 ... read more »

Excel: Charting Averages without Adding Columns By Analytics Demystified on November 23, 2013

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 ... read more »

Excel Dynamic Named Ranges (w/ Tables) = Chart Automation By Analytics Demystified on 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. ... read more »

DAA Awards for Excellence: Thank You By Michele Kiss on April 18, 2013

On Tuesday, April 16, (almost all) my partners and I were lucky enough to attend the DAA Awards for Excellence Gala, held in San Francisco during the eMetrics Digital Marketing ... read more »

Converting a Date in Excel to Week, Bi-Week, Month, and More By Analytics Demystified on 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 ... read more »

Small Charts in Excel: Beyond Sparklines, Still Economical By Analytics Demystified on 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 ... read more »