For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

Airtable is an online platform for creating, using, and sharing small relational databases. It’s not ready for enterprise users yet (that’s coming), but right now, if you want help managing data for ...

Designing an appropriate set of indexes can be one of the more troubling aspects of developing efficient relational database applications. Perhaps, the most important thing you can do to assure ...

Originally, Excel was not designed to be a real database. Its early database functions were limited in quantity and in quality. And because every record in an Excel database is visible on the screen ...

Excel created pivot tables to improve upon its convoluted, weak reporting features (which are still available). The pivot table is actually a collection of tools that Excel uses to help you create ...