Easy Steps Remove Duplicate Records in Excel 2003 ,2007,and 2010

Generally in office 2003, the option for removing duplicate records is hidden compare to office 2007.

So Here is the Simple Steps to Remove Duplicate records from Excel 2003

Step1:Select the row or column that contains duplicate record, that you would like to remove.

Step2: Go to Data-----Filter Range--->click Advanced Range

Step3:Make sure that range is correct and check the option “unique records only“,as shown in figure. press Ok.

Now Duplicate records are removed. By using this option you can either choose replace the content option or copy unique records to a new location.

Steps to Remove Duplicate Records in MS Excel 2007

In MS Excel 2007 selection(Highlighting)of duplicate records and deletion of that record is a easy task compare to office 2003.

Step 1 :Select the columns or rows which is having duplicate records.

Step2 Go to the Data tab and under data tools, click Remove duplicates. This would remove duplicate records and cells from selected row and column.

Steps to highlight duplicate cells in Excel 2007

Select the cells which you want to highlight Click on Home tab --->Styles, Click on Conditional Formatting. Go to Highlight Cell Rules option and Click Duplicate Value.

So here you can highlight the duplicate cells or the unique cells by selecting values in styles.

Steps to Remove Duplicate Records in MS Excel 2010.

In Office 2010 MS Excel Removal of Duplicate records is too easy.The cool part is that you don’t need to select any specific row before removing the duplicate rows, the built-in Remove Duplicate feature will monitor the your content.

Step1: Select the portion of your excel table.

Step2: Go to data tab Click on remove duplicates.

Duplicate records are now removed and you will get confirmation message as shown in this figure

[ office Excel 2010 Figure Credit:http://www.addictivetips.com]

5 Excellent Online HTML Tutorials

1.W3School

W3Schools, you can study everything you need to learn, in an accessible and handy format.It is very famous for HTML Online tutorials



2.HTML DOG
If you have looked at tutorials, you might have found that they mention certain things that HTML Dog does not. This is because many methods are obsolete, non-standard or just plain bad practice. Getting into the frame of mind of doing things the right way from the start will turn in to much better results in the end.


3.HTML.NET

This site also provides a good HTML Tutorial will give you an easy, yet thorough and correct introduction on how to make websites. The tutorial starts from scratch and requires absolutely no prior knowledge of programming.


4.Quackit
This Another HTML Tutorial is for beginners. It teaches you HTML from the ground up - starting with the basics. Coding HTML is actually quite easy - as this tutorial will show you.


5.HTML Code
HTMl code goal is to provide the most helpful and complete guide to creating web pages anywhere

Adobe Photoshop CS4 Tutorial

Adobe Photoshop Part 1: The Photoshop Interface - Photoshop Free Tutorials

Welcome to the free Adobe Photoshop Part 1 Tutorial
Adobe Photoshop is a professional graphics and photo editing software. Popular among graphics designers and web designers, Adobe Photoshop has a very powerful set of tools and utilities. If you're a beginner with Photoshop, this tutorial is the perfect way for you to understand the interface and how to use Adobe Photoshop. This free course is great for mastering the basics of Adobe Photoshop at your own pace and according to your own schedule - without spending any money. This free course is taught in an easy to understand manner with plenty of examples and screenshots.
In Part 1, you will learn:
1)The Photoshop Interface
2)How to create a new image
3)Saving your work
4)Opening an existing Photoshop image
5)Using the status bar
6)Using the toolbox
7)Using palettes
8)Changing screen modes
9)Using the zoom tool and navigator palette
10)Using undo
11)Using the file browser

If you would like to continue on to Part 1 and Part 2: Using Colors and Painting, of our free Adobe Photoshop tutorials, please click here.

Click Next Page below to continue on with this free Adobe Photoshop tutorial!

Also read

1.Adobe dreamweaver tutorial

2.Free computer courses

How to Configure Outlook 2007

Configuring your email client: Outlook 2007
Open Outlook 2007.
Click the Tools menu, and select Account Settings.
Configure Outlook 2007
or
From Microsoft Websites

Adobe Dreamweaver CS4 Tutorial

Welcome to the Dreamweaver CS4 tutorial!

In this tutorial, we will explore the new features of Dreamweaver CS4, the Dreamweaver CS4 interface, new CSS support, how to create a new site, inserting content, and more. This instruction-packed tutorial will help you on your way to becoming an Adobe Dreamweaver CS4 expert!

What is Dreamweaver CS4?
Dreamweaver is a powerful but easy-to-use web site development program that bridges the gap between designer and developer. Although it includes advanced features for developing complex data-driven applications, Dreamweaver’s intuitive interface and extensive libraries let even the novice web designer develop a professional web site quickly and easily.

If you’re new to CSS, Dreamweaver includes a large number of predefined CSS layout pages, which make it possible to create professional-looking layouts that conform to the latest in web standards.

Click Here For Online Adobe Dream weaver Tutorial

Microsoft Excell 2007 Tutorial

Welcome to Microsoft Excel 2007!

There are several applications in the Microsoft Office suite, but some could argue that the most powerful and important one to the business world is Microsoft Excel. Many power users of Excel have been able to leverage their Excel knowledge into an impressive career path.

Microsoft significantly redesigned the user interface in all of the Office 2007 applications with a new "ribbon" interface - burying the classic menu and toolbar navigation. Microsoft Excel 2007 has many new features designed to increase your productivity and help you more easily create powerful spreadsheets.

This Free Microsoft Excel 2007 course teaches you how to use the new interface and walks you through creating a family budget spreadsheet. 

Author Jeremy Reis teaches you how to enter data, format cells, use formulas, setup conditional formatting, and more. You will learn a solid foundation for using Microsoft Excel 2007.

At the end of this free course, you will have a powerful spreadsheet you can use as a family budget.

For Tutorial Click Here

Enjoy!

Microsoft Windows Vista tutorial-Learn vista online in 2 days

Microsoft introduced Windows Vista to much fanfare. It represents an evolution from Windows XP Professional and includes many new features and system requirements. With those new features comes some new complexity - and combined with Microsoft Office 2007 - a new understanding of how everything works together. Vista is the biggest change in the GUI in years and learning some of the time saving techniques will help you be more productive with the new Operating System.

This is the Microsoft Foundations training course covering topics such as:

• Introduction to Microsoft Windows Vista
• Windows Aero Interface
• Using Windows Vista
• Sharing Files in Windows Vista
• Networking and Windows Vista
• New Security Features in Vista
• Internet Explorer 7 and Other Browsers
  

Go to Tutorial Page

Enjoy this free Vista tutorial!