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 RUclips. 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.
@@ChrisMenardTraining It was simple because you took the data from only 1 sheet. What about the scenarios where you have to get the data from multiple sheets into 1 pivot table without having to do the extra work involved with copy pasting, removing duplicates etc.
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?
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
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!
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?
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
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 RUclips. 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.
Glad you enjoyed it! Thanks for the sub.
I love your teaching style. Your practical example helps us to understand more clearly.
Thank you! 😃
@@ChrisMenardTraining It was simple because you took the data from only 1 sheet. What about the scenarios where you have to get the data from multiple sheets into 1 pivot table without having to do the extra work involved with copy pasting, removing duplicates etc.
I like your teaching method Chris. Thank you for the great explanation.
You are very welcome
Excellent, thanks for sharing. Subscribed.
Thanks for the sub!
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?
I learned a lot! Thank you!
You are so welcome!
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
Thank you Chris :)
You are welcome!
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!
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 want to fetch 52 weeks high low in pivot table . Is there any way to do considering from current date to 52 weeks ?
Good work sir
Thanks
useful knowledge. put practiced file in the description...
It is in the description.
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
Is there a way to separate by week for a year and get a sum at the end of each week
Yes. I'll make a video on that this weekend. It will be out next week. Great question!
@@ChrisMenardTraining Hi Chris - Did you make this video which seperates data by week? Can you provide link? THANKS
I like your teaching method Chris. Thank you for the great explanation.
Thank you JP.