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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919