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

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

Remove subtotals and turn off outlining before you apply Remove Duplicates. If you're new to Microsoft Excel 2007, take time to study the Remove Duplicates feature, as it did not appear in Excel 2003.