How-To Geek on MSN

How to use the ISOMITTED function in Microsoft Excel

Build flexible Excel functions that automatically handle blanks, defaults, and overrides without messy nested IFs.
XDA Developers on MSN

4 lesser-known Excel features that changed how I build spreadsheets

These four overlooked Excel features completely changed how I design spreadsheets.

Create Dynamic Excel Data Validation Lists Using Table Spill Ranges

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
Investopedia

Comprehensive Guide to Aggregate Functions: Definition and Examples

Adam Hayes, Ph.D., CFA, is a financial writer with 15+ years Wall Street experience as a derivatives trader. Besides his extensive derivative trading expertise, Adam is an expert in economics and ...