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 ...
How-To Geek on MSN

How to use the ROWS function in Microsoft Excel

Create robust, backward-compatible Excel workbooks by leveraging the structural power of the ROWS function.