The Advanced Google Sheets Features You Should Be Using but Probably Aren’t

This Google Sheets Advanced Tutorial explains IF, VLOOKUP, INDEX MATCH, and pivot tables, plus macros and Apps Script for ...
Neowin

Google adds the ability to refresh BigQuery data in Sheets via macros, Apps Script

In order to enhance its recently announced BigQuery connection with Sheets, Google has revealed a new ability which allows folks to easily refresh BigQuery data within its spreadsheet app. After ...