Excel Spreadsheets: Navigation, shortcut keys, data sort and filter, formulas and functions We start with the basics for navigating, entering, and calculating data.

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

How to Make Excel Data Horizontal. When you start fresh in Microsoft Excel, you have two options to enter data – horizontal and vertical. But after entering vertical or columnar data, it can ...

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.

Microsoft announced an Excel update that lets users disable the automatic conversion of data into dates. Here's how to change the setting.

In the Excel context, I'd use it in the programming sense, and the reverse, as a check to ensure that all tagged/typed data is included, and, if not, a friendly warning is issued.