Tag archive for Microsoft Excel

Revamping a Tired Data Table: A ‘Before’ and ‘After’ Reveal

Revamping a Tired Data Table: A ‘Before’ and ‘After’ Reveal

I met Mia Schmid in 2017 when she enrolled in one of my Dashboard Design workshops. Later, she reached out and shared her own before/after makeover based on what she learned in the training. Her makeover was so dramatic that I wanted to share it…

Continue reading →

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 →

How to Visualize Workshop Evaluation Results

How to Visualize Workshop Evaluation Results

I give dozens of workshops, webinars, and conference keynotes each year. Which means I receive dozens of evaluation surveys each year. After my sessions, the clients who sponsored the workshop ask their participants to rate my session. Sometimes the satisfaction surveys are electronic. Other times, the satisfaction…

Continue reading →

Page 1 of 7 1 2 3 4 5 ... Last →