My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Excel Pivot Table Video Tutorial

You are here: Home / Excel PivotTables / Excel Pivot Table Video Tutorial
Excel Pivot Table Video Tutorial
by

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

Subscribe YouTube

 

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.

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:

Subscribe YouTube
Excel Pivot Table Video Tutorial

Microsoft MVP logo

AUTHOR Mynda Treacy Co-Founder / Owner at My Online Training Hub

CIMA qualified Accountant with over 25 years experience in roles such as Global IT Financial Controller for investment banking firms Barclays Capital and NatWest Markets.

Mynda has been awarded Microsoft MVP status every year since 2014 for her expertise and contributions to educating people about Microsoft Excel.

Mynda teaches several courses here at MOTH including Excel Expert, Excel Dashboards, Power BI, Power Query and Power Pivot.

More Excel PivotTables Posts

Advanced PivotTable Techniques
Discover 7 advanced Excel PivotTable techniques to streamline your data analysis and create dynamic, insightful reports with ease.
Sorting Excel Date Slicers
Use these tricks to custom sort Excel Slicer buttons enabling them appear in a specific order that suits your needs.
PivotTable Formatting
Create PivotTables that don’t look like PivotTables with these really easy PivotTable Formatting tips and tricks.
Images in Excel Pivot Tables
Include images in Excel PivotTables, combined with some slick formatting, and create dynamic and visually rich PivotTables like never before.
Auto Refresh PivotTables isn’t on by default, and the process differs depending on if your PivotTables is loaded to the data model or not.
Show Items with no Data in PivotTables allows you to maintain a constant structure to your PivotTable or Pivot Chart axis when filtering.
There's no build in way to force Excel Slicers to single select but we can use these clever warnings to persuade your users.
excel pivottable p&L
Creating an Excel PivotTable Profit and Loss Statement means you can use Slicers and Conditional Formatting and have the P&L automatically update.
Customize the Excel PivotTable Field List to suit your needs. Find how to turn the PivotTable Field List on and off and other handy tips.
Hide blanks in Excel PivotTables caused by empty cells in your source data. I’m talking about PivotTable cells containing the (blank) placeholder.


Category:

Reader Interactions

Comments

  1. Sanath Dissanayake

    Hi Mynda, thank you for the wonderful tutorial. It cleared all the doubts I had about Pivot tables.

    Reply

  2. Gulfareen

    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.

    Reply

  3. 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

    Reply

  6. Joan Kizito N

    Thank You Treacy & team (myonline Training Hub). This Tutorial makes it much clearer & easier for me to use pivot tables.

    Reply

  7. 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

    Reply

  10. 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.

    Reply

  11. 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

    Reply

  12. 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,

    Reply

    • 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.

      Reply

Trackbacks

Leave a Reply

Your email address will not be published. Required fields are marked *

Current ye@r *