Affiliates

Amazon.com


Popular Microsoft Excel Books

Excel 2003 Bible
Excel 2003 Bible
Author: John Walkenbach 

Excel 2003 for Dummies
Excel 2003 for Dummies
Author: Greg, PhD Harvey 

Microsoft Office Excel 2003 Step by Step
Microsoft Office Excel 2003 Step by Step
Author: Curtis Frye 

Excel VBA Programming For Dummies
Excel VBA Programming For Dummies
Author: John Walkenbach 

Excel 2003 Personal Trainer
Excel 2003 Personal Trainer
Author: Inc 

Microsoft Office Excel 2003 Inside Out
Microsoft Office Excel 2003 Inside Out
Author: Craig Stinson 

Excel 2003 All-in-One Desk Reference for Dummies
Excel 2003 All-in-One Desk Reference for Dummies
Author: Greg Harvey 

Popular MS Excel Related Websites

Microsoft Corporation 













Microsoft Excel 2007 Tutorial for beginners    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

  Microsoft Excel Tips and Tricks for beginners
Pivot Data {Tutorial for beginners}  
 
Written by Upendra Kumar  
Saturday, 07 July 2007
Category MS Excel 2007 - Pivot Table.  
 
General Information
 
 
Creating a basic Chart
 
 
With the Pivot data you can see the same information in differents layouts with a few clicks. 
 
Illustration 1: Sample Pivot Table Report.
 
Dynamic Tables (or Pivot tables) are summarized rows whose source data belongs to a sheet. 
 
Creating a Pivot table
 
1) When you create a dynamic table, each column of its source data becomes a field that can be used in the pivot table. The fields summarize rows of information of the data source.
 
2) The name of the fields for the pivot table comes from the titles of the columns of their data source. Verify that you have names for each column of the first row of the spreadsheet of the data source.
 
3) The remaining rows that appear under the headers would have to contain similar elements of the same column in the data source.
 
4) it must not have empty columns in the data that are using for the report of the dynamic table.
 
5) Open the Table Usage.xlsx Sample.
 
Illustration 2: Table usage sample excel file.  Click here to view larger image.
 
6) Select the data that wish to represent, including the titles of the columns.
 
7) Select the Insert menu and the Pivot Table command from the Tables Group.
 
Illustration 3: Creating Graphs.
 
8) Notice that the range will be automatically displayed.
 
Illustration 4: Select the range.  Click here to view larger image.
 

 
Advertisement



Advertisement



Copyright MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster