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

Thank you, Chris! The way you simplified the pivot table was really amazing. I was new to the pivot and was looking for some help on RU-vid. I had seen so many videos but your video was really good. I followed the steps and sent the data to my manager and he liked it. So thanks again for making my work simple.

Thanks, Chris. Ryan from the UK here, you have just made this look so simple to use. It is great material and a great video, I will recommend and subscribe.

I like your teaching method Chris. Thank you for the great explanation.

I love your teaching style. Your practical example helps us to understand more clearly.

Excellent, thanks for sharing. Subscribed.

I learned a lot! Thank you!

My pivot table does not pic up date in the top column, only the labels of the 2 columns like yours - one with the date with cells formatted as Date and a 2nd column on the right with numeric values. Wierd huh?

Thank you Chris :)

Good work sir

Good evening, thanks for the video,it is very useful. I would like to ask, can you please explain me how can i learn =Forecast formula and Vlookup thanks. Some of the questions I'm studying required deep knowledge of them. Thank you

useful knowledge. put practiced file in the description...

I grouped all my excel worksheets into one using the query function. The table on query has the date column and the net profits. I'm trying to build a line performance chart with my 450 dates and net profit for each day. Somehow excel is not letting me do it. A message poos saying reference source data not bla bla bla. Can someone help me?

Hi, I have a question. Is there a way I can create a spreadsheet that automatically inputs the data from a pivot table at the end of everyday? For example, at the end of one day, it will have a column with the date and the amount of carts inputted? Then the next row would be that days total - the previous days? To see how many carts are being inputted each day? Please let me know if that makes sense. Thanks!

This isn't working for me because my dates have gaps between dates..... I created a second range of all dates in order and I'm trying to consolidate my original dates with respective unique data values to the long list of consecutive dates, but excel doesn't like that either

Hi , I want to fetch 52 weeks high low in pivot table . Is there any way to do considering from current date to 52 weeks ?

Is there a way to separate by week for a year and get a sum at the end of each week

I like your teaching method Chris. Thank you for the great explanation.