Brush Up On Your Excel Skills
If you do evaluation, you likely use Excel. So I recommend bookmarking this web page of short videos with excellent instructions and practical tips for analyzing data with Excel. Ann Emery produced these videos, most of which are 2-5 minutes long. Some cover the basics, such as how to calculate descriptive statistics. If you find pivot tables difficult to grasp, there’s a short video describing the different components. For the experienced user, there are videos about more advanced topics such as how to automate dashboards using Excel and Word.
Emery is an evaluator and data analyst with Innovation Network in Washington, DC. She has a special interest in data visualization and covers that and other topics in her blog, also available at her website.