eHow launches Android app: Get the best of eHow on the go.
(0 Ratings)
How to Create a Form for the Web in Excel
How to Get Rid of Screen Glare
How to Dispose of Printer Toner Cartridges
How to Install a TV Tuner Card on a Computer
How to Convert MP4 to MP3
How to Find Replacement Laptop Keys
How to Download a SNES Emulator
How to Make a Pivot Table in Excel 2007
How to Fix Sticking Laptop Keys
How to Find Cheap Ink for a Computer
How to Find New Mouse Cursors
How to Install Cursors
How to Get the Most Use Out of a Printer Cartridge
How to Copy Bin Files to DVD
How to Find Refurbished Ink Cartridges for a Brother Printer MFC420CN
How to Install the Dell 720 Photo Printer on Windows XP
How to Find Canon Printer Cartridges
How to Get Rid of Adware.Win32
How To Replace Ink for the Epson CX1500 Printer
What is AI Used for?
What is ISO?
What is a Use Case?
What is Print Contrast?
What are Some Practical Uses for Excel?
How to Replace Ink Cartridges on a Canon Printer
Installing Microsoft Office 2007 for Vista is simply done by inserting the program CD into the computer an… More
Microsoft Excel is more flexible and useful than most people realize. Although Excel is a popular spreadsh… More
There are two functions to use when calculating APR in Microsoft Excel. Use "PMT" and "Rate" functions in … More
Make a Pivot Table on Microsoft Excel 2007 by opening a new template, highlighting the data and clicking I… More
The easily viewed gridlines and multiple cell-formatting options of Microsoft Excel's worksheets make it t… More
Microsoft Excel spreadsheets allow users to create columns and rows that define and display data, as well … More
Microsoft Excel is a great application to use if you need to create a spreadsheet, make a chart or calcula… More
While you cannot really make address labels in Microsoft Excel, Excel can be a big help when you need to p… More
When you're searching for the perfect new home, it is important to know whether the mortgage payments will… More
Looping in Microsoft Excel allows users to automate the entry of data into columns and rows. Learn how to … More
You can create concise databases and lists in Excel. You can also make colorful, comprehensible charts and… More
Many businesses and people use decision trees as an important tool to determine outcomes. It is a type of … More
Summary: 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.
Eric White is a workflow manager. He manages a global operations team for a software development company in Austin, Texas. Eric has more than 10 years in the IT field spanning...read more
"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."
eHow Article: How to Make a Pivot Table in Excel 2007
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
