Comments on: How to use Pivot Tables in Excel - tutorial for beginners

In this Excel pivot table tutorial you will learn what a PivotTable is, find a number of pivot table examples that will help you to get started quickly and see how to create and use pivot tables in Excel 2016, 2013, 2010 and 2007. Continue reading →

Table of contents

Comments page 2. Total comments: 31

  1. Im trying pivot table but (Range&source) create a problem how to fix this problem please help me

  2. As usual, _great_ instructions. I've been out of the loop a bit with Excel, and they've really added some powerful and cool features to the product.

    One minor typo in the instructions - it should be 'Insert' instead of 'Inset' in the line below.
    To do this, select all of the data, go to the {Inset} tab and click Table.

    Anyway, impressive work, thanks very much!!

  3. Hi- I am trying to create a pivot for survey responses.... the answers to one of the questions is actual text responses such as "Excellent, Good, ect." Is there an easy way to sort these responses in a pivot? The remaining questions on the survey are numeric responses ranging 1-5, those are working great. It's the text one I am struggling with.
    Thanks,
    Deb

  4. Wow. What a wonderful explanation. Thank you very much.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)