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.

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.

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 ...

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.

It's easy to get overwhelmed with data in Excel and pile up inconsistencies and errors. These steps will help you fix those problems.