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

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

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 …

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

Lists all Excel functions by their category, such as Logical functions or Text functions.

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 …

It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it …

例如，如果您有銷售數據表格，您可能會產生依年份的銷售摘要。 語法 GROUPBY 函數可讓您根據指定的欄位來分組、匯總、排序及篩選數據。 GROUPBY 函數 的語法為： GROUPBY …

The following table lists some of the standard aggregation functions provided by Excel, and provide links to the implementation of these functions in Power Pivot.