I have reviewed at least five other videos on pivot tables and none were as easy to follow and informative as this one. I thought your accent would be an issue but it wasn't at all. I think you are the best on the web. So glad I found you.
How do I see the sheet of data it is pulling from? One of my clients had someone do a pt and it is pulling from a previous spreadsheet of data. They duplicated the spreadsheet so it is pulling from the previous year. How do I get it to pull from the current worksheet in this workbook?
It is the same principle as what I show starting at 09:29. On the "PivotTable Analyze" tab you can click on "Change Data Source" and there you can see where it is pulling the data from and also change the data source :)
Oh my goodness... I have avoided pivot tables for so long because I couldn't understand them at all. I'm so glad I decided to try again to learn and found your tutorial! This is a game changer for me. Thank you so much... you have magical teaching powers! 🪄
In the description box you can find a link to a data set that is similar to mine if you want to play around with Excel Pivot tables!
This video is award winning... Thanks
I never understood why or how to use pivot tables before but it all makes sense now. This will save me so much time. Thank you 😊
I'm happy to help! I actually used pivot tables today, they are so useful when you are working in Excel! :D
This is so informative but also easy to follow! Well done!
Thank you so much! 🤗
Fantastic! Best explanation of pivot tables that I've seen. Thank you.
I have reviewed at least five other videos on pivot tables and none were as easy to follow and informative as this one. I thought your accent would be an issue but it wasn't at all. I think you are the best on the web. So glad I found you.
A brilliant and easy to understand explanation. Thank you!
This was terrific. Thank you.
Clear and concise. Excellent!!👏👏👏
Excellent tutorial, thank you
I'm glad you liked it! Thanks for telling me!
Love the video!
can u provide a link for dowloading this excel for practise
excellent video, helped me a lot today.
This was perfect thank you!
Thank you
How do I see the sheet of data it is pulling from? One of my clients had someone do a pt and it is pulling from a previous spreadsheet of data. They duplicated the spreadsheet so it is pulling from the previous year. How do I get it to pull from the current worksheet in this workbook?
It is the same principle as what I show starting at 09:29. On the "PivotTable Analyze" tab you can click on "Change Data Source" and there you can see where it is pulling the data from and also change the data source :)
thanks !
THHHHAAAANK YOOUUUUU!!!
Oh my goodness... I have avoided pivot tables for so long because I couldn't understand them at all. I'm so glad I decided to try again to learn and found your tutorial! This is a game changer for me. Thank you so much... you have magical teaching powers! 🪄
That makes me so happy to hear! I'm glad you liked the video, I strive to make all my videos super helpful and easy to follow :D
Me too ...😢