How-To Geek on MSN

How to use formula by example in Excel to generate complex formulas

I traded the static results of Flash Fill for dynamic formulas that update automatically.
How-To Geek on MSN

I know Excel experts hate this function, but it’s still my favorite secret weapon

The INDIRECT function has a rep for being a "nightmare," but for building reactive dashboards, it’s irreplaceable. Here is ...