Can you imagine trying to use Excel Subtotals to summarize a long column sales, listed by date? What would you subtotal – every change in date? It would be a nightmare!

Pivot Tables, on the other hand, can provide a summary of dates by month, quarter, and year with just a few mouse clicks!

In this video lesson I show you how to produce that summary. The Pivot Table will transform a long list of data into information that you can use to analyze trends.

Here are the steps to follow in this lesson:

1. Create a Pivot Table using all of the default settings. Drag the “Date” field into the ROW area and the “Sales” field into the DATA area of the Template.
2. With 1 cell in the “Date” row selected, choose “Group & Show Detail, Group.” Select Year, Quarter and Month and click OK.
3. You now have 3 ROWS in your Pivot Table – Year, Quarter & Month. Drag the Year field from the ROW up to the COLUMN area. Hide on of the “Grand Totals.”
4. Click the Pivot Chart icon to create a Pivot Chart on a new worksheet. Filter the data fields.
5. Move the Year field back to the Row area. Ungroup the fields to return to the starting point.
6. To Group by WEEK: Choose “Group & Show Detail, Group” and select DAY. Then select 7 for the number of days in the week.

Find the Excel Training Video that you want – Index of all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007″ is now availabe to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons

• Introduction to Pivot Tables
• Hide & Show Details in Pivot Tables
• Create a Calculated Field in Pivot Tables
• Change the Quarterly Summary to a Fiscal Year in Pivot Tables
  

 Subscribe to our RSS Feed

This entry was posted on Friday, August 22nd, 2008 at 4:33 pm and is filed under Pivot Tables. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.