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
Consolidate Data {Tutorial for beginners}  
 
Written by Upendra Kumar  
Saturday, 07 July 2007
Category MS Excel 2007 - Data.  
 
General Information
 
 
Duplicated rows removal
Data Validation
Creating Pivot Charts
Dynamic Formulas
 
 
In this tutorial, you will learn how to work with consolidated data. 
 
Duplicated rows removal
 
1) Open the Sample.xlsx Sample.
 
Illustration 1: Sample book.
 
2) As you can see, rows 7... 9 and 12 ... 14 have the same data. Select the F1 cell.
 
3) Select the Remove Duplicates command from the Data Tools Group in the Data in the Options Tape.
 
Illustration 2: Select Remove duplicates command.
 
4) Select the columns that you suspect to have duplicated data and press the OK button.
 
Illustration 3: Select duplicated columns.
 
5) Excell removes duplicated rows and raises a message.
 
Illustration 4: Duplicated removal results.
 
Data Validation
 
6) Go to the next free row.
 
7) Select D35 cell.
 

 
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