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.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

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 an interactive dashboard in Microsoft Excel Now that you have a basic idea about interactive dashboards in Microsoft Excel, let’s check them out in action.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.