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 actually enforce

Custom formulas let you dictate exactly what goes into cells.
How-To Geek on MSN

This hidden Excel tool can quickly clean up your data automatically

Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.