Do you have a table of student data and need to lookup the guardian name for example? In this how to use XLOOKUP in Google Sheets Alice Keeler shows you how to return values in a table based on a look up value.
Category: Sheets
How to Create a Spreadsheet in Google
Spreadsheets can be made using Google tools. If you wan to know how to create a spreadsheet in Google here are some tips from the Queen of Spreadsheets Alice Keeler
Bingo Ice Breaker with Alice Keeler
Have fun with a Bingo Ice Breaker! Try out this free Add-on by Alice Keeler to create a fun activity to get students or participants up out of their seats and getting to know each other.
FASTER! Create Rubrics for Google Classroom
Rubrics for Google Classroom are slow to create and hard to reuse. Try GC Rubric by Alice Keeler to create faster and better rubrics for Google Classroom.
Fast – Add Student Birthdays to Google Calendar
Add multiple Google Calendar events at once. CalAdd by Alice Keeler makes it fast to add student birthdays to Google Calendar. Or any list of calendar events.
How to Lock Areas of a Google Doc
You want to restrict editing on PART of a Google Doc. This step by step guide will show you a hack for how to lock areas of a google doc.
For Goodness Sake Only Put In Once in Google Sheets
The Rule of One! Only Put In Once in Google Sheets!! Here is how to handle if you need something twice or more in a spreadsheet.
Grab a Spreadsheet Cell from Each Student
Finally! A way to grab a spreadsheet cell from individual student spreadsheets. This allows you to easily review all students responses to a question in one place.
How to Update Student Spreadsheets
You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is how to update student spreadsheets.
Something Fun for the End of the Year
What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my template!
Collaborate with Students – reuse TemplateTab
Reuse TemplateTab to collaborate with students and have less paperwork to grade.
COUNTA in Google Sheets™
How to use COUNTA in Google Sheets. This helpful formula works differently than COUNT. I will explain how.
How To Find Who Did NOT Fill Out the Google Form
How To Find Who Did NOT Fill Out the Google Form. It is easy to know who DID fill out the Form. It is hard to know who did NOT. Use this Alice Keeler Add-on to easily get a list of who is missing.
How to Randomize Range in Google Sheets
How to Randomize Range in Google Sheets. Built into Google Sheets is the ability to randomize a range without sorting the entire sheet. Alice Keeler shows you how.
5 Google Sheets Functions to Know
5 Google Sheets functions to know. Check out these 5 functions to help you to use Google Sheets even better!