Excel - Mastering Pivot Tables: Grouping Data by Fiscal Quarters in Excel - Episode 1012

2,833 views · Published 12 May 2009 · 3:30 · Indexed 31 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Mastering Pivot Tables: Grouping Data by Fiscal Quarters in Excel.

Welcome back to the MExcel NetCast, where we dive into all things Excel. I'm your host, Bill Jelen, and today we're tackling a common issue faced by many Excel users - grouping data by fiscal quarters. 

As we all know, Excel is a powerful tool for analyzing large amounts of data. But when it comes to organizing that data by fiscal quarters, things can get a bit tricky. That's where pivot tables come in handy. In this episode, we'll show you how to use pivot tables to group your data by fiscal quarters and create a comprehensive report. 

But what if your fiscal year doesn't end on December 31st? Unfortunately, Excel doesn't have a built-in solution for this. But fear not, we have a workaround for you. By inserting a few new columns and using some simple formulas, we can easily convert our data to reflect the correct fiscal year and quarter. 

So, whether your fiscal year ends in December or not, this episode has got you covered. We'll walk you through the steps to create a pivot table that displays your data in fiscal years and quarters, making it easier for you to analyze and present your data. So, join us as we tackle this common Excel issue and make your data analysis a breeze. Thanks for tuning in to the MExcel NetCast, and we'll see you next time for more Excel tips and tricks."

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Vaibhav asks how to group a pivot table up to fiscal quarters. While this is easy if your fiscal years ends on December 31, it is not so easy for other year-ending dates. Episode 1012 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents
(00:00) Pivot Table grouping to Months and Quarters
(00:24) Pivot table with daily dates
(00:58) Add Fiscal Year column to original data
(01:56) Calculating Quarter from Date
(02:40) Build the pivot table
(02:59) Clicking Like really helps the algorithm


#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Choose command
Copying formatting
Creating a pivot table
Data in fiscal years
Fiscal quarter
Fiscal year
Formatting as a number
Grouping by months and quarters
Inserting new columns
MExcel NetCast
Pivot table
Roll up to years and quarters


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152409/

More from this channel