When you have a massive Excel workbook overflowing with data, trying to make sense of it can feel like a tough task at times.

I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...