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.

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

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

To learn more about Excel Table objects, read 10 reasons to use Excel’s table object. Send me your question about Office I answer readers’ questions when I can, but there’s no guarantee.

A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of large amounts of information quickly and easily.

Fortunately, you can add a filtering control to the interface. To illustrate, let’s add a filter for the region as follows: First, completely expand the pivot table, if necessary.

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

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.