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.

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.
Hosted on MSN

How to Use the GROUPBY Function in Excel

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...
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 ...
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 ...