Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas:
- Simple Tables, which I’ve used since Excel 2.0.
- Excel Tables, introduced in Excel 2007.
- PivotTables with a Tabular Report Layout, introduced in Excel 2010.
Database experts likely would be offended by my calling any of these a “database.” After all, these three spreadsheet databases are easy to set up and use…not at all like a “real” database. Even so, these databases work like a real database for your Excel formulas. If your reports and analyses can get their data from one of these types of spreadsheet databases, you can improve your reporting and analyses significantly.
In this post, I’ll introduce each type of spreadsheet database. Then in future posts, I’ll go into greater detail. [click to continue…]