Channel: Teacher's Tech

Category: Education

Tags: how to link data in google sheetsteachers techjamie keethow to use google sheetsgoogle sheets tutorialgoogle sheetslink data between ranges in google sheetsarrayformula google sheetsgoogle sheets tutorial for beginnerslinking data between sheets and spreadsheets in google sheetslink spreadsheets in google sheetsgoogle sheets formulasimportrange google sheetsheets in google sheets

Description: In this video tutorial, I will show you how to link data in Google Sheets. I will go over linking cells and ranges on the same sheet in Google Sheets. Also, I will show you how to link sheets or tabs within a spreadsheet and how you can link spreadsheets to each other using Google Sheets. The two functions that will get used in this video are ARRAYFORMULA and IMPORTRANGE. 0:00 Introduction 1:25 Linking Cells in Google Sheets 3:49 Linking Ranges in Google Sheets 6:33 Linking separate spreadsheets in Google Sheets Here’s the link with all of the Google Spreadsheets after you open them make a copy of them under file: drive.google.com/drive/folders/1oQC3QYdkyUqbs9Ixw_jzJs_z1MuGLUHu?usp=sharing