Video: How to Make a Pivot Table in Excel 2007

This Season: Tailgating; Tech Know; New Year, New You; Tax Time

Make a Pivot Table on Microsoft Excel 2007 by opening a new template, highlighting the data and clicking Insert. Insert highlighted data to create a Pivot Table in Excel with insight from an IT professional in this free video on computer software.

Comments

zanderosnhold Sep 08, 2011
can you help me to learn the of pivot../.
ANjell Jul 05, 2011
me either.
Hon Jun 15, 2011
I want know a lot about excel.

Video Transcript

Hello my name is Eric White and today we're going to talk about how to insert a pivot table into an Excel spreadsheet. So let me guess, your boss came to your desk and said "I need a pivot table" with his little pointy hair sticking up, "I need a pivot table, do it now". Well this is how you do it. You open up your spreadsheet. Highlight the data that you want you want to make a pivot table on. Click on insert. And then right here on the left is pivot table. Now it says click here to summarize data using a pivot table or to insert a pivot chart. Pivot tables make it easy to arrange and summarize complicated data's, and drill down on details. That sounds like what the boss wants. So let's go ahead and hit insert pivot table. Now since the data is already highlighted the range shows up here. Now we got it set to put it in a new worksheet. So we hit o.k. This automatically creates your new pivot table in a new worksheet preceding the worksheet you were in. Now right now the pivot tables empty, so on the right hand side here you click on the data you'd like to include in your pivot table. And if you notice as I click these, it populates the pivot table. And that's all there is to inserting a pivot table on Excel spreadsheet.

Follow eHow: Follow @eHow

How to Make a Pivot Table in Excel 2007

Comments

Related Ads

Related Articles & Videos