Google

Google Sheets: vlookup multiple workbooks with “=importrange”

After almost melting my brain I finally got this working ūüôā In this tutorial we’ll have a look at the process to follow when creating a multi-workbook vlookup formula in Google Sheets¬†(and hopefully keeping ourselves “woooosssaaahh” in the process). Multi-workbook vlookup’s in Excel are fairly simple because Excel does all the heavy lifting in connecting …

Web-scraping with Google Sheets and XPath

One of the more advanced features available to Google users, is the user’s ability to¬†scrape¬†data – from the web – directly into a¬†Google spreadsheet¬†through utilizing the ‘=IMPORTXML‘ function, combined with¬†XPath. The script to follow outlines this functionality by scraping a simple data table from a public¬†website¬†and loading the results into a spreadsheet . In practice, …

9 Box Employee Performance Matrix with Google ‘=query’ (Video Series)

This is a 4 part video series on how to create a 9 Box¬†(Employee Performance)¬†Matrix, using Google’s ‘=query’ function in Google Sheets. For an introduction to¬†Google’s Query function, you can jump directly to¬†Video 3 Apologies upfront for the low volume¬†and my weird accent.¬†Still getting used to the new recording equipment. This is a first attempt, …