ZebraFarm
Beta
Beta
Services
Newsletter
Newsletter
Sign Up
Validate
Build
Grow
Linking data between workbooks, files or tabs using IMPORTRANGE in Google Sheets
Sheets
Ask a question
Twitter
Facebook
LinkedIn
Reddit
Resources & Links
Practice dataset
Google Sheet Functions Cheat Sheet
Ruben Portz
Google Sheets functions for growth teams
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
How to link Google Ads and Search Console to Google Analytics?