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

Trackbacks

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

Speak Your Mind

*