Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest ...

Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest. This ...

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

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

Learn how to create interactive dashboards and dynamic workflows in Excel using modern functions like SUBTOTAL, AGGREGATE, and SWITCH.

Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.

Excel's Sort and Subtotal functions make this abstraction possible. The Subtotal function automatically creates an interactive outline of your materials list, and you can use the outline's ...

You can group rows automatically with the Subtotal function or manually select multiple rows to group. The method of ungrouping rows depends on the way the group was originally set up.

Avoid misleading results in Excel! Learn the pitfalls of the Percent Of function and how to replace it with precise calculation methods.

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