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 »

=vlookup(): One Excel function to rule them all

Jul 9th, 2014 / Data Analysis
I’m celebrating 100,000 YouTube views with an article on my favorite spreadsheet function: vlookup! Vlookup is for merging and combining datasets, like when you’ve got program participants’ demographic data in one place and their scores or outcomes in another place. 
More »