SEO

To remove duplicate records in Excel do the following:

1. Select the column title that has duplicate records
2. Click Data menu and point to Filter, and then click Advanced Filter
3. Under Action, click Copy to another location
4. Select the starting location where you want to copy all the unique records by clicking on a cell
5. Click to select the Unique records only check box
6. Click OK.

You should have all duplicates removed in this new location.

To change user account password from command prompt do the following:

1. Click Start
2. Type “cmd” in Run field
3. On the Command prompt type “net user username newpassword” and hit enter

Voila! the password is reset.

Note: To change password from command prompt, you must login with an administrator account.