Spreadsheet Skills Tune-Up

Messy walk lists, broken formulas, and phone numbers that won’t format right shouldn’t slow your campaign down. This video tutorial and practice sheet walk you through the Google Sheets skills campaign staff use most, from locking cells and building your first formulas to drop-downs, cleaning up messy data, and VLOOKUP. You’ll also learn Arena’s gold standard for building sheets your whole team can use. Make a copy of the practice sheet and follow along at your own pace.

In this tool, you’ll find:

• A video tutorial covering spreadsheet basics, formulas, and locked cell references
• How to build sheets your team can use, following Arena’s gold standard for tab structure and design
• Step-by-step guidance on drop-downs, checkboxes, and protecting sheets so data stays clean
• Quick fixes for messy data, including names, phone numbers, zip codes, dates, and currency
• An introduction to VLOOKUP for matching data across lists
• A practice sheet with exercises for every skill, so you can follow along

Pause it and slow it down or skip through it as needed.

By Myra Mills Tschirhart