24 Conditional Formatting Visuals in Microsoft Excel that Should Be Retired

“You should go work at Microsoft and fix Excel’s terrible formatting.” I can’t tell you how many times I’ve heard this from workshop participants. Bill Gates, are you reading this?? Microsoft Excel is lonnnnng overdue for some updates. Don’t get me wrong—it’s still my favorite program. With 750 million users worldwide, I won’t be switching to anything else. It’s used by every business professional I know for at least part of their workflow. I’m getting tired of making excuses for Microsoft. Here are 24 conditional formatting visuals that should be retired ASAP because they’re ableist, time-consuming to read, or look like they’re from 1995.
More »

How to Sketch, Doodle, and Draw Data Visualization Drafts by Hand

May 31st, 2016 / Data Visualization
Your job is to draw all the different versions of your dataset before you sit down to your computer. Draw, draw, draw. Aim for 5, 10, or 15 different types of graphs. The more you learn about data visualization, the more versions you’ll be able to draw. What would your dataset look like as a bar chart? As a stacked bar chart? A line graph? A pie chart? A tree map?
More »

How to Make a Heat Table in Microsoft Excel

Apr 14th, 2015 / Data Visualization
Just because I adore graphs doesn’t mean that I shun tables. I insert the occasional table inside the body of my report. When creating traditional tables, I follow the Dark Horse Analytics guide. When I’m presenting tables in a presentation, webinar, or full-color report, I create heat tables. Today I’m covering how to make a heat table in Microsoft Excel.
More »