Angela brought this dataset to Office Hours. (Office Hours are the live Q&As for my online courses.)
Angela had dozens of counties' crime statistics. Where should she start?!
Just as I was starting to record some ideas for Angela, my kindergartener got home from school, and knocked on my door for her afternoon hug. And then she asked to make the video with me. <3
Inside, you'll see us transform the raw data...
into cleaned and recoded data...
into a terrible default chart...
and, finally, into an accessible storytelling chart.
Data analysis is the foundation of data visualization.
In other words, you can't make great charts without great analytical skills.
In the YouTube video, you'll see me using an Excel Table; applying the =rank() function to narrow down what we'll show in the chart; and joining tables together with =xlookup().
If you're already teaching workshops about Excel functions (i.e., if you're an Excel Certification Trainer, like I used to be), then you don't need this course.
But if you're a beginner or intermediate spreadsheet user, this is the course for you!
A trusted data visualization leader for more than 10 years. On-site workshops for 25,000 researchers, evaluators, and scientists in 31 states and 11 countries. Online courses for 10,000 participants. 200 consulting clients. 5 kids. 1 frustrating 10k on Saturday morning.
