Become a MASTER of IMPORTRANGE including Hacks and Shortcuts!
Exclusive to Google Sheets, the IMPORTRANGE formula is like no other. It allows you to use live data from different spreadsheets in the spreadsheet you're working on. Since it's live, when the data updates in the external spreadsheet, the data in your spreadsheet will automatically update as well. Copy and Paste could never.
There are endless use cases for this formula. But first, you need to understand how to use it in it's basic form as well as how to use it in an advanced manner such as with a FILTER formula or a QUERY formula. I teach you how to do this in this video as well as some hacks and shortcuts to help make your formulas more readable since this formula can get lengthy fast.
00:00 - Intro
00:18 - Basic IMPORTRANGE functionality
02:31 - Combine multiple imported ranges into a single list
02:53 - Combine dynamic ranges without the extra tabs
04:06 - Use the FILTER formula to exclude blanks
05:11 - Shortcuts to make the formula easier to read
07:20 - Use the QUERY formula to simplify the formula even further
08:17 - Outro