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.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.

Microsoft's premade templates allows for the deployment of SQL databases without having to use complex PowerShell commands.

I consider myself an Excel poweruser. I program in it daily (20ish hours a week) and manage a few thousand lines of code for my personal use (stocks and finance). Outside of Excel, I know very ...