How-To Geek on MSN

I ditched SUMIF for SUMIFS in Excel—and my spreadsheets finally work the way I need them to

A simple switch to SUMIFS can make your formulas easier to expand, read, and maintain as your spreadsheets grow.
YouTube on MSN

I mastered Excel's groupby & pivotby functions!

Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This tutorial covers: - Basic GROUPBY to calculate the sum of revenue by ...