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 workflow automation.
PC World

Essential add-ons for Google Sheets: Workflows, advanced find and replace, mail merge

Managing and maintaining spreadsheets is one of the biggest productivity sinkholes in the workplace. Fortunately, if you’re using Google Sheets, there are many add-ons that expand on its capabilities ...