Tag archive for Microsoft Excel

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 →

How to Make a Waffle Chart in Excel

How to Make a Waffle Chart in Excel

Waffle charts display part-to-whole patterns. They’re kind of like square versions of pie charts. I introduced them in an earlier post about visualizing survey results. Look familiar?   Here’s how to make waffle charts within good ol’ Excel. The first few steps are a little…

Continue reading →

How to Enter Your Custom Color Codes in Excel

How to Enter Your Custom Color Codes in Excel

If you want to look polished, then you have no other choice but to customize your visualization’s color palette. Don’t worry–customizing your colors is an easy low-hanging-fruit edit. Locate your style guide, scroll down to the color section, and decode the jargon. If you don’t…

Continue reading →

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