The SUBTOTAL Function Microsoft Excel's SUBTOTAL function is quite simple to use. It lets you perform subtotal calculations for ranges of cells, and you can decide whether you want to include ...

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

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.

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

Topline Spreadsheets aren’t just for business owners and data analysts—here are some easy ways to integrate Microsoft Excel into your life.

In a nutshell: Formulas are a must for incorporating math into spreadsheets, but using them in Microsoft Excel involves a learning curve and can become tedious. This latest update adds a bit of ...