Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to ...

A custom AutoFill series is a list ... Let’s work through a quick example using Excel 2003: This method has three benefits: You won’t have to re-create the list if the first item changes.

However, Excel is much more powerful than that. It can be used to create a searchable database – an Excel database. The database capabilities of Excel are very powerful. In fact, not only can ...

JD Sartain If you’re not downloading the workbook, open our article, Excel databases: Creating relational tables, and follow the instructions to create a sample relational database. Single ...

In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on that data. It's a handy program to have ...