Linking data between workbooks, files or tabs using IMPORTRANGE in Google Sheets

Ruben Portz
       

Google Sheets introduction
Linking data between workbooks, files or tabs using IMPORTRANGE in Google Sheets
Importing data from the web with IMPORTDATA, IMPORTXML, IMPORTHTML
VLOOKUP cell values in a dataset in Google Sheets
Converting dates with MONTH and YEAR in Google Sheets
Combining dates in MONTH YEAR using CONCATENATE in Google Sheets
Conditional statements with IF, THEN, ELSE in Google Sheets
Extracting firstnames from full names with REGEXEXTRACT in Google Sheets
Capitalising names with PROPER in Google Sheets
Using SORT and FILTER to find missing values in Google Sheets
Creating a dropdown list in Google Sheets in Google Sheets
Filtering data using the QUERY function and WHERE, LIKE AND OR LIMIT statements in Google Sheets
Searching data using the QUERY function and dropdown list in Google Sheets
Searching data using the QUERY function and text search input in Google Sheets
Visualising lifetime value and churn data using pivot tables in Google Sheets

Related lessons