The Basics of Google Sheets
What you will learn
Basics of Google Sheets, including formulas and simple math.
Vlookup in Google Sheets
Using ARRAYFORMULA and QUERY in Google Sheets
Automating data analysis to generate actionable data.
Creating dynamic, updating data dashboards for you and your team.
Use Sheets to save hours of work each week as a school leader.
Why take this course?
Welcome to Sheets for School Leaders, a self-paced course for learning how to use Google Sheets as a school leader to make data-based decisions quicker, easier, and more effectively.
This course is designed to give you some of the basic functions of Google Sheets as an introduction to the course for school leaders. If you are a principal, assistant principal, instructional coach, dean, or work at the district offices, this course could be for you.
If you have experience in Google Sheets or Microsoft Excel, use this course as an introduction to the style of the Sheets for School Leaders series before trying the 200 or 300 level courses.
In this course, you will learn:
- Basic Math Functions
- Addition, subtraction, multiplication, division, SUM, AVERAGE, MIN, and MAX.
- IF…Then…Operators
- How to make your formulas responsive to the possible types and uses of Sheets data.
- VLOOKUP
- The most useful and important formula you will learn in Sheets.
- Syntax Basics and Rules
- Tips and tricks to make your work in Google Sheets easier and faster.
Each of these lessons includes:
- Video lesson with step-by-step instructions and explanations.
- Practice Google Sheet to follow along with the guided practice.
- Individual practice activity to test your understanding.
- Full transcripts of each lesson.
- Downloadable slide deck.