This week, John Walkenbach, aka Mr. Spreadsheet, used a pivot table report to analyze his website’s Amazon sales for 2009. Here’s a screenshot of the results, showing the top sellers, and number of units sold. John knows a thing or two about Excel, having written over 40 Excel books, so take a look at the [...]

Chandoo, at the Pointy Haired Dilbert blog, has posted 5 Excel Pivot Table tricks today. His blog posts are always informative and entertaining, so go and take a look. The 5 Pivot Table tricks are: Drill Down Pivot Tables Change Summary from Total Slice and Dice Pivots Difference from Last Month Calculated Fields in Pivots [...]

The team at PowerPivot for Microsoft Excel 2010 created the Excelerators Quiz, where you can test your Excel skills. To make the challenge more exciting, they’re sponsoring a giveaway on the Contextures blog (for USA residents only). The blog giveaway prize has a total value of over $250, and will include a Dell ST2310 23 [...]

After you create a calculated field in an Excel pivot table, you might want to remove it from the pivot table layout. You can temporarily remove a calculated field, or you can permanently remove it. In this example, the pivot table has a calculated field named Bonus. It appears in the Values area as Sum [...]

In an Excel 2007 pivot table, you can filter a date field by using the Date Filters option in the Row Labels drop down. For example, you can select all the dates between two specific dates, or filter for a dynamic range, such as Last Week.   However, when you use the row label date [...]

Sometimes when you add fields to the Values area of a pivot table, they appear as Count of Field instead of Sum of Field. In the screen shot below, the Quantity field shows the COUNT, and the TotalPrice field shows the SUM.   COUNT Summary Function The COUNT summary function is the default if a [...]