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

When Excel displays the empty PivotTable frame (Figure B), start dragging columns from the field list to the sections below: Filters, Columns, Rows, and Values.

This month, I received a lot of Excel questions. So in this article, we'll tackle random time values, an icon-displaying conditional expression and format, and a quick PivotTable solution.

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.

Excel’s intuitive drag-and-drop interface allows you to easily arrange fields in the Rows, Columns, Values, and Filters areas, giving you complete control over how your data is structured.

Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? Your PivotTable will now display the same two columns of data both numerically and as a percentage of total, as pictured ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.