Would you believe that with fewer than 10 mouse clicks you can transform a long list of daily sales transactions into a useful summary report – showing sales by Month, Quarter & Year?
Yes, you can do this with a Pivot Table report in Excel 2007 – using @ 10 mouse clicks.
Watch how I do this.
Now, many people will want to know how to customize this report to show Quarters that follow a Fiscal Year (e.g. April, May, June is FY Quarter 1) I demonstrate how to do this in my next lesson. Click here to view that video lesson.
If you liked this video, I invite you to shop for my DVD, “The 50 Best Tips for Excel 2007.” I have a secure shopping cart here on my website. Shop now!
Related Excel Video Lessons:
- Visit My Index of Excel Video Lessons – to find a specific Excel topic