Calendar Table Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/calendar-table/ Bestselling Excel and Power BI Courses Fri, 10 Mar 2023 16:09:40 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Calendar Table Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/calendar-table/ 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.

]]>