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.
By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.
Download the Excel Workbook and follow along. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.
Fix Data Layouts with Power Query Unpivot
Happy 25th Birthday Excel
RANA GULZAR AHMAD QAMAR
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
Catalin Bombea
Hi Rana,
Please use our forum to open a new topic with your request, you can attach there files: Excel Forum
lohith
Please share the raw data
Mynda Treacy
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
Hassan Suma
wonderful
Joan Kizito N
Thank You Treacy & team (myonline Training Hub). This Tutorial makes it much clearer & easier for me to use pivot tables.
Vergenia Ramos
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
Mynda Treacy
Welcome, Vergenia 🙂 Glad you enjoyed the tutorial. Many more to come in the newsletter.
Ozen Kandirali
You made the pivot table very easy and quickly understandable.
Mynda Treacy
Thanks, Ozen 🙂 I hope you’re now using PivotTAbles whenever you can.
SS
Clear, Concise and Compact.
Mynda Treacy
Thanks, $$ 🙂
Cheryle
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.
Mynda Treacy
Thanks, Cheryle 🙂 Glad I could help.
Keith Jarvis
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
Mynda Treacy
Thanks, Keith. Glad you’re finding our tutorials helpful 🙂
Mousa Al-Balouli
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,
Raju
The video is not working. Unable to watch the video. Nothing is visible on my screen.
Raju
Mynda Treacy
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.
Philip Treacy
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. You can download and install the latest version here http://get.adobe.com/flashplayer/
Or you could watch the video straight off You Tube http://www.youtube.com/watch?v=UoWIhmZj_i4&feature=player_embedded
Or you can try a different browser like Chrome https://www.google.com/intl/en/chrome/browser/
Regards
Phil