Intermediate Skills in Google Sheets
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.
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..
Course Content
- 200 – Advanced Math Formulas –> 1 lecture • 16min.
- 201 – FILTER and INDIRECT –> 1 lecture • 15min.
- 202 – UNIQUE and SORT –> 1 lecture • 12min.
- 203 – In-Line Arrays –> 1 lecture • 14min.
- 204 – ARRAYFORMULA –> 1 lecture • 17min.
Requirements
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 INDIRECT
- Move data from one sheet to another without having to copy and paste!
- UNIQUE and SORT
- Manipulate data from one place to another, removing duplicates or rearranging automatically.
- ARRAYS and ARRAYFORMULA
- Modify 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!
- IMPORTRANGE
- Copy 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.