LDT_How to filter for unique values or remove duplicate values

Applies to: Microsoft Office Excel 2007

In Microsoft Office Excel 2007, you have several ways to filter for unique values or remove duplicate values:

• To filter for unique values, use the Advanced command in the Sort & Filter group on the Data tab.
• To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Data tab.
• To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.

How to Set the default location of documents (2007)

Do you waste time clicking with your mouse because Word does not point to the folder of your choice whenever you Open or Save a file? The default is often set to 'My Documents'. But most people need to save their documents in a project or functional folder on their network drive eg S: or P: drive...

So why not spend a few moments and change the folder Word looks in by default? You only need to do this once and it only takes a few moments.

• With Word 2007 open, select the Office button 
• right click, then select Custom Qick Access Tool Bar.
• Select the Save tab
• To the right of the 'Default file location:' box, click the Browse button

• The Modify Location box is displayed
• In the 'Look in:' box, click the down-arrow and locate your required default file location
  
   
• Click OK >> OK
• Now when you Open or Save a file, the location you specified above is displayed

 

SPPID_How to covert SPPID to MicroStation or AutoCAD

1. Click file, and then save as.

2. Click save as type, there’re several choice include Micro Station and AutoCAD.