Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips
Jun 16th, 2015 / Data Analysis
I bet you’ve got better things to do than fiddle with your spreadsheet for hours on end. And why rely … more »
More »Blog
How to Adjust Your Bar Chart’s Spacing in Microsoft Excel
Jun 2nd, 2015 / Data Visualization
Wondering how to widen the bars in your bar or column chart? Or how to move the bars or columns … more »
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 … more »
More »Developing a One-Page Annual Report
Dec 23rd, 2014 / Data Visualization, Reports
At a recent Board of Directors meeting: “I think I’ll design a one-page annual report for the Washington Evaluators!” Draft … more »
More »The Best Visualization Tool of All Time
Dec 9th, 2014 / Data Visualization
It’s your brain. A few of the million+ decisions your software program can’t make for you: 10. Which chart is … more »
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 … more »
More »