In Microsoft Excel, you can create relationships between two tables based on the matching data within the table, even when the tables are from different sources.

Show users how to create a quick table of contents in Excel using the power of hyperlinks.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

How to Create a Table That Makes Choices in Excel 2007. Excel enables you to include data validation for a cell, limiting the type and content of any inputted data. In addition, you can limit data ...

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.

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

Creating Running Totals in Regular Ranges To create a running total in an Excel range that isn't formatted as an Excel table, you need to use a combination of absolute and relative references.

Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.