Excel is one of the most powerful tools for data analysis, but it can be overwhelming for beginners. That’s why we’ve developed a beginner-friendly workshop tailored to help you master Excel’s essential features and functions. Whether you’re looking to boost your productivity, start a career in data analysis, or refine your skills, this two-part workshop will provide you with the solid foundation you need.

Our expert instructors have years of experience working with Excel and will guide you step-by-step through its most important tools. You’ll gain hands-on experience using real-world datasets and scenarios, ensuring you can apply your skills in practical settings.

 

What You’ll Learn

• Summarizing Data with PivotTables and PivotCharts: Learn to quickly summarize and visualize your data, providing insights at a glance.

• Formulas for Aggregation: Master essential formulas like SUM, SUMIF, COUNT, and COUNTIF to effectively aggregate and organize data.

• Data Visualizations: Create and customize data visualizations that turn raw data into meaningful, actionable insights.

• Data Cleaning Techniques: Use formulas and conditional formatting to clean and prepare your data for analysis.

• Advanced Functions (XLOOKUP): Combine datasets and streamline your data workflows using advanced Excel functions like XLOOKUP.

 

What You’ll Get

• 5+ hours of pre-recorded content divided into learning modules, so you can learn at a time and pace that works best for you

• Practice exercises

• Live support via an Office Hours session the week the class is released

• Lifetime access to the learning community Q+A Board, where you can give and receive data analytics support from your peers

• A Certificate of Completion

• Access to the workshop videos and materials for at least one month (longer if you join as a Silver, Gold, or Platinum Tier member!)

• Silver, Gold, and Platinum Tier members will also unlock access to our Learning Community, our dynamic, member-only support system designed to help you integrate new skills into your work through features such as weekly office hours, monthly skill sprints, a Q+A board, quarterly webinars, and exclusive access to uncut recordings on the Data Jam Podcast.

 

How it Works

The next blended delivery of this workshop will be the week of March 2, 2025. All materials will be released on Sunday. Then, join us for a live office hours session on Friday from 3-4pm EST where we will address any questions you have.

 

Why You Should Attend

This workshop is ideal for evaluators, researchers, and program managers responsible for measuring program success. Whether you’re looking to refine your outcome measurement skills or tackle complex evaluation designs, this session will provide you with the knowledge and confidence to assess program impact effectively.

With hands-on activities and real-world scenarios, you’ll leave equipped to measure outcomes, communicate results, and ensure accountability. Join us to elevate your evaluation practice and demonstrate program value.

 

What Past Participants Are Saying

• “This course gave me the tools to ensure my evaluations are both ethical and inclusive. It’s a must for anyone working with diverse populations.”

• “The focus on QuantCrit opened my eyes to new ways of thinking about data ethics. I feel much more equipped to handle sensitive data.”