Excel: Using Data Tables

Analyzing data in Excel is one of its great features and there are a number of tools for doing this, aside from sometimes just changing a value and seeing what happens. If you have done this then there is an easier way. This works really well if you have one or two values you need to change.

Lets say you have a formula or function for calculating repayments on a loan and you want to see what would happen if the interest rate changed or the term that you were paying it over changed, then a one input data table could be used to display your options. You could use a two input data table if you want to see what would happen changing both.

Here are two tutorials for each of these different types of data tables.

One Input Data Table

Two Input Data Table

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Uncategorized. Bookmark the permalink.

1 Response to Excel: Using Data Tables

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s