Beginner’s Guide to Excel Pivot Tables (for Dummies)

[@emelielindstroem]

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!

[@elinorlindstrom460]

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 😊

[@emelielindstroem]

I'm happy to help! I actually used pivot tables today, they are so useful when you are working in Excel! :D

[@MrGordonSims]

This was terrific. Thank you.

[@Horseyqaqa]

This is so informative but also easy to follow! Well done!

[@emelielindstroem]

Thank you so much! 🤗

[@angelosdeftereos6284]

A brilliant and easy to understand explanation. Thank you!

[@MTBPA]

Clear and concise. Excellent!!👏👏👏

[@tonyf2346]

Excellent tutorial, thank you

[@emelielindstroem]

I'm glad you liked it! Thanks for telling me!

[@tchandrakumaran8268]

excellent video, helped me a lot today.

[@anjelicacapellupo7633]

This was perfect thank you!

[@TomPaholski]

Thank you

[@gabbyrodriguezbarragan8286]

thanks !

[@jayterry6558]

THHHHAAAANK YOOUUUUU!!!

[@VirtualBusinessTasks]

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?

[@emelielindstroem]

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 :)

[@tamaralynn2069]

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! 🪄

[@emelielindstroem]

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