ZebraFarm Beta Beta
Services Newsletter
Newsletter Sign Up
Validate
Build
Grow

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

Sheets




  Twitter

  Facebook

  LinkedIn

  Reddit

Resources & Links

Practice dataset
Google Sheet Functions Cheat Sheet
Ruben Portz
       

Google Sheets functions for growth teams

  1. Google Sheets introduction
  2. Linking data between workbooks, files or tabs using IMPORTRANGE in Google Sheets
  3. Importing data from the web with IMPORTDATA, IMPORTXML, IMPORTHTML
  4. VLOOKUP cell values in a dataset in Google Sheets
  5. Converting dates with MONTH and YEAR in Google Sheets
  6. Combining dates in MONTH YEAR using CONCATENATE in Google Sheets
  7. Conditional statements with IF, THEN, ELSE in Google Sheets
  8. Extracting firstnames from full names with REGEXEXTRACT in Google Sheets
  9. Capitalising names with PROPER in Google Sheets
  10. Using SORT and FILTER to find missing values in Google Sheets
  11. Creating a dropdown list in Google Sheets in Google Sheets
  12. Filtering data using the QUERY function and WHERE, LIKE AND OR LIMIT statements in Google Sheets
  13. Searching data using the QUERY function and dropdown list in Google Sheets
  14. Searching data using the QUERY function and text search input in Google Sheets
  15. 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?

© 2022 ZebraFarm Ltd
About Us Privacy Cookies Terms