From the course: Excel: Analytics Tips

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Automated data tables

Automated data tables - Microsoft Excel Tutorial

From the course: Excel: Analytics Tips

Start my 1-month free trial Buy for my team

Automated data tables

“

- [Instructor] All right, for this pro tip, we're going to talk about a four star, relatively advanced analytics tip and we're going to discuss how to evaluate variable inputs, using Excel's data tables. Now the data tables that we're talking about here are different from your standard cell ranges, formatted as tables. In fact, I wish Excel gave them a different name because they actually operate quite differently. What we're talking about are the data tables that you'll find in your Data tab from the What-If Analysis tools. And what these data tables do is they allow you to calculate an array of results with the click of a button, based on an entire range, or variety, of potential input values. So to show you what I mean by that, we're going to look at our Property Cost calculator tool, which we've seen before throughout the course. And the idea here is to understand exactly what our mortgage cost, our monthly mortgage cost, would look like, based on different interest rates, ranging…

Contents