Google Sheets Tutorials

@UChClppv1ewI-rme4-FilPGw - 648 subscribers

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 gsuitepros.redtailfan.org/projects or enroll in www.redtailfan.com/

Home Videos Live Playlists

Apps script based project to build an manage timesheets for staff

Apps script based project to build an manage timesheets for staff Google Sheets Tutorials

24 views - 6 months ago

Apps Script and special formulas to build a session scheduler - removes selected choices from form

Apps Script and special formulas to build a session scheduler - removes selected choices from form Google Sheets Tutorials

52 views - 8 months ago

Apps script to sort the order of all your tabs in a sheet wither ascending or descending

Apps script to sort the order of all your tabs in a sheet wither ascending or descending Google Sheets Tutorials

50 views - 9 months ago

Updated version of Script to index all files and folders in a google drive folder

Updated version of Script to index all files and folders in a google drive folder Google Sheets Tutorials

199 views - 9 months ago

Email a PDF of the Active Sheet to anyone on the fly

Email a PDF of the Active Sheet to anyone on the fly Google Sheets Tutorials

17 views - 9 months ago

Use the new google chrome tabs GROUPS to organize and save important tabs

Use the new google chrome tabs GROUPS to organize and save important tabs Google Sheets Tutorials

250 views - 9 months ago

Using the MAP/LAMBDA function in a real use situation

Using the MAP/LAMBDA function in a real use situation Google Sheets Tutorials

22 views - 9 months ago

Edited version of the original Google Vids project on google notebooks

Edited version of the original Google Vids project on google notebooks Google Sheets Tutorials

19 views - 10 months ago

Google Vids Generated tutorial using an apps script prompt document - no editing done

Google Vids Generated tutorial using an apps script prompt document - no editing done Google Sheets Tutorials

34 views - 10 months ago

Apps script to create student notebooks that the teacher can update from a teacher master sheet

Apps script to create student notebooks that the teacher can update from a teacher master sheet Google Sheets Tutorials

79 views - 10 months ago

Use Apps script to remove all the timestamps from a ZOOM transcript recording to just have text

Use Apps script to remove all the timestamps from a ZOOM transcript recording to just have text Google Sheets Tutorials

137 views - 1 year ago

Using New Tables in google sheets formulas

Using New Tables in google sheets formulas Google Sheets Tutorials

91 views - 1 year ago

Apps Script To clean a list of phone numbers that are in different formats to import into a service

Apps Script To clean a list of phone numbers that are in different formats to import into a service Google Sheets Tutorials

44 views - 1 year ago

Apps script to build a chart on a sheet using data on the sheet to have a visual of the data

Apps script to build a chart on a sheet using data on the sheet to have a visual of the data Google Sheets Tutorials

73 views - 1 year ago

Enhanced Version 2 of Apps Script Based Reading Logs System

Enhanced Version 2 of Apps Script Based Reading Logs System Google Sheets Tutorials

42 views - 1 year ago

Apps script Reading Logs system for educators to collect reading data from students

Apps script Reading Logs system for educators to collect reading data from students Google Sheets Tutorials

162 views - 1 year ago

Use the 'SWITCH' formula with a 'QUERY' to make a dynamic dashboard to show Q1,This Year, Last Year

Use the 'SWITCH' formula with a 'QUERY' to make a dynamic dashboard to show Q1,This Year, Last Year Google Sheets Tutorials

138 views - 1 year ago

AppsScript to index all files in your google drive owned by you, name, URL,ID,etc,, saved to a sheet

AppsScript to index all files in your google drive owned by you, name, URL,ID,etc,, saved to a sheet Google Sheets Tutorials

236 views - 1 year ago

Limit the data source to use a pivot table and a pivot table group to summarize data from a form

Limit the data source to use a pivot table and a pivot table group to summarize data from a form Google Sheets Tutorials

132 views - 1 year ago

Use a special QUERY to summarize student data submitted on a form.

Use a special QUERY to summarize student data submitted on a form. Google Sheets Tutorials

140 views - 1 year ago

Sports Tracker - A tutorial on how you can build a Spreadsheet to track your volleyball practices

Sports Tracker - A tutorial on how you can build a Spreadsheet to track your volleyball practices Google Sheets Tutorials

76 views - 1 year ago

Use Special Formatting plus formula to calculate the next time based on the minutes entered

Use Special Formatting plus formula to calculate the next time based on the minutes entered Google Sheets Tutorials

19 views - 1 year ago

Using Apps Script to Update a Standards sheet on each student sheet that had an incorrect version

Using Apps Script to Update a Standards sheet on each student sheet that had an incorrect version Google Sheets Tutorials

28 views - 1 year ago

How to use Looker Studio to analyze data, share without sharing the sheet itself, charts and graphs

How to use Looker Studio to analyze data, share without sharing the sheet itself, charts and graphs Google Sheets Tutorials

159 views - 1 year ago

Create a new google doc in a folder, rename it, and replace an email placeholder in the doc

Create a new google doc in a folder, rename it, and replace an email placeholder in the doc Google Sheets Tutorials

31 views - 1 year ago

Add Google Sites Student Portfolios to Student Folders

Add Google Sites Student Portfolios to Student Folders Google Sheets Tutorials

67 views - 1 year ago

Make a timesheet to track your payroll, lot's of automations, apps script backup

Make a timesheet to track your payroll, lot's of automations, apps script backup Google Sheets Tutorials

53 views - 1 year ago

How to make custom Date formats in google sheets

How to make custom Date formats in google sheets Google Sheets Tutorials

54 views - 1 year ago

Classroom Attendance with Forms and Sheets and Fancy Formulas to track student attendance by month

Classroom Attendance with Forms and Sheets and Fancy Formulas to track student attendance by month Google Sheets Tutorials

98 views - 1 year ago

How dates are stored in google sheets

How dates are stored in google sheets Google Sheets Tutorials

38 views - 1 year ago

Use WORKDAYS, NETWORKDAYS, SEQUENCE, ARRAYFORMULA in Sheets to build workdays with single formula

Use WORKDAYS, NETWORKDAYS, SEQUENCE, ARRAYFORMULA in Sheets to build workdays with single formula Google Sheets Tutorials

72 views - 1 year ago

Teacher Goals and Evaluation System

Teacher Goals and Evaluation System Google Sheets Tutorials

41 views - 1 year ago

MAP function Example to Eliminate need to copy down

MAP function Example to Eliminate need to copy down Google Sheets Tutorials

30 views - 1 year ago

Using the MAP function in google sheets with a custom function with a single formula

Using the MAP function in google sheets with a custom function with a single formula Google Sheets Tutorials

89 views - 1 year ago

Apps Script Based Travel Reimbursement Management System not using autocrat or Document Studio

Apps Script Based Travel Reimbursement Management System not using autocrat or Document Studio Google Sheets Tutorials

82 views - 1 year ago

Write Apps Scripts to save time formatting multiple sheets with column width, alignment, etc.

Write Apps Scripts to save time formatting multiple sheets with column width, alignment, etc. Google Sheets Tutorials

134 views - 1 year ago

Move and Remove selected rows from Sheet1 to Sheet2, sort sheet2 ascending when complete

Move and Remove selected rows from Sheet1 to Sheet2, sort sheet2 ascending when complete Google Sheets Tutorials

51 views - 1 year ago

Email Progress Report PDF to student parents directly from your gradebook, backup copy to sheet

Email Progress Report PDF to student parents directly from your gradebook, backup copy to sheet Google Sheets Tutorials

184 views - 1 year ago

Apps Script to export a Google Calendar to a sheet using a start date and end date

Apps Script to export a Google Calendar to a sheet using a start date and end date Google Sheets Tutorials

325 views - 1 year ago

Apps Script to build Teacher roster sheets from a master list of all students

Apps Script to build Teacher roster sheets from a master list of all students Google Sheets Tutorials

142 views - 1 year ago

Add a checkmark when a bill is paid

Add a checkmark when a bill is paid Google Sheets Tutorials

114 views - 1 year ago

Use Arrays instead of Ranges to build a query to make your query more error proof

Use Arrays instead of Ranges to build a query to make your query more error proof Google Sheets Tutorials

172 views - 1 year ago

Build a counter with google sheets and Apps Script and drawings

Build a counter with google sheets and Apps Script and drawings Google Sheets Tutorials

1.1K views - 1 year ago

Apps Script to Duplicate files and folders with a google sheet, rename files with student names

Apps Script to Duplicate files and folders with a google sheet, rename files with student names Google Sheets Tutorials

330 views - 1 year ago

Use AppsScript to append linefeeds and data to rows in a spreadsheet, saving hours of manual work

Use AppsScript to append linefeeds and data to rows in a spreadsheet, saving hours of manual work Google Sheets Tutorials

37 views - 1 year ago

Work Sample System

Work Sample System Google Sheets Tutorials

37 views - 1 year ago

Workflow system to create folders, move files into folders, track student work samples with files

Workflow system to create folders, move files into folders, track student work samples with files Google Sheets Tutorials

67 views - 1 year ago

Build a system to create google slides from a google Form

Build a system to create google slides from a google Form Google Sheets Tutorials

219 views - 1 year ago

Use APPS Script to batch convert all PDF files in a google Drive folder to a google docs format

Use APPS Script to batch convert all PDF files in a google Drive folder to a google docs format Google Sheets Tutorials

1.3K views - 1 year ago

Take advantage ot the LET Function with ARRAYFORMULA and VLOOKUP to simplify a complex IF formula

Take advantage ot the LET Function with ARRAYFORMULA and VLOOKUP to simplify a complex IF formula Google Sheets Tutorials

255 views - 1 year ago

Using Named Ranges in Data Validation Lists from ranges and in vlookup simpler than nested if syntax

Using Named Ranges in Data Validation Lists from ranges and in vlookup simpler than nested if syntax Google Sheets Tutorials

270 views - 1 year ago

Apps Script to add a checkbox to a column when a form is submitted

Apps Script to add a checkbox to a column when a form is submitted Google Sheets Tutorials

882 views - 1 year ago

Apps Scripts to get URL of a named file in drive and then copy parts of google doc to google form

Apps Scripts to get URL of a named file in drive and then copy parts of google doc to google form Google Sheets Tutorials

1.3K views - 1 year ago

Apps Scripts to build a system to use a form to add calendar events, update and delete from sheet

Apps Scripts to build a system to use a form to add calendar events, update and delete from sheet Google Sheets Tutorials

477 views - 1 year ago

Create a unique ID in the form sheet with a formula using the timestamp

Create a unique ID in the form sheet with a formula using the timestamp Google Sheets Tutorials

2.3K views - 1 year ago

Build a test Competition using Apps Script to make Unique ID, Assign markers, and email markers

Build a test Competition using Apps Script to make Unique ID, Assign markers, and email markers Google Sheets Tutorials

85 views - 1 year ago

Apps Script to Choose random question from a list and put on a sheet for present to students

Apps Script to Choose random question from a list and put on a sheet for present to students Google Sheets Tutorials

215 views - 2 years ago

Apps Script to choose a random question from a list, mark it a chosen, add it to a cell osheet

Apps Script to choose a random question from a list, mark it a chosen, add it to a cell osheet Google Sheets Tutorials

122 views - 2 years ago

Apps Script to add the FormEditURL to your FormResponsesheet which can be used to email to submitter

Apps Script to add the FormEditURL to your FormResponsesheet which can be used to email to submitter Google Sheets Tutorials

145 views - 2 years ago

Apps Script to insert date when Checkbox is true and change checkbox to 'Deposited' on a money sheet

Apps Script to insert date when Checkbox is true and change checkbox to 'Deposited' on a money sheet Google Sheets Tutorials

504 views - 2 years ago