Tim Welch

547 posts

Tim Welch banner
Tim Welch

Tim Welch

@redtailfan

Lifelong learner/educator, Google Sheets Expert, Google Certified Edu Trainer, Google Workspace Trainer and Integrator. All musings are my own. PURA VIDA

Cove, Oregon Katılım Eylül 2009
92 Takip Edilen249 Takipçiler
Tim Welch
Tim Welch@redtailfan·
Using New Tables in google sheets formulas youtu.be/nRt--kjZHSw?si… via @YouTube Google released the new Tables features a while ago. Here is how you can use the tables feature in formulas.
YouTube video
YouTube
English
0
0
0
11
Tim Welch
Tim Welch@redtailfan·
contacts had randomly formatted phone numbers, and I wanted to make then consistent when I imported them. I wrote an Apps Script to clean up the list. docs.google.com/document/d/10Y…
English
0
0
0
11
Tim Welch
Tim Welch@redtailfan·
Apps Script To clean a list of phone numbers that are in different forma... youtu.be/hVTWwZ2nA1g?si… via @YouTube I needed recently to clean a list of contact's phone numbers that were exported form google contacts in order to import them into MailChimp. However the list of
YouTube video
YouTube
English
1
0
0
22
Tim Welch
Tim Welch@redtailfan·
In this video, I go over the new features and simplification of the reading log system I recently posted. Enhanced Version 2 of Apps Script Based Reading Logs System youtu.be/YeQZNA_TPDI?si… via @YouTube
YouTube video
YouTube
English
0
0
0
19
Tim Welch
Tim Welch@redtailfan·
Apps script Reading Logs system for educators to collect reading data fr... youtu.be/SN_xyzC_VZ0?si… via @YouTube In this video I share a new system I have developed that creates a student reading log for each student, then allows the teacher to pull the data from each student
YouTube video
YouTube
English
0
0
0
12
Tim Welch
Tim Welch@redtailfan·
Use the 'SWITCH' formula with a 'QUERY' to make a dynamic dashboard to s... youtu.be/G-U-WwRy-IY?si… via @YouTube In this video I demonstrate how you can use the 'switch' formula along with a 'query' to dynamically show data based on Quarters, Current Year, Last, year, all years
YouTube video
YouTube
English
0
0
0
11
Tim Welch
Tim Welch@redtailfan·
AppsScript to index all files in your google drive owned by you, name, U... youtu.be/ShKJEXwNyVo?si… via @YouTube In this video I demonstrate a simple way to index all the files in your google drive owned by you and save it to a google spreadsheet with the Name, URL, ID, Date Crea
YouTube video
YouTube
English
0
0
0
38
Tim Welch
Tim Welch@redtailfan·
Limit the data source to use a pivot table and a pivot table group to su... youtu.be/riTJ_dIW1Dw?si… via @YouTube In this short video I demonstrate how to use a pivot table group in a column to summarize the google form data. A little work around to first limit the amount of data
YouTube video
YouTube
English
0
0
0
16
Tim Welch
Tim Welch@redtailfan·
Sports Tracker - A tutorial on how you can build a Spreadsheet to track... youtu.be/aKdt54Riw7A?si… via @YouTube In this video I demonstrate a system I have built that will track the weekly practice activities for you volleyball season as well as a summary of the full season.
YouTube video
YouTube
English
0
0
0
26
Tim Welch
Tim Welch@redtailfan·
A little off topic for my posts, but had to share the hummer tracking a shower at sunset!
English
0
0
0
11
Tim Welch
Tim Welch@redtailfan·
Using Apps Script to Update a Standards sheet on each student sheet that... youtu.be/PpSNPfpLg3g?si… via @YouTube Add a new sheet or replace an existing sheet on all the student sheets from your master sheet. Here is an example of using apps script to update an incorrect standards
YouTube video
YouTube
English
0
0
0
18
Tim Welch
Tim Welch@redtailfan·
How to use Looker Studio to analyze data, share without sharing the shee... youtu.be/bzvuthhWj9g?si… via @YouTube Use Looker Studio to display your sheets data (and many other data sources). Keeps your data source secure, but allows others to analyze the data on embedded web page.
YouTube video
YouTube
English
0
0
0
38
Tim Welch
Tim Welch@redtailfan·
Create a new google doc in a folder, rename it, and replace an email pla... youtu.be/8Tf0JN6FKvU?si… via @YouTube Enhancement to my student Portfolio system, runs all three scripts from the first script and now places the actual student email address in the newly generated documen
YouTube video
YouTube
English
0
0
0
17