Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

I’m going to show you just how easy it is to make use of MySQL Workbench. To do so, I’ll walk you through the process of creating a database, adding a table to that database, and then adding ...

For example, you could select to filter by Account number in the budget and deselect a particular bank account number, which would prevent those entries from being counted in the pivot table.

When tables are created for each topic in a database, you must place common fields into the related table and form a relationship with them for information to be brought together again.