Excel PivotTables Made Easy - And Why Things Go Wrong!

Excel PivotTables are an awesome productivity booster, but many people find them difficult and scary. In this video I'm going to show you the easy way to make PivotTables and the common mistakes that give them their 'scary' moniker. May you never be scared of PivotTables again!

[melissalee]

This is the FIRST time I have watched an excel pivot table training sesh that I could truly follow and understand clearly. I super appreciate your video and sharing your training for everyone! Finally, I am NOT intimidated by pivot tables and the data!! THANK YOU :)

[houstonvanhoy]

Mynda: Your closing music is so much nicer than some of the music which other Excel gurus - who will remain unnamed here - use in their videos. Thank you.

[paddleboardadventures]

I usually figure out my pivot table trial-and-error. Now I understand them. Brilliant as always Mynda!

[chrism]

Thank you for this, finally, Pivot Tables explained in a simple easy to follow lesson with working examples. Unfortunately, I am still on 2010 but even that didn't hinder the tutorial. Thank goodness for Mynda, I learned so mush from this that every other tutorial missed...

[abednegomulumbi]

I used to think PIvot tables are complicated, but now I have seen where the controls are. Thank you once more, great teacher

[trevore]

This is the clearest explanation of what the underlying table structure needs to be in and why it needs to be that way. Showing the “partially pivoted” data being reformatted correctly so that power pivot can do its job was exactly what I needed for it to sink in. Thank you!

[davegoodo]

Thanks Mynda, this is a great message! It helps me to remember “Keep it Simple”, Pivot Tables can get unwieldy very quickly without having a clear plan of attack as you have graciously shown us. I have learned a lot from your video, thanks as always and keep them coming!

[carolind]

This was very helpful! I really appreciated the “what not to do” section. I’ve tried pivot tables before and they never worked, probably because my data set was incorrect. Very useful video!

[shashanksuthar]

Thank you very much, by seeing your videos I feel excel learning is way more easier than I was thinking. Thank a lot.

[Ntentes]

You are the best excel teacher on youtube by far. Simple and clear lessons.

[vijayarjunwadkar]

Thanks Mynda! Even after spending good amount of time on most Excel features, there is always something new to learn and your videos help in that! Keep doing the great work! 😊👍

[BevRoot]

Thank you for focusing on how to create the original dataset. That's what is missing in so many online videos on Pivot Tables. excellent!

[carlymardon]

I come across your videos the other day and found them really interesting and detailed but most importantly, understandable. I had the chance to utilise the information and something that could have potentially taken a day took just over an hour. Amazing. Also linking the data to a folder, means this will be an ongoing way of extracting information from a number of forever changing data sources 👍🏻 thank you

[TheSkiggly]

Looking back over the past months, where I was vs where I am today - I must say how valuable you are to me and other like me. Your lessons make learning easy and the information is always spot on. What's really amazing is - I'm just scratching the surface of this program.

[gatasucia]

Thank you! I love how clear your instructions and explanations are.

[tracyt]

Will be starting a new job and have been out of the work force for some time. This was very helpful!

[martyf.]

Thanks for getting back to me. I played around and found out how to change column titles (a report with "Sum of Costs" instead of just "Costs" as a column title didn't look good).

I've been using Excel for 25 years (don't ask how old I am (😂)) and never used a pivot table but playing around with them now seems like a great tool in the Excel arsenal.

Thanks again.

Marty

[Ahmed-fqsi]

Suffice it to watch some other youtube videos talking about the same subject to come to the conclusion that you're the best. It is very well done both in terms of form and content.

[cshahed]

I understand the power of Pivot Table but somehow never got a grip of it. This clip was a good starter for me to simplify things. Many thanks

[VirtualArcades]

Solid and easy to understand instructions without too many assumptions from an instructor pov. Nice work!