Sometimes it’s quicker to use a keyboard shortcut, instead of the mouse, to accomplish a task in Excel. Here are some of the keyboard shortcuts for working with pivot tables in Excel 2007 and Excel 2003. Excel 2003 Pivot Table Keyboard Shortcuts Shortcut Action Ctrl + Shift + * Select entire pivot table (not including [...]

After you create an Excel pivot table, you might want to know how many unique customers placed an order for each product. However, when you add the Customer field to the pivot table’s Value area, it shows the number of orders, not the number of unique customers. Unfortunately, a pivot table doesn’t have a built-in [...]

You can group the dates in a pivot table in different increments, such as by year and quarter. However, the grouping options are based on the calendar year, and there are no options for grouping pivot table dates by fiscal year. If you want to group the dates by your company’s fiscal year, which starts [...]

If there’s a date field in your Excel pivot table, you can use it to focus on a specific date, or a selected date range. To filter the dates, you can use the following filter types: Date checkboxes Date range entry Dynamic date range selection Using Date Checkboxes If a date field is in the [...]