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 ...
9to5google

Google Sheets can now sort and filter cells by text or fill color

Google Sheets is now gaining a new feature that allows you to filter and sort cells by text color and fill (background) color. The new usability addition was confirmed in an official G Suite blog post ...
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 ...