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 ...
MUO on MSN

Excel's data validation is far more powerful than just dropdowns — here's what it can ...

Custom formulas let you dictate exactly what goes into cells.