
Outline (group) data in a worksheet - Microsoft Support
Use an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.
Group or ungroup data in a PivotTable - Microsoft Support
In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.
Group rows of data (Power Query) - Microsoft Support
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.
GROUPBY function - Microsoft Support
The GROUPBY function in Excel allows you to create a summary of your data via a formula.
Create a grouped or summary report - Microsoft Support
On the page of the Report Wizard that asks Do you want to add any grouping levels?, click one of the field names in the list, and then click Next. To add grouping levels, double-click any of the …
Group worksheets - Microsoft Support
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 …
Aggregations in Power Pivot - Microsoft Support
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 …
Use a screen reader to group or ungroup data in a PivotTable in …
Group or ungroup data in a PivotTable in Excel using your screen reader and keyboard.
Insert subtotals in a list of data in a worksheet - Microsoft Support
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 …
Sort data in a range or table in Excel - Microsoft Support
How to sort and organize your Excel data numerically, alphabetically, by priority or format, by date and time, and more.