Hi ,

An Excel Pivot Table is one of the most powerful productivity tools available, but some common data layout mistakes can make Pivot Tables difficult, frustrating and downright scary for some users. Thankfully these issues are easily fixed.

I've put together a short video that'll get you started with Pivot Tables, and when your data is formatted correctly you'll see how easy they are.

Plus, I'll identify what data layouts are going to cause you problems and how to fix them.

If you need a quick refresher on how to insert a PivotTable you can view my old fashioned written tutorial with supporting images!

Prefer to read this on our website? 

Then click this link >>> Excel Pivot Tables Made Easy

Video: Excel Pivot Tables Made Easy

Watch on YouTube Subscribe 590K

Download Example File

Download the file and practice the things I demonstrate in the video.

BONUS : Fix Data Layouts with Power Query Unpivot

If your data is not in the correct tabular layout for PivotTables, check out the video below on how to easily fix it with Power Query:

Watch on YouTube Subscribe 590K

Have a great day,

Mynda Treacy

Co-founder My Online Training Hub

Want to sponsor our newsletters?  Just reply to this email to get in touch with us.