Google Sheets For School Leaders - 200 Level
 

Intermediate Skills in Google Sheets
What you'll learn
Intermediate Google Sheets formulas, including dynamic data management
FILTER, INDIRECT, UNIQUE, SORT, ARRAYFORMULA, IMPORTRANGE formulas.
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.
Requirements
Basics of Google Sheet syntax, including Boolean operators, sheet and cell referencing, and Sheets navigation.
Level 100 course recommended before taking this course.
Description
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 take your Google Sheets data management to the next level by focusing on FORMULAS and tricks that will help you make your data update dynamically as adjustments in student data occurs at the school. If you need to work on the basics of Google Sheets, I recommend my 100 Level course first before taking this course.In this course, you will learn:FILTER and INDIRECTMove data from one sheet to another without having to copy and paste!UNIQUE and SORTManipulate data from one place to another, removing duplicates or rearranging automatically.ARRAYS and ARRAYFORMULAModify data on the fly, and write one formula to be run repeatedly on a whole set of data. No more copying formulas all the way to the bottom of a table!IMPORTRANGECopy data over from a completely different Google Sheet in your, or someone else's, Google Drive!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.
Who this course is for
School leaders who use student and teacher data to help make decisions and manage their school.
Principal
Assistant Principal, AP
Instructional Coach
Homepage