In Microsoft Excel, you can permanently hide columns containing data you don't need to have on show. However, grouping columns is often a better way to achieve the same outcome, especially if you're ...

Need to know your organization’s YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel. You can make an Excel PivotChart to show year-over-year results like this one.

Sometimes you may have a lot of data in your document, and it can be difficult to read; luckily, Microsoft Excel has a feature called Group which you can use to organize your data into sections that ...

Summarizing data is a common task in Excel, and there’s usually more than one way to do so. Susan Harkins explains three ways to return averages for multiple groups. If you have three or more rows of ...

Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Because the field names ...

Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...