How-To Geek on MSN

How to use structured references in Microsoft Excel

Structured references use table columns instead of cell coordinates, making formulas easier to read, update, and trust.

8 Excel Symbols That Are Making Complex Formulas Obsolete

Stop Excel errors by using these 8 key symbols, like ' to keep leading zeros and ~ to search for literal * or ? characters in data.
How-To Geek on MSN

How to use the hidden form tool in Excel for quick data entry

This overlooked Excel feature replaces tedious typing with a form interface that speeds up data entry, protects formulas, and ...

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