Tag archive for Microsoft Excel

Removing Redundancies from My Old Graphs

Removing Redundancies from My Old Graphs

This morning I keynoted a conference in Tallahassee. Data visualizers who critique others before critiquing themselves make me gag, so I opened my talk with a trip down memory lane. Check out this beauty from one of my earliest jobs. I’ve anonymized it but 99.9% of…

Continue reading →

The Simplification & Emphasis Approach to Editing Graphs

The Simplification & Emphasis Approach to Editing Graphs

I teach about data visualization a lot. And it basically comes down to two techniques: simplification and emphasis. Here’s a default graph with fictional data: First, simplify the graph. Remove the border. Remove the horizontal grid lines. Remove the vertical axis. Remove the legend. Remove…

Continue reading →

Sorting and Filtering Your Spreadsheets

Sorting and Filtering 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 →

Shortcuts for Formatting Peoples’ Names in Your Spreadsheets

Shortcuts for Formatting Peoples’ Names in Your Spreadsheets

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…

Continue reading →

The Absolute Beginner’s Guide to Spreadsheets

The Absolute Beginner’s Guide to Spreadsheets

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…

Continue reading →

Page 1 of 2 1 2