There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Use Descriptive Sheet Names One way to make your Excel workbook more accessible is by changing the names of the worksheets. As you can see when you look towards the bottom of your workbook, Excel ...

How to Make Sortable Headings in Excel. Microsoft's Excel spreadsheet program contains many features that enable you to create comprehensive and detailed documents.