My passion is helping others make sense of their own data. A few years ago, I realized there are a ton of Excel tutorials on the internet--great!--but they were only geared towards accountants and economists. For people trying to create a home budgeting spreadsheet, they had tons of tutorials to choose from.
There weren't any tutorials for those of us trying to analyze data from research or evaluation projects. So, I set out to create my own tutorials for people like us.
Over the past five years, my collection of tutorials has grown to more than 60 videos and corresponding spreadsheets. My videos are short so you can watch one during your lunch break. I break everything into small steps. I want you to learn slowly and steadily so that you remember the new strategies forever.
If you become my Patreon, I'll walk you through the entire data analysis process:
- Importing and merging datasets (e.g., getting that SurveyMonkey or Zoomerang spreadsheet to load properly into your Excel file, or using advanced features like VLOOKUP or HLOOKUP to combine two spreadsheets into one);
- Housekeeping (getting your spreadsheet neat and organized into the appropriate columns, rows, and sheets);
- Cleaning and recoding (and other essential data-cleaning steps, like checking for duplicates and checking for missing data);
- Exploring (like using sparklines and conditional formatting to quickly scan your spreadsheet for interesting patterns);
- Pivot tables (to help you analyze data in the blink of an eye);
- Descriptive statistics (like means and standard deviations);
- Inferential statistics (like t-tests and p-values);
- Extra time-saving tricks (e.g., setting up a printer-friendly spreadsheet); and
- Advanced techniques (like creating dashboards using drop-down menus, countifs, and sumifs; or analyzing an entire spreadsheet full of survey data within just a few minutes).
Ann K. Emery