Welcome to my free spreadsheet course for music teachers! Please use the links below to navigate the course.
Not sure where to start? Watch this quick one-minute intro video.
Learn how to quickly organize and narrow down large sets of student data. From attendance logs to instrument inventories, filters and sorting help you focus only on the information you need — and make tasks like emailing specific groups or tracking student participation much faster.
Turn messy spreadsheets into clear summaries. Pivot tables allow you to see big-picture trends at a glance — like instrumentation, how budgets are being spent, or your instrument inventory — without manually crunching numbers.
Formulas are the engine of every powerful spreadsheet. In this module, you’ll learn practical functions that every educator can use to save time and uncover insights:
Organize student information: join first/last names with AMPERSAND (&), fix capitalization with PROPER, or split full names into first and last names.
Work with numbers: Count all students with COUNTA, track attendance with COUNTIF, calculate budget totals with SUM, SUMIF and multiplication.
Use WEEKDAY to quickly find the dates for all your Wednesday jazz band rehearsals.
Personalize communication with ease. Learn how to merge data from a spreadsheet into Gmail, Microsoft Word, Canva, or Microsoft Outlook to send bulk customized certificates, emails, invitations, or letters — saving time while keeping the human touch.
Automatically color-codes patterns, such as absences, fundraising progress, or student performance so you can see trends instantly.
Keep your data clean and error-free. Learn how to create dropdown menus, restrict invalid entries, and standardize categories so your spreadsheets stay accurate and easy to use.
Small tricks that make a big difference. From freezing rows and alternating colors to inserting line breaks within cells, these simple tools make your spreadsheets more efficient and easier to read.
AI tools can now do much more than write essays — they can help teachers work smarter in spreadsheets. In this section, you’ll learn how to use AI to create formulas from plain English and create pivot tables.