Most of us don’t struggle with Excel because the math is hard — we struggle because the data is complex. Text responses, mixed data types, evolving categories, and the need to work across teams and stakeholders all push Excel beyond “rows and columns.” This Visitors Studies Association workshop can help up your game.
Date: Monday, March 16, 2026
Time: 12 p.m. ET
Location:Online
Price: $45 for non-members
What You’ll Learn
How to:
- “Templat-ize” your work. Turn repeated tasks into efficient, reusable tools for yourself and your team.
2. Combine formulas for multi-step transformations. Clean, reshape, and prepare messy text and mixed data so it becomes analyzable.
3. Build extendable systems. Create setups that automatically adapt as new data is added.
4. Handle qualitative data well in Excel. Explore what’s possible with text data, coding categories, and structured meaning-making.
5. Do flexible, grouped analysis. Compare patterns across variables (e.g., role, site, program, demographic, or theme) and create new analytic categories on the fly.
6. Level up your Pivot Tables. Make them more dynamic, interactive, and useful for exploration and reporting.
7. Pull data across sources. Use VLOOKUP and XLOOKUP to connect datasets and enrich your analysis.
8. Prepare data for visualization. Structure and summarize data to feed cleanly into charts, tables, and dashboards.
9. Add interactivity. Use data validation, dropdowns, and simple forms to support collaborative analysis and coding.
For more information on who this workshop is for (along with recommended skills participants should have), visit the registration link below.
