Learning Pass Exclusive

Gain access to this course and all other courses available in Learning Pass for one low annual subscription. You must be an EMA Member to enroll in Learning Pass.

Course curriculum

  • 1

    Getting Started

    • Read: Welcome to the Course & How It Will Work

    • Read: Excel vs. Google Sheets

    • Bonus: How to Copy or Download a File in Google Drive
  • 2

    Spreadsheet Basics

    • Read: It's All About Those Columns and Rows

    • Watch: Spreadsheet Basics

    • Watch: Mastering Basic Formulas

    • Watch: Mastering Advanced Formulas

    • Engage: Download the Sample Spreadsheet
  • 3

    Department Budget

    • Read: Why a Department Budget is Useful

    • Watch: How to Create a Department Budget

    • Engage: Download the Practice Budget
  • 4

    AOD Report

    • Read: Why an AOD Report is Useful

    • Watch: How to Create an AOD Report

    • Engage: Download the Sample AOD Report
  • 5

    T-Shirt / Uniform Order Form

    • Read: Why a T-Shirt Order Form is Helpful

    • Watch: How to Create a T-Shirt Order Form

    • Engage: Make a Copy of the Sample Order Form
  • 6

    Proof of Vaccination Tracker

    • Read: How to Create a Vaccine Tracker

    • Watch: How to Create a Vaccine Tracker

    • Engage: Download the Vaccine Declaration Form
  • 7

    Student Dashboard

    • Read: Why a Student Dashboard

    • Watch: Review Key Concepts for a Student Dashboard

    • Watch: Use 'Count' to Determine the Number of Students

    • Watch: Use 'CountA' to Determine the Number of Students

    • Watch: Use 'CountIf' to Determine the Number of 9th Graders

    • Watch: Use 'SumIf' to Calculate the Amount of Financial Aid by Class

    • Watch: Put It All Together to Create a Student Dashboard

    • Engage: Download the Practice Student Dashboard
  • 8

    Family Retention Tracker

    • Read: Why a Family Retention Tracker

    • Watch: How to Create a Family Retention Tracker

    • Engage: Download the Practice Tracker
  • 9

    Funnel Report

    • Read: Why a Funnel Report

    • Watch: Get Started with the Funnel Report

      FREE PREVIEW

    • Watch: Use 'CountIfS' to Count the Number of Kindergarten Inquiries

    • Watch: Lock Cells to Speed Up Your Work Using $ and the Fill Handle

    • Watch: Complete the Funnel Report

    • Engage: Download the Practice Report
  • 10

    Attrition Benchmark

    • Read: Why an Attrition Benchmark Chart

    • Watch: How to Create an Attrition Benchmark Chart

    • Watch: How to Calculate Attrition

    • Engage: Download the Attrition Benchmark Spreadsheet
  • 11

    Next-School Tracker

    • Read: Why a Next-School Tracker?

    • Watch: How to Make a Next-School Tracker

    • Watch: How to Calculate Student Info

    • Engage: Download the Next-School Tracker
  • 12

    What's Next?

    • Discussion Board: Suggest a Spreadsheet

    • Engage: Complete the Course Feedback Form