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

Put Excel into Easy Mode by Implementing First Normal Form (1NF)

Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.