Learn how to dive more deeply into Google Sheets. So many powerful ways to use sheets in your school and business. For more information go to https://gsuitepros.redtailfan.org/projects or enroll in https://www.redtailfan.com/

Apps script to sort the order of all your tabs in a sheet wither ascending or descending
2:25
Apps script to sort the order of all your tabs in a sheet wither ascending or descending
Updated version of Script to index all files and folders in a google drive folder
5:33
Updated version of Script to index all files and folders in a google drive folder
Email a PDF of the Active Sheet to anyone on the fly
5:49
Email a PDF of the Active Sheet to anyone on the fly
Use the new google chrome tabs GROUPS to organize and save important tabs
2:45
Use the new google chrome tabs GROUPS to organize and save important tabs
Using the MAP/LAMBDA function in a real use situation
3:34
Using the MAP/LAMBDA function in a real use situation
Edited version of the original Google Vids project on google notebooks
2:15
Edited version of the original Google Vids project on google notebooks
Google Vids Generated tutorial using an apps script prompt document - no editing done
2:20
Google Vids Generated tutorial using an apps script prompt document - no editing done
Apps script to create student notebooks that the teacher can update from a teacher master sheet
8:59
Apps script to create student notebooks that the teacher can update from a teacher master sheet
Use Apps script to remove all the timestamps from a ZOOM transcript recording to just have text
1:49
Use Apps script to remove all the timestamps from a ZOOM transcript recording to just have text
Using New Tables in google sheets formulas
10:11
Using New Tables in google sheets formulas
Apps Script To clean a list of phone numbers that are in different formats to import into a service
4:40
Apps Script To clean a list of phone numbers that are in different formats to import into a service
Apps script to build a chart on a sheet using data on the sheet to have a visual of the data
5:36
Apps script to build a chart on a sheet using data on the sheet to have a visual of the data
Enhanced Version 2 of Apps Script Based Reading Logs System
7:45
Enhanced Version 2 of Apps Script Based Reading Logs System
Apps script Reading Logs system for educators to collect reading data from students
21:27
Apps script Reading Logs system for educators to collect reading data from students
Use the 'SWITCH' formula with a 'QUERY' to make a dynamic dashboard to show Q1,This Year, Last Year
18:24
Use the 'SWITCH' formula with a 'QUERY' to make a dynamic dashboard to show Q1,This Year, Last Year
AppsScript to index all files in your google drive owned by you, name, URL,ID,etc,, saved to a sheet
3:58
AppsScript to index all files in your google drive owned by you, name, URL,ID,etc,, saved to a sheet
Limit the data source to use a pivot table and a pivot table group to summarize data from a form
3:51
Limit the data source to use a pivot table and a pivot table group to summarize data from a form
Use a special QUERY to summarize student data submitted on a form.
12:03
Use a special QUERY to summarize student data submitted on a form.
Sports Tracker - A tutorial on how you can build a Spreadsheet to track your volleyball practices
7:29
Sports Tracker - A tutorial on how you can build a Spreadsheet to track your volleyball practices
Use Special Formatting plus formula to calculate the next time based on the minutes entered
3:20
Use Special Formatting plus formula to calculate the next time based on the minutes entered
Using Apps Script to Update a Standards sheet on each student sheet that had an incorrect version
5:50
Using Apps Script to Update a Standards sheet on each student sheet that had an incorrect version
How to use Looker Studio to analyze data, share without sharing the sheet itself, charts and graphs
16:18
How to use Looker Studio to analyze data, share without sharing the sheet itself, charts and graphs
Create a new google doc in a folder, rename it, and replace an email placeholder in the doc
3:20
Create a new google doc in a folder, rename it, and replace an email placeholder in the doc
Add Google Sites Student Portfolios to Student Folders
13:55
Add Google Sites Student Portfolios to Student Folders
Make a timesheet to track your payroll, lot's of automations, apps script backup
4:39
Make a timesheet to track your payroll, lot's of automations, apps script backup
How to make custom Date formats in google sheets
7:12
How to make custom Date formats in google sheets
Classroom Attendance with Forms and Sheets and Fancy Formulas to track student attendance by month
8:56
Classroom Attendance with Forms and Sheets and Fancy Formulas to track student attendance by month
How dates are stored in google sheets
5:43
How dates are stored in google sheets
Use WORKDAYS, NETWORKDAYS, SEQUENCE, ARRAYFORMULA in Sheets to build workdays with single formula
6:19
Use WORKDAYS, NETWORKDAYS, SEQUENCE, ARRAYFORMULA in Sheets to build workdays with single formula
Teacher Goals and Evaluation System
16:17
Teacher Goals and Evaluation System