From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using data tables

Using data tables

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using data tables

“

- [Instructor] On this worksheet called Data Table, imagine we're trying to set up some formulas here to show what the monthly payment's going to be if you borrow different amounts. We see these in column B moving downward. Notice how they're 25,000 apart, and across the top we see various interest rates. Perhaps these are for a house. We also see the number 360 up here, suggesting 360 month paybacks. What's going to be the monthly payment? And ultimately what we're headed for here, is to create a giant table here showing what the monthly payment's going to be here. And we can easily consider changing these amounts here, maybe if we're borrowing a car, maybe these'll be 20,000 to 30,000, something like that. And we can certainly change the number up here. Now, the feature we're about to use is called Data Table. Imagine we've got a giant grid set up here. We're headed for some answers. What we do first is put a master formula in the upper-left corner. Now, I don't really have to make…

Contents