Overview of Power Pivot Ribbon

Now that you have installed Power Pivot, lets understand how the Power Pivot ribbon is set up.

What is in this lesson?

  • Introduction
  • Power Pivot Ribbon in Excel 2010
  • Comparison with Excel 2013
  • Creating a linked Table in Power Pivot
  • Adding a Power Pivot to your workbook
  • What next?

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

23 thoughts on “Overview of Power Pivot Ribbon”

  2. Hi Chandoo,

    I am using Excel 2011 in Mac OS. I am able to build pivot table but I am not sure if the functionality is as complete as the versions in Windows. Incidentally, I have Excel 2013 but it does not come with Power Pivot.

    Thanks
    Serene

  3. While using the downloaded file, I am getting the following error message:
    You are attempting to access PowerPivot data that was added using a newer version of PowerPivot. This action is not supported, and you cannot access the data. To continue working with the PowerPivot data, you must use the latest version of PowerPivot.

  4. Ahhh.. My blood pressure is going down! Thanks Chandoo.. you are presenting this in ‘episodes’ almost as a ‘cliff hanger’ on a television program, making you want to tune in next week to see how the hero came out.
    Kidding aside, good presentation and you keep it manageable and easy to follow. Looking forward to the next module.

  8. Chandoo, What is the difference between Normal Pivot Table and Power Pivot ?
    Explain atleast with 5 to 10 points about these comparison.
    & Why Excel user switch to using Power Pivot ?
    Thank You

  10. Can we insert the pivot table to Power Pivot Workbook? Because when I insert the pivot table, the pivot table is getting placed in original workbook where source data is.
    Thanks

  12. Hi Chandoo,
    I cannot get access to some of the modules in Power Pivot and Advanced Power Pivot in particular the downloadable materials.
    My log in access expires today but I have not been able to make use of the above videos.
    Kindly check my account if there are any issues.

  14. Hi Chandoo,

    Just a minor FYI…the link for the video works fine, but hyperlinked text says, “Installing Power Pivot – MP4 file.”….I think you meant to label it something like “Power Pivot Ribbon Overview – MP4 file.”

    In the meantime….keep up the good work!

  16. Hi

    I just realized after referring few lesson of powerpivot that my excel 2013 not getting effect of powerpivot at all.
    I use excel 2013 (office professional plus 2013)

    I create powerpivot by clicking on pivot table in powerpivot data sheet view. Then I check in my original excel that I have Pivot table in excel not powerpivot.
    Means I can not see option of slicer vertical and slicer horizontal.

    I have already installed power pivot by COM Add In ( Microsoft office powerpivot for excel 2013 and power view , both of them checked)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.