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 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 …

In the Select Data Source dialog box, in the Legend Entries (Series) box, select the data series that you want to change the order of. Select the Move Up or Move Down arrows to move the …

How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.

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 …

You can create a basic grouped report by using the Report Wizard, you can add grouping and sorting to an existing report, or you can revise grouping and sorting options that have already …

With Power Pivot, you can import the product category table to your data model, create a relationship between the table with the number data and the product category list, and then …