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 »

Presenting Data While Working Remotely: Audio, Lighting, and Speaking Tips

Mar 31st, 2020 / Data Visualization
I recently had the chance to talk with my friend Jon Schwabish of PolicyViz. Our latest conversation was part of the Urban Institute’s Data@Urban Digital Discussions series. The intention of these talks are to connect with each other while we’re all social distancing. In it we discuss my work at home setup, my top three tips for presenting data over video calls and lessons learned from teaching online courses.
More »

Upping Your Reporting Game–with PowerPoint!

Feb 4th, 2020 / Data Visualization
Today’s guest blog post comes from Ann Webb Price who has been a program evaluator for more than 20 years. She shares how she’s creating usable reports that accurately report evaluation findings in a way that engages clients, supports program improvement, and promotes organizational learning.
More »

Three Ways Intentional Data Viz Has Elevated My Work

Sep 26th, 2019 / Data Visualization, Reports
Are your dot plots due for an update? Do they depict the data in a positive and easy-to-understand way? Kathy Dowell shares how to spruce up your dot plots so that your audience is engaged and going away informed. She highlights that your report cover makes all the difference in engaging your audience or your report landing on a shelf unread. Kathy, a student of Ann’s, shares how being enrolled in Ann’s courses was just the inspiration she needed to take her work to the next level.
More »