Hosted on MSN

How to Use the PIVOTBY Function in Excel

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect changes ...
HowToGeek on MSN

How to Use TRIMRANGE & Trim Ref Operators to Tidy Up an Excel Spreadsheet

Looking for a way to tidy up your spreadsheet and reduce its size without having to use dynamic range formulas like OFFSET, ...