Stop Letting Excel Ruin Your Data : Master Month Sorting the Right Way

Fix Excel’s alphabetical month sorting issue with simple tricks. Learn how to group months chronologically using XMATCH and CHOOSECOLS.
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 ...
MrExcel on MSN

Excel Pivot Table Grouping Issue – How to Fix “One Group Changes All”

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 ...

Unlock Excel’s Secret Weapon : The Hidden Power of GROUPBY

Learn how to unlock Excel’s hidden features with GROUPBY and create visually compelling, accurate reports like never before.
TechRepublic

How to use a border to discern groups more easily in Microsoft Excel

How to use a border to discern groups more easily in Microsoft Excel Your email has been sent A large set of Microsoft Excel data without good formatting is difficult to read. Table objects ...
TechRepublic

How to add a conditional format that highlights groups in Excel

How to add a conditional format that highlights groups in Excel Your email has been sent The article, How to use a border to discern groups more easily in Microsoft Excel, shows you how to use a ...