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.

How to Make a List of Excel Data Into Data Separated by Comma. Microsoft Excel 2010 stores data within cells, which are simply segregated pieces of the spreadsheet that Excel can then reference to ...

Image: AndreyPopov, Getty Images/iStockphoto The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down.