Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

Using the Gordon growth model to find intrinsic value is fairly simple to calculate in Microsoft Excel. To get started, set up the following in an Excel spreadsheet: Enter "stock price" into cell A2 ...

Although you don't have to format your data as an Excel table, doing so will make life easier if you add more rows or columns, and Excel generally reads data formatted as a table ...

Modeling linear regression in Excel is easier with the Data Analysis ToolPak. Regression output can be interpreted for both the size and strength of a correlation among one or more variables on ...