Google Sheets - Named Ranges, Dynamic Updates, with IMPORTRANGE, Other Sheets, Arrays - Tutorial

In this video tutrial you'll learn how to use Named Ranges in Google Sheets, how to make them dynamic, use them in other worksheets, use them in other sheets/files with IMPORTRANGE function, use them in arrays & other functions like VLOOKUP.