Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

CSV files create columns of data from a variety of sources, such as address books and GPS location lists, and VLOOKUP enables your business to analyze these sources.

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.