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.

In this article, I'll run through three of the functions or combinations of functions I use the most when I want to either extract or summarize information in my Excel tables.

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

How to Keep Rows Stationary in Excel. It can be difficult, if not impossible, to view and analyze the raw data contained within a large Excel spreadsheet. For example, if you needed to compare ...

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

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

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