My goodness. You are one of the best creators on CZcams EVER. I'm really awful at using Excel, and somehow I managed to find this video in a Google search. Man, I didn't know I needed pivot tables! I'm geeking out here. Thanks so much.
Sir, I can only say thank you. I was trying to do this on a laptop and look at 10 videos and you are the only one who said use the Fn button. I cannot thank you enough for taking away my frustrations.
Thank you for your videos! I check out MANY on youtube and by far your lessons are superior. Easy to follow, you talk at a sensible pace, all content is very organized. Excellent!
Hello Chris and thank you for the video! I have a question is there a way to get running total that resets each month? Thank you! If you want me to send you an example, I could add it here,
How do you have a running balance when you have several columns/field in the pivot table? for instance when i am having the following columns; Date,description, ref… Sum amt & running balances respectively in my pivot table. the running balance becomes distorted and it seems like other columns apart from the date which i have selected as a based are equally affected by the command applied. How do i deal with this one. Thank you
I am trying to use excel to make a material count list for a bid. I want to make a list of items and click on that item every time I find it on the material sheet. When I am done, I want to have excel tell me how much of each thing I have. Example: Black receptacle 20 amp; click that name each time I find one on the bid sheet. When completed, excel tells me how many I need.
Hi I was wondering if you could help. I have a spreadsheet showing all my expenses and a reason for the expense. I was wondering if it was possible to total up specific reasons, say money spent on groceries or fuel. Very informative video thanks!!!
My goodness. You are one of the best creators on CZcams EVER. I'm really awful at using Excel, and somehow I managed to find this video in a Google search. Man, I didn't know I needed pivot tables! I'm geeking out here. Thanks so much.
Sir, I can only say thank you. I was trying to do this on a laptop and look at 10 videos and you are the only one who said use the Fn button. I cannot thank you enough for taking away my frustrations.
Thank you for your videos! I check out MANY on youtube and by far your lessons are superior. Easy to follow, you talk at a sensible pace, all content is very organized. Excellent!
Joyce, thank you so much. I appreciate the positive feedback.
Thanks for making this video, I was doing a million formulas to accomplish this when it was so simple!
You're very welcome!
So simple and straight forward! Many thanks Chris!
Glad to help.
It looks simple, but quite a challenge. Great solutions, Chris.
Thanks 👍
Hello Chris and thank you for the video! I have a question is there a way to get running total that resets each month? Thank you! If you want me to send you an example, I could add it here,
How do you have a running balance when you have several columns/field in the pivot table?
for instance when i am having the following columns; Date,description, ref… Sum amt & running balances respectively in my pivot table. the running balance becomes distorted and it seems like other columns apart from the date which i have selected as a based are equally affected by the command applied.
How do i deal with this one. Thank you
Hello great tutorial. I need so help as well. It might be an easy question, but it got me searching for
Thanks, Jada.
@@ChrisMenardTraining Hello, do you happen to have a solution to my question?
thanks
You're welcome!
I am trying to use excel to make a material count list for a bid. I want to make a list of items and click on that item every time I find it on the material sheet. When I am done, I want to have excel tell me how much of each thing I have. Example: Black receptacle 20 amp; click that name each time I find one on the bid sheet. When completed, excel tells me how many I need.
Great 2
Thanks!
Hello, How do I use the pivot for ruining totals for days using a bank statement
David, are you asking if I download a bank statement as a csv file or excel, how to do the running totals?
Hi I was wondering if you could help. I have a spreadsheet showing all my expenses and a reason for the expense. I was wondering if it was possible to total up specific reasons, say money spent on groceries or fuel. Very informative video thanks!!!