::: Excel tips 15 :::

>> Opening a workbook at start up <<

If some of your users spend much of their day working in a specific workbook, you can teach them how to designate that workbook to open each time Excel launches. All they need to do is place the workbook (or a shortcut to the workbook) in the XLStart folder. This technique also works with network shortcuts.
You'll find the XLStart folder in the same place as the Excel program files—typically C:\Program Files\Microsoft Office\Office. After placing the file or shortcut in the XLStart folder, the user can just restart Excel to see the file pop open automatically.

--------------------------------------------------------

>> Hiding duplicate records <<

One of the most common mistakes users make in preparing a report or sorting data is including redundant entries. For example, if a worksheet keeps a running tally of purchases made by Customer 1, there's no need to report cells other than the ones keeping the composite figures. A built-in filter in Excel will take care of this problem.
Follow these steps:
Choose Data | Filter | Advanced Filter.
Drag across the worksheet to select the lists containing duplicate entries.
Select Unique Records Only.
Click OK.
Excel will now hide any duplicate records in the selected range.