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.In older versions of Excel, people ...

How to create an Excel table. 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.

Microsoft Excel comes packed with several predefined table styles for you to choose from. If you want to format a table, your best bet is to choose from one of the many styles.

A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a liner regression table.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.