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!
Click here to watch this Excel Video Lesson on YouTube
Related Excel Video Lessons:
- Visit My Index of Excel Video Lessons – to find a specific Excel topic
Link to this post!
[…] video lesson is related to my previous lesson – “How to Create a Month, Quarter Year Pivot Table Report.” This time, we are using a Fiscal […]