Date Group Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/date-group/ Bestselling Excel and Power BI Courses Fri, 17 Mar 2023 00:05:54 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Date Group Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/date-group/ 32 32 How to Properly Handle Dates in Excel Pivot Tables https://www.xelplus.com/pivottable-dates-grouping/ Thu, 19 May 2022 08:00:00 +0000 https://www.xelplus.com/?p=9286 Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

The post How to Properly Handle Dates in Excel Pivot Tables appeared first on Xelplus - Leila Gharani.

]]> Excel Advanced Pivot Table Techniques for Serious Data Analysts https://www.xelplus.com/excel-advanced-pivot-tables/ Thu, 08 Apr 2021 08:00:00 +0000 https://www.xelplus.com/?p=10162 These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel's most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!

The post Excel Advanced Pivot Table Techniques for Serious Data Analysts appeared first on Xelplus - Leila Gharani.

]]>