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.
Watch the Video
If you need a quick refresher on how to insert a PivotTable you can view my old fashioned written tutorial with supporting images!
Download the Excel Pivot Table Practice File
Enter your email address below to download the sample workbook.
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:
Hi Mynda, thank you for the wonderful tutorial. It cleared all the doubts I had about Pivot tables.
Wonderful to hear, Sanath!
Hello
I wanted to ask you when you split columns from transform tab, if we want to select particular length of characters , whcih are not same in entire column, how to specify the no of characters.
In the split columns drop down there’s now an option to choose a set number of characters.
KINDLY FROM SCRATCH HOW TO BUILD PIVOT TABLE
UNTIMATE GOAL IS TO WACH SHIPMENTS HOME TEXTILE AND GARMENTS
TO ALL OVER THE WORLD
PIVOT TABLE HELP TO MONITOR DATA
I ATTACH EXCELL SHEET FORMATING TO CONTROLL SHIPMENTS JUST FOR UR KIND VIEW PLEASE NOT ABLE TO SEND AS THERE IS NMO PLACE FOR ANY ATTACHMENT
ALSO MAKE SOME ATTACHMENT AREA WHER WE ATTACH OUR WORKING
WHICH HLEPS TO UNDERSTAND ENHANCEMENT IN WORKING AS WE WORK AND AS UR WORK MAKE IT BETTER IN SHAPING WITH LATEST TEQNIQUES
AWAITING FOR ATTACHMENT AREA SO THAT WE SEND WHAT I WANT TO SHARE WITH URSELF.
THANKS FOR TAKING UR PRECIOUS TIME
Hi Rana,
Please use our forum to open a new topic with your request, you can attach there files: Excel Forum
Please share the raw data
I don’t have the raw data for that tutorial easily to hand, but you can download some data for PivotTables here: https://www.myonlinetraininghub.com/pivot-tables-explained-excel
wonderful
Thank You Treacy & team (myonline Training Hub). This Tutorial makes it much clearer & easier for me to use pivot tables.
Thanks for today,and am looking forward to receiving newsletter, it is indeed very interesting to learn the Excel as it is an additional knowledge, I almost forget so may things about excel as I always use MS Word.
Your new member,
Vergenia
Welcome, Vergenia 🙂 Glad you enjoyed the tutorial. Many more to come in the newsletter.
You made the pivot table very easy and quickly understandable.
Thanks, Ozen 🙂 I hope you’re now using PivotTAbles whenever you can.
Clear, Concise and Compact.
Thanks, $$ 🙂
The video is clear and very easy to understand. I had already extracted my raw data and I was able to clarify what I wanted to do after watching the video.
Thanks, Cheryle 🙂 Glad I could help.
I am truly amazed at the complexity of Excel and what it will do I can only express admiration for the designers who write the programme as we are only attempting to use a programme they have provided. I find your explanations and presentation first class. I have always been a Paradox and Access user so Excel is another world
Thanks, Keith. Glad you’re finding our tutorials helpful 🙂
Hi Raju,
The video is an embedded YouTube video. The video plays fine for me. It may be that you have restrictions on viewing YouTube on your firewall.
Kind regards,
The video is not working. Unable to watch the video. Nothing is visible on my screen.
Raju
Hi Raju,
The video is an embedded YouTube video. The video plays fine for me. It may be that you have restrictions on viewing YouTube on your firewall.
Kind regards,
Mynda.
Hi Raju,
As Mynda said its one of our YouTube videos and uses Flash. It may be that your computer doesn’t have Flash installed properly.
Or you could watch the video straight off You Tube
Or you can try a different browser like Chrome
Regards
Phil