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.

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

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