Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.

Duplicate entries may be valid -- but when they aren't, they can derail your summaries and totals. Use Excel's Validation feature to reject duplicate entries.

The data in a table containing numbers is selected, and the More Number Formats option in Excel's Number Format drop-down list is highlighted.