Use an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.

In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.

The GROUPBY function in Excel allows you to create a summary of your data via a formula.

In Power Query, you can group the same values in one or more columns into a single grouped row. You can group a column by using an aggregate function or group by a row.

You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are made in all …

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

When you sort information in an Excel worksheet, you can see data the way you want and find values quickly, in just a few clicks. You can sort a range or table of data on one or more columns of data.

You can insert one level of subtotals for a group of data as shown in the following example. To sort the column that contains the data you want to group by, select that column, and then on the Data tab, in …

How to use AutoFilter in Excel to find and work with a subset of data in a range of cells or table.

Excel provides multiple techniques that you can use to count cells, rows, or columns of data. To help you make the best choice, this article provides a comprehensive summary of methods, a …