Using Power Query and Power Pivot for a Reusable Custom Calendar Table | Everyday Office

While Excel handles date information like months and years very well, it has no functionality for distinguishing past from future, or handling Fiscal Years and Fiscal Quarters that don't line up with the normal calendar. Power Query is AMAZING at calculating any date information you're interested in. Then, we save the Calendar Table into a template Excel file, and we can reuse the table over and over with Power Pivot for incredibly valuable Pivot Table and Pivot Chart analysis Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on: - http://www.knacktraining.com/blog/ - http://www.knacktraining.com/podcast/ Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.