Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data.

Subtotal a List in Excel The simplest way to work with data is to consolidate it and subtotal it by the field you’re interested in analyzing. For example if your table includes invoice data, you can ...

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

The article, How to display multiple subtotal rows in a Microsoft Excel PivotTable shows you how to insert multiple subtotal rows into a PivotTable without repeating data.

How to Subset Data in Excel. Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data ...

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

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