Excel PivotTable - Summarize data by Month or Day of the week

If you need to find out what day of the week is the most profitable or what day of the week do we receive the most support calls, Excel's PivotTables can handle it. PivotTables will group dates automatically. If you have any date field - invoice dates, order dates, hire dates - Excel will group by year, quarter, and month for you. No formula's needed. If you want to group by day of the week, we can use the TEXT function in Excel and group by the day of the week. In this example, I use PivotTable and the Text function to find out what day of the week do my YouTube videos get the most watch time in hours. Items you could group by for Day or Month Revenue Expenses Profit or Net Income Subscribers Calls received or made Complaints received Staff calling out - I'm betting it is Friday :-) Chapters: 0:00 Intro 0:44 Data 2:00 PivotTable explained 2:58 Create PivotTable 4:00 Text Function 4:47 Month and Day explained 6:15 PivotTable 2 created 7:10 Months summarized 7:50 Days and Months summarized 8:12 Days summarized 8:20 Day totals in Rows 9:18 Contextual tabs 9:42 Design layout 10:38 Grand Totals on/off File used in this video https://drive.google.com/file/d/1x9Av... #msexcel #microsoftexcel #excelpivottable #chrismenard #chrismenardtraining Chris Menard's website: http://chrismenardtraining.com And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!