Sheets

Free templates, scripts and processes to help you validate, build and grow your business faster

#Sheets

Google Sheets introduction

#Template  #Sheets

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


#Template  #Sheets

VLOOKUP cell values in a dataset in Google Sheets


#Template  #Sheets

Importing data from the web with IMPORTDATA, IMPORTXML, IMPORTHTML


#Template  #Sheets

Combining dates in MONTH YEAR using CONCATENATE in Google Sheets


#Template  #Sheets

Converting dates with MONTH and YEAR in Google Sheets


#Template  #Sheets

Conditional statements with IF, THEN, ELSE in Google Sheets


#Template  #Sheets

Extracting firstnames from full names with REGEXEXTRACT in Google Sheets


#Template  #Sheets

Capitalising names with PROPER in Google Sheets


#Template  #Sheets

Creating a dropdown list in Google Sheets in Google Sheets


#Template  #Sheets

Filtering data using the QUERY function and WHERE, LIKE AND OR LIMIT statements in Google Sheets


#Template  #Sheets

Using SORT and FILTER to find missing values in Google Sheets


#Template  #Sheets

Searching data using the QUERY function and dropdown list in Google Sheets


#Template  #Sheets

Searching data using the QUERY function and text search input in Google Sheets


#Template  #Sheets

Visualising lifetime value and churn data using pivot tables in Google Sheets


#Template  #Sheets

How to link Google Ads and Search Console to Google Analytics?


Category

Analytics
Apps Script
Data Studio
Facebook
Financials
Instagram
JSON
Landing Pages
MVP
SEO
Sheets
Slack
Twitter
UX
Validation