Tag archive for Spreadsheets

Explore Your Spreadsheets with Miniature At-a-Glance Graphs

Explore Your Spreadsheets with Miniature At-a-Glance Graphs

I worked in several university research centers before transitioning to applied settings. My favorite position was as a researcher in a longitudinal study of adolescent development. We followed the same cohort of ~175 participants from their preteen years through adulthood. This is and was a…

Continue reading →

Simple Spreadsheets: From Spreadsheet Stress to Superstardom in 12 Weeks

Simple Spreadsheets: From Spreadsheet Stress to Superstardom in 12 Weeks

This is one of the happiest days of my career. I’ve been running my own data design company for four years. And for four years, I’ve been itching to build online courses. I’ve delivered dozens of in-person workshops to thousands of people around the globe….

Continue reading →

How to Categorize Values in Your Dataset with If and Vlookup

How to Categorize Values in Your Dataset with If and Vlookup

Data visualization is fast and easy for me because I have a solid foundation in spreadsheet skills. I feel totally at home in spreadsheets. Nerd alert: I actually enjoyed doing taxes this year (and FINALLY finishing and getting a refund didn’t hurt, either). I initially…

Continue reading →

Save Time and Energy with Pivot Tables

Save Time and Energy with Pivot Tables

Pivot tables are the fastest, easiest way to make sense of your data, and they’re easier than you think. In this post, I’ll show you how to insert a pivot table and then drag and drop variables to find patterns in your spreadsheet. Step 1:…

Continue reading →

How to Sort and Filter Your Spreadsheets

How to Sort and Filter 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 →

Page 1 of 3 1 2 3