Pivot Tables in Excel 2007
www.mrexcel.com
Create your first pivot table. Summarize revenue by region and product.
• Insert – Pivot Table.
• Verify the data range. Click OK.
• Note the new interface. You now select fields in the field list and arrange them in four drop zones at the bottom of the field list. This is easier than dragging fields into the worksheet.
• Simply checkmark the Region and Revenue fields.
• When you check the Product field, you need to drag it to the column area.
• Insert – Pivot Table.
• Verify the data range. Click OK.
• Note the new interface. You now select fields in the field list and arrange them in four drop zones at the bottom of the field list. This is easier than dragging fields into the worksheet.
• Simply checkmark the Region and Revenue fields.
• When you check the Product field, you need to drag it to the column area.
Change the Pivot Table:
• Add Customers as a new row field.
• Notice the expand and collapse functionality
New Features in Excel 2007
1. Formatting a pivot table has dramatically improved. There are now 24K formats instead of the old 14 formats. Remarkably, most of the new formats look good, while none of the old formats looked good.
2. Filtering by row fields; easy to filter dates to a specific month, revenue to above average, or text fields to those containing a value.
I will post show notes at http://www.mrexcel.com/tip154.shtml
leave a comment
