Relational databases are similar to Excel workbooks that contain multiple sheets, but are generally more flexible and powerful.

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.

Brilliant Database is a relational database package that includes table design, reporting, scripting, and all the other features needed to make a usable business tool, at a very low price ($80).

While Excel is an ideal software for creating and managing databases, it may not be easy to navigate when dealing with thousands of rows and columns. Here is where Power Pivot comes in, since it ...

One underappreciated aspect of this transformation is the shift in how companies use online transactional processing (OLTP) relational databases. Challenges arising from how data is processed ...

Matt Yokovit, the Chief Experience Officer at Percona, that has both types of databases in its portfolio, isn’t about to write off relational databases just yet. In a discussion at the European ...

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 ...