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.

I recommend starting with a simple database type list if you can, and if you’re using Excel to analyze that data. For instance, the sheet in Figure B stores customer invoice information.

In this Excel tutorial, I’ll show you how to run subtotals on a simple data set and then quickly apply formatting that will make those totals really stand out. SEE: Software Installation Policy ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends. Skip to main content Menu ...