I teach about data visualization a lot. And it basically comes down to two techniques: simplification and emphasis. Here’s a default graph with fictional data: First, simplify the graph. Remove the border. Remove the horizontal grid lines. Remove the vertical axis. Remove the legend. Remove…
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…
Have a spreadsheet full of employee contact information? Demographic data for people in your community? A list of classmates attending that upcoming reunion? Most of our spreadsheets contain peoples’ names at some point in the project lifecycle. Here are a few shortcuts for dealing with text…
I’m leading a full-day data visualization workshop prior to the American Evaluation Association’s annual meeting in Chicago, IL.
I’m leading a full-day data analysis workshop prior to the American Evaluation Association’s annual meeting in Chicago, IL.
I’m leading a four-part webinar series this August and September 2015 in partnership with Data Analysts for Social Good. In this fourth and final webinar, I’ll teach you about lesser-known charting secrets within Excel, like Change Chart Type, Switch Row/Column, and Reducing Gap Width. Then we’ll dive into advanced chart construction to build graphs that aren’t traditionally available within Excel, like small multiples layouts, slope graphs, and dot plots.
If you use spreadsheets on a daily basis, this post isn’t for you. Within the past year I’ve led 61 trainings (and counting!) about both data analysis/statistics and data visualization. In each session, there’s one person who’s enthusiastically eager to learn but has almost zero experience…
On August 26, 2015, I’m leading an online workshop exclusively for members of Emerging Practitioners in Philanthropy.
Does your file include any dates? If so, check out these simple formatting tips so that your dates are displayed in the style you want. Selecting Your Preferred Date Format If your spreadsheet contains dates, you can select either the Short Date or Long Date…
On May 11, 2015, I’m leading a half-day data visualization workshop that’s geared towards researchers, evaluators, and other social scientists. This workshop is hosted by RTP Evaluators but is open to everyone, both members and non-members. Join us in Durham, North Carolina!