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.

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.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

In older versions of Excel, people have used functions such as VLOOKUP, INDEX, and MATCH to create relationships between tables, but in newer versions of Excel, there is a Relationship command ...

This guide will walk you through the process of creating table relationships in Excel 365, focusing on essential steps such as using Diagram View, organizing tables strategically, and verifying ...

How to Make a Regression Table in Excel. 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 ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

It helps to apply a format to the table columns to create an appearance that's neat, consistent and easy to read. For example, you can format a column of prices with a dollar sign and two decimals ...