Archive for Data Analysis - page 3

=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 →

Pivot Tables: Your Tool for Exposing Miscreant Data

Pivot Tables: Your Tool for Exposing Miscreant Data

Thank you, Ann Emery and thanks especially to the visitors of AnnKEmery.com. It meant a lot to be asked to do a guest blogpost because Ann’s approach is practical, focused on real-world experience, and her dedication to empowerment of others is a key theme at my own…

Continue reading →

Page 3 of 3 1 2 3