Скачать с ютуб Properly Handle Date Grouping and Missing Dates in Excel Pivot Tables (show all dates) в хорошем качестве

Properly Handle Date Grouping and Missing Dates in Excel Pivot Tables (show all dates)

Get access to the full course here 👉 https://www.xelplus.com/course/excel-... Working with dates in Excel pivot tables can get tricky. When you drag and drop a date field in the pivot table Excel automatically groups the dates into days, months and years. But with if you want to see the actual date and not the grouping? How can you quickly ungroup the dates? hint: There's an Excel shortcut to ungroup dates in a Pivot Table. What if you'd also like to create different date grouping not available in the Pivot table? For example create a pivot table report showing fiscal periods or the weekday, quarter etc. Another challenge you might come across is showing ALL the dates in the pivot table and not only the ones that have values. How can you unhide these dates with no values? It's really easy to setup. We'll be creating an automatic calendar table in the data model and then we can connect our tables together via relationships. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/pivottable-... Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... 00:00 How to Deal with Dates in Pivot Tables 00:33 Automatic Grouping & Ungrouping of Dates 02:05 Create Your Own Groupings 04:18 Use a Date Table in the Data Model 06:25 Create Relationship with Calendar Table 07:09 Create Power Pivot Table 08:07 How to Sort by Date in a Pivot Table 09:46 How to Display Dates Without Data 10:59 Show Data by Quarters in Pivot Table 12:32 How to Extend Calendar Table 13:06 Wrap Up 🎬 LINKS to related videos: Excel Productivity for Lazy (but Smart) People:    • Excel Productivity for Lazy (but Smar...   How Power Query Will Change the Way You Use Excel: ➡️ Join this channel to get access to perks:    / @leilagharani   👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram:   / lgharani   LinkedIn:   / xelplus   This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel