Simple Spreadsheets (Mini Course)
Data Analysis Techniques, Spreadsheet Formulas, and Time-Savers for Busy Number-Crunchers
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.
In this course, I’ll share my favorite techniques for saving your precious time and energy. We’ll cover beginner, intermediate, and advanced number-crunching skills.
You’ll be on your way from spreadsheet stress to superstardom in no time.
What's included in this Mini Course?
I'm going to transform you into the analytics hero that your organization needs. Here's what's included to make that happen.
- 50 fast video lessons that you can watch anytime (the equivalent of my half-day Simple Spreadsheets workshop)
- Spreadsheets to download so you can follow along
- Discussion boards to ask questions and post your own work
- Weekly emails to cheer you on
- Lifetime access so you don't feel rushed
- Examples from a variety of industries (public health, youth development, education, juvenile justice, museums, and more)
50 Fast Video Lessons
You'll get instant access to 50 lessons--the equivalent of a half-day training. Lessons are intentionally short (just a few minutes each) so you can watch a lesson while you eat lunch.
Weekly Emails to Cheer You On
I know you’re going to skip straight to the juicy spreadsheet tricks, but I’m going to email you on Mondays around 11 am EST and pretend like we’re working through the course one module at a time.
3,907+ participants from around the globe
have already taken the leap into better reports, slideshows, dashboards, and infographics.
Ann K. Emery is an internationally-acclaimed speaker who equips organizations to get their data out of dusty spreadsheets and into real-world conversations.
Each year, she delivers over 100 keynotes, workshops, and webinars with the aim of equipping organizations to visualize data more effectively.
She has been invited to speak in 30 states and 10 countries; 4,400 people have enrolled in her online training academy; and she has consulted to 200 organizations, including the United Nations, Centers for Disease Control, and Harvard University.
She earned a Bachelor’s degree from the University of Virginia and a Master’s degree from George Mason University.
After traveling full-time as a digital nomad, Ann now resides in Florida along with her husband and three children.
"When I signed up for this course, I wasn’t sure if the challenge level was right… It’s just “Simple Spreadsheets” after all. Having completed the course now, challenge is the wrong measure. Instead, this is a chance to fill in all the little pieces that can make your work with spreadsheets more efficient and effective. The first half of the course gave me a number of strategic tips and connections among Excel’s many tools that I’ll be sure to use in my regular work flows. The second half of the course gives a nice overview of pivot tables for non-CPAs — how use them, why to use them, and when to use them. I’ve heard business people rave about them, but I’d never jumped in until I signed up for Simple Spreadsheets. I’m sure there is much more to learn, but this course provides the foundation to get started.
As with the other Depict Data Studio courses I’ve taken, Ann’s creative synthesis of software skills and data analysis principles came together to spark my own thinking about how to do my work more effectively. Her real-world examples from a range of her clients and from her own work as a business owner help to ground the lessons in reality. My experience over the years has been that getting really good at the software you use is more useful than being adequate at a buffet menu of software options. Simple Spreadsheets and Ann Emery's other courses help me to do just that.
- Bob Coulter, Missouri Botanical Garden
"I signed up for the mini course to learn about Pivot Tables. I've tried watching free videos and articles but never felt very confident using them. Ann's step-by-step approach peppered with real life examples plus helpful tricks and tips has made it easy to implement Pivot Tables in my own projects."
- Teresa Hulleman, Motivate Lab
"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