Create a Month, Quarter, Year Report with 10 Mouse Clicks Using Pivot Tables
With an Excel Pivot Table you can transform thousand of rows of transactions into a neat summary by month, quarter and year using @ 10 mouse clicks!
I invite you to visit my online shopping site to purchase my DVD “The 50 Best Tips for Excel 2007.
(Note: This is a re-post so that I can send this video to my Podcast on iTunes.)
Follow this link to view or subscribe to my Podcast at iTunes
Learn how to “Quickly Create Pivot Tables and Charts.”
Create Summary by Year, Month, Quarter with 10 Mouse Clicks in Excel Pivot Table Play Now | Play in Popup | Download (259)
May 30th, 2010 at 6:30 PM
[...] Danny Rocks Tips and Timesavers » Blog Archive » Create a Month … By pivot | category: pivot, pivot table | tags: entry, excel, excel-training, filed-under, [...]
November 29th, 2010 at 3:46 PM
[...] Create a Month, Quarter, Year Report with 10 Mouse Clicks in a Pivot Table [...]
September 20th, 2011 at 7:49 AM
[...] 3- Use Pivot Tables to Summarize by Year, Quarter and Month [...]