Brush Up on Your Excel skills
Brush Up on Your Excel Skills
New OERC Blog posting! This is to let you know that a new OERC Blog article has become available. You can find this article online here. For simplicity’s sake, we’ve posted the article below:
“There’s probably a better way of doing this.” How many times have you muttered this statement while using Excel to analyze a database download or a spreadsheet of class evaluation data?
Or maybe you would like to try your hand at some of the hot new trends in data visualization, such as data dashboards or infographics, but find that your lack of familiarity with Excel holds you back.
Whether you are a novice or experienced Excel user, you should check out Emery Evaluation’s “Excel for Evaluation” web page (http://emeryevaluation.com/excel/) with its series of videos demonstrating efficient ways to use Excel for data analysis and reporting. These videos, created by Ann Emery, are 1-4 minutes long and demonstrate a single Excel function, such as the formula to recode data or a technique for merging data from two separate files. The videos do use the 2010 version of Excel, so if you are working with an earlier version, some of the videos may not directly apply. Her videos are organized around theÂ steps of good data analysis: importing your data, organizing and cleaning the data, recoding, looking for patterns, calculating statistics, and creating charts.
I’ve been using Excel since 1988, and I STILL always feel as though I’m taking the long way around to completing an analysis. These videos did confirm that I was, indeed, right. There are better ways to use Excel, and Emery’s videos show how.