Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Do you want to group data by category? Use a PivotTable. Interested in comparing results by person, by quarter, or by category? Use a PivotTable. Need to answer questions that start with “How ...

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

Excel has options to sort a single column of data, as well as options to group multiple columns together while you sort them.

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

Q: I use Excel’s Group tool to expand and collapse our employees’ weekly timesheet data, but it takes forever to group each section individually for each of my 300-plus employees. Can you tell me how ...

You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.