Summarize Fiscal Year by Month and Quarter with a Pivot Table

Excel Pivot Tables can quickly group dates by Month, Quarter and Year. If your company uses a Fiscal Year,  then be sure that your source data contains columns to identify the Fiscal Year and the Fiscal Quarter before you create the Pivot Table. Watch how this is done.

(Note: This is a re-post so that I can send this video to my Podcast at the iTunes store.)

Follow this link to view and subscribe to my Tips and Timesavers Podcast on iTunes.

I invite you to visit my online store to learn about my DVD series, “The 50 Best Tips for …”

Learn how to “Quickly Create Excel Pivot Tables.”

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Summarize Fiscal Year, Months, Quarters with Pivot Tables Play Now | Play in Popup | Download (259)

rss Subscribe to our RSS Feed

This entry was posted on Sunday, May 30th, 2010 at 6:06 AM and is filed under Excel Training, Pivot Tables, Podcast Tips & Timesavers. 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.

«
»

One Response to “Summarize Fiscal Year by Month and Quarter with a Pivot Table”

  1. Danny Rocks Tips and Timesavers » Blog Archive » Summarize Fiscal … Get Pivot Says:
    May 30th, 2010 at 10:51 AM

    [...] the original post:  Danny Rocks Tips and Timesavers » Blog Archive » Summarize Fiscal … By pivot | category: pivot, pivot table | tags: data-contains, fiscal, fiscal-quarter, [...]

Leave a Reply

Powered by WishList Member - Membership Site Software