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 best shortcut has nothing to do with the keyboard — it's this box

Excel made things easier, I just never noticed.
MUO on MSN

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

Custom formulas let you dictate exactly what goes into cells.