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.

Essential tips for data formatting Before you create a database in your Excel workbook, keep several tips in mind which will help you get the desired results.

Learn how to create an automated data entry form in Excel with macros, interactive features, and secure design for efficient workflows.

With Adobe Dreamweaver you can build Web forms visually without needing to know complicated code. When you build a form in Dreamweaver, you can link it to a database with stored information, which ...

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

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