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.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

Microsoft Excel worksheets are convenient places to store limited amounts of data. Excel is a spreadsheet application, but an Excel file can also serve as a database for your website if you can ...

This article will teach you how to create drop-down lists in Microsoft Excel using a feature called Data Validation. When applied, the Data Validation function serves to restrict data that can be ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.