Monthly archive for December2015

Sorting and Filtering Your Spreadsheets

Sorting and Filtering Your Spreadsheets

Have a list of words that need some alphabetizing? Have a list of numbers that you want to arrange from least to greatest or greatest to least? Rather than painstakingly rearranging your rows by hand, let Excel’s Sorting and Filtering features do the heavy lifting…

Continue reading →

One Dataset, Five Line Charts

One Dataset, Five Line Charts

I recently partnered with a group of public health researchers. We were brainstorming different ways to display the number of new HIV infections in each subgroup. The organization wanted to compare HIV infections among men who have sex with men (MSM), African Americans, Hispanics/Latinos, and injection…

Continue reading →

When Pie Charts Are Okay (Seriously)

When Pie Charts Are Okay (Seriously)

Within the past year, I’ve led 60+ in-person and virtual workshops for 2,800+ participants. Most of these trainings have focused on data visualization best practices and how-to’s; other topics have included dashboard automation, research methods, and data analysis. I can always tell when someone has…

Continue reading →