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.