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 analysis workshop prior to the American Evaluation Association’s annual meeting in Chicago, IL.
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.
I bet you’ve got better things to do than fiddle with your spreadsheet for hours on end. And why rely on Excel’s default settings when you can easily format your spreadsheet to fit your exact preferences? There are numerous formatting adjustments you can make to…
Pivot tables are the fastest, easiest way to make sense of spreadsheets. Whether you spend 10% or 100% of your day working with data, pivot tables are a must-have spreadsheet skill. In this 90-minute webinar, you’ll learn how to: design your spreadsheet to be compatible…