In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it's definitely possible thanks to the Offset() function.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

How to Sort Multiple Rows and Columns in Excel. With Microsoft Excel's powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically or ...

If you find yourself scrolling a lot while using spreadsheets because you need to check across rows and columns, freezing them might be just what you need.