From Spreadsheet Stress to Superstardom. Data Analysis Techniques & Time-Saving Secrets for Busy Number-Crunchers.
Does this sound familiar?
"I’m after tips to help me represent statistics in a more appealing, understandable format."
"I work with a lot of data and struggle to figure out what data to focus/highlight and how to create a story with the data."
"I'm self-taught so a lot of what I'm struggling with is feeling like I'm spending more time than necessary on projects. I spend a lot of time looking at examples and then become overwhelmed with the information out there! I'm hoping to 'work smarter and faster not harder.'"
"I work with similar data sets over and over but feel like I do a lot of manual work in Excel."
"I would say that my projects are lacking a bit of organization and follow through. I am excited to learn how to use strategies to equip myself with the know how on how to deal with these problems when they arise."
"I am new and need to learn how to best present statistical data from spreadsheets into summaries that don't put folks to sleep."
Ever feel like you’re swimming upstream in data? Need to make sense of spreadsheets, but not sure where to start? Have a gut feeling that you’re not getting the most out of your data?
Spreadsheets aren’t just for statisticians, accountants, and economists. These days, most of us are using spreadsheets like Microsoft Excel, Google Sheets, or Apple Numbers for all types of projects at our jobs. Spreadsheets are massively powerful tools, and chances are, no matter what you’re working on, there’s a faster and easier way to get it done.
I’ll share my favorite techniques for saving your precious time and energy. We’ll cover beginner, intermediate, and advanced number-crunching skills from vlookup to pivot tables. We'll even cover basic data visualization skills, like designing new graphs and exporting them into other programs like Word or PowerPoint. You’ll be on your way from spreadsheet stress to superstardom in no time.
This course includes:
- 150 lessons delivered through 13 hours of video
- Optional monthly “office hours” webinars
- Optional 1-to-1 consultation with me about your individual project
- Downloadable spreadsheets, templates, & handouts
- Practical how-tos in Excel
- Examples from a variety of industries (public health, government, education, grantmaking, international development, hospitals, universities, and more)
- Special focus on using data in research and evaluation settings
- Year-long access to materials
I'm only offering the Simple Spreadsheets course once a year. When it's open, it's open! But when it's closed, it's closed. Enrollment is limited to just 50 students. You deserve one-on-one attention. The 2018 course sold out in two weeks!
Your data deserves to be out in the world--actionable, talked about, used--not gathering dust in spreadsheets. Let me transform your technical information for non-technical audiences. I've consulted to clients like the United Nations, State Department, and Centers for Disease Control, plus dozens more foundations, nonprofits, film companies, banks, hospitals, and universities worldwide. Each year, I lead dozens of in-person workshops for thousands of people. My online courses bring those skills to you, too.
StartLearn Spreadsheet Lingo (Tabs, Sheets, Rows, Columns, Cells, Workbooks) (3:34)
StartFormat Text (Bold, Italics, Underlines) (1:50)
StartFormat Colors (Fill Color, Font Color) (2:04)
StartAdd or Remove Gridlines and Borders (2:56)
StartInsert Images (Logos, Photos, etc.) (2:43)
StartInsert Icons* (13:01)
StartExplain Complicated Concepts with Diagrams (3:12)
StartInsert Hyperlinks (to Websites or Folders) (2:11)
StartAuto-Fill (123, abc, Jan Feb Mar)* (2:02)
StartDo Basic Math (Addition, Subtraction, Multiplication, and Division)* (3:58)
StartGet Started with Common Formulas (Average, Sum)* (3:54)
StartCheck the File Type (2:05)
StartGive the File a Descriptive Name (2:15)
StartGet Acquainted with the Dataset (7:09)
StartInsert New Sheets* (0:30)
StartDelete Sheets You No Longer Need (1:27)
StartHide and Unhide Sheets to Temporarily Remove Them from View (0:57)
StartRe-Name Sheets (2:48)
StartCode-Color Sheets (2:23)
StartPassword-Protect Sheets (4:42)
StartFreeze Panes* (6:51)
StartSort Data* (4:24)
StartFilter Data* (6:15)
StartRe-Size Your Column Widths and Row Heights (4:31)
StartWrap Text (2:17)
StartMake the Column Headers Stand Out (1:21)
StartSet Up Excel Tables (9:47)
"While I was taking Ann Emery’s course, I was given a large dataset that required hundreds of VLOOKUPs. Her mention of using F4 saved me multiple hours that would have been lost in manually inserting four dollar signs in each lookup. It is this type of time-saving tip that made her course most valuable for me. Even after using Excel professionally for 18 years, I learned more efficient ways to do almost everything that I’ve been doing, and plenty of new skills too. Now that the course is finished, what I value most is having a one-stop shop for Excel tips. No more google searching – I just go back to the course and refresh my memory with Ann’s short and to-the-point videos."
- Kristen Degan, Senior Associate - Monitoring and Evaluation, Sharp Insight, LLC
"The Simple Spreadsheets course provides the necessary skills for working professionals who need a solid understanding of data analysis in Excel, but don't have the time or desire for an overly technical course. This course is designed with users in mind, especially those with limited exposure or comfort with Excel. However, as someone who is quite comfortable working in Excel, I benefited from learning Ann's tips and tricks for organizing my spreadsheets and how to get the most out of Excel's features (e.g. conditional formatting, spark lines, pivot tables, etc.). In my current role, I provide support and training to 15 staff members across multiple countries and timezones on all areas of M&E. Data analysis has long been a skill that I've struggled to teach others, especially in a virtual format. After taking Ann's course I learned some cool new skills for myself, but better yet I learned how to walk others through an analysis project from start to finish -- from how to setup a spreadsheet, to data cleaning and recoding, to summarizing data with formulas, comparing variables with pivot tables, and finally how to present and share analyses. Ann's simple step-by-step approach has been tremendously useful in my work with others and I will continue to draw on what I learned for years to come. Thank you Ann!"
- Mia Schmid-Velasco, Monitoring & Evaluation Officer, Namati
"I am a university researcher and have a lot of familiarity with data collection and statistical analysis programs/platforms (e.g. SPSS, SAS, etc.), but needed a low-cost, widely-used data collection and analysis tool I could recommend and teach to the community partners with whom I conduct research. I have known for a long time that Excel was likely the solution to my problem, but could never find time to learn to use it, except in the most basic ways (sort, sum). Last summer, I took Ann Emery's Simple Spreadsheets course and dramatically improved my Excel acuity. *Plus* the course was fun, straightforward, and immediately useful. Having the modules available for a year meant that I could make up sessions I missed, and revisit material on which I needed refreshers. This course was more than worth the time and money I put into it, and I continue to learn and benefit from it (almost a year later). I highly recommend this course!"
- Sarah V. Suiter, Vanderbilt University
"I’ve known Ann for 10 years and in that time I’ve learned a lot from her. Her vision for turning text into something that a lay person would understand, visually, has been a life-saver. She has creative ideas that many organizations can turn into real world application. I’ve valued the trainings I’ve received from her and continue to learn new things in each class."
- Joyce Shelton, Senior Child Welfare and Education Operations Specialist, ICF
"Ann's course will be a real timesaver for independent evaluators, non-profits and public agencies alike! The logically organized videos show you step-by-step hacks and best practices for organizing and cleaning datasets. It covers all the tricks you wish you learned in grad school. I also appreciated Ann's encouraging demeanor and generosity in taking time to answer my questions. If you want to improve your data cleaning/management knowledge, invest in this course! Knowing how to use conditional formatting to create data bars and highlight duplications in my large dataset has saved me tons of time. Thanks Ann!"
- Robin Kipke, Evaluation Associate, University of California, Davis