How-To Geek on MSN

I love Excel's PIVOTBY function—but this one feature keeps me using PivotTables

PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.

Excel’s Hidden N Function Lets You Add Comments Inside Formulas

Embed Excel formula comments directly into your math using the N and REPT functions to keep your spreadsheet documentation ...
MUO on MSN

Excel’s MOD function is weird, but now I use it everywhere

The more I learned MOD, the more excuses I found to use it.