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 ...
Computerworld

Google Sheets power tips: How to use filters and slicers

Filters and slicers help you highlight key data in a spreadsheet by hiding less relevant data. Here’s how to make them work for you in Google Sheets. If you’re building a large spreadsheet in Google ...
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 ...