Google Sheets For School Leaders - 200 Level

[AD-TEAM]

Google Sheets For School Leaders - 200 Level
Published 12/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.59 GB | Duration: 1h 14m

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.

Overview

Section 1: 200 - Advanced Math Formulas

Lecture 1 200 - Advanced Math Formulas

Section 2: 201 - FILTER and INDIRECT

Lecture 2 FILTER and INDIRECT

Section 3: 202 - UNIQUE and SORT

Lecture 3 202 - UNIQUE and SORT

Section 4: 203 - In-Line Arrays

Lecture 4 203 - In-Line Arrays

Section 5: 204 - ARRAYFORMULA

Lecture 5 204 - ARRAYFORMULA

School leaders who use student and teacher data to help make decisions and manage their school.,Principal,Assistant Principal, AP,Instructional Coach

RapidGator

[To see links please register or login]

AlfaFile

[To see links please register or login]

TurboBit

[To see links please register or login]