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

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect ...

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

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

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.

In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value.

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

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...