Tag archive for How-To Tutorials - page 5

How to Quickly Visualize Patterns with Excel’s Data Bars

How to Quickly Visualize Patterns with Excel’s Data Bars

Data bars are miniature within-cell bar charts. I primarily use them to quickly explore patterns in my dataset. Sometimes I decide to make an actual bar chart of the data later on. Other times, I’m simply using these tiny charts to help my brain spot…

Continue reading →

Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips

Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips

I bet you’ve got better things to do than fiddle with your spreadsheet for hours on end. And why rely on Excel’s default settings when you can easily format your spreadsheet to fit your exact preferences? There are numerous formatting adjustments you can make to…

Continue reading →

How to Make a Heat Table in Excel

How to Make a Heat Table in Excel

Just because I adore graphs doesn’t mean that I shun tables. I insert the occasional table inside the body of my report. Every report’s appendices are full of tables, tables, and more tables. When creating traditional tables, I follow the Dark Horse Analytics guide. When I’m…

Continue reading →

=vlookup(): One Excel function to rule them all

=vlookup(): One Excel function to rule them all

I’m celebrating 100,000 YouTube views with an article on my favorite spreadsheet function: vlookup! Vlookup is for merging and combining datasets, like when you’ve got program participants’ demographic data in one place and their scores or outcomes in another place. I can’t tell you how many…

Continue reading →

How to Make a Social Network Map with NodeXL

How to Make a Social Network Map with NodeXL

Note from Ann: Today’s guest post is from Johanna Morariu, Director of Innovation Network, AEA DVRTIG Chair, and dataviz aficionado. Basic social network analysis is something EVERYONE can do. So let’s try out one social network analysis tool, NodeXL, and take a peek at the…

Continue reading →

Page 5 of 6 ← First ... 2 3 4 5 6