How Excel makes a relational database Relational databases—databases structured to recognize relations among the information stored in them—are essential for working with large amounts of ...

Tips This article applies to Microsoft Excel 2007, 2010, and Office 365. View the videos listed in the Resources section for more ideas on using Excel's database functions.

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.

Import data from external sources Excel offers a robust set of tools to import data from various external sources, making it a versatile, lightweight database solution.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

This is where MS Excel PowerPivot comes into play. PowerPivot is an advanced feature in Excel that allows you to create sophisticated data models, perform powerful data analysis, and generate ...

Creating custom templates in Excel allows you to save time and maintain consistency in your spreadsheets. Follow these steps to create your own templates: ...