The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

This article will teach you how to create drop-down lists in Microsoft Excel using a feature called Data Validation. When applied, the Data Validation function serves to restrict data that can be ...

Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how.