How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

Learn how to create Excel dynamic total rows that adjust automatically with your data. Save time and simplify data management with these ...

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.