# @udemy on YouTube

- **Type:** Video
- **Original URL:** https://youtube.com/watch?v=214J99zwS_o
- **Gondola URL:** https://gondola.cc/posts/72078186-udemy-youtube
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/29d18f4a2c.jpg
- **Posted:** 2019-03-18T23:08:56.000+00:00
- **Account Owner:** Udemy (@udemy) — https://gondola.cc/udemy

## Caption

📈 Ready to take your Excel skills up a notch? Master the power of Data Tables to automate and simplify scenario analysis!

In this video, Excel expert and bestselling Udemy instructor Chris Dutton walks you through one-variable and two-variable Data Tables, showing how to calculate and compare results with ease. Learn how to visualize outputs for changing inputs like interest rates and down payment percentages—tools that are essential for financial analysts, project managers, and data-driven problem solvers.

✨ What you’ll learn:

Set up and use Excel’s one-variable and two-variable Data Tables.
Perform rapid sensitivity analysis using What-If Analysis tools.
Replace manual calculations with efficient automation.
Apply these skills to real-world scenarios like mortgage planning 🏡.
🎯 Turbocharge your data analysis workflow!

Timestamps:
00:00 – What is this Excel PRO TIP?
00:28 – Data Tables vs. standard Excel tables
01:45 – One-variable analysis demo (interest rate)
03:00 – Fast fill trick with right-click drag
06:00 – Setting up the data table
06:47 – Two-variable table (interest + down payment)
08:01 – When and why to use data tables

Course featured in this video:
https://www.udemy.com/course/microsoft-excel-pro-tips-for-power-users

Instructor profile – Chris Dutton, Maven Analytics:
https://www.udemy.com/user/maven-analytics/

More Excel courses on Udemy:
https://www.udemy.com/topic/excel/

If this video helps you, don’t forget to give it a 👍 and subscribe for more advanced Excel tutorials from industry pros!

#ExcelDataTables #WhatIfAnalysis #AdvancedExcelTips #ExcelForFinance #DataDrivenDecisions

## Stats

- **Views:** 8,121
- **Likes:** 30
- **Shares:** 0
- **Comments:** 0

## Tags

whatifanalysis, advancedexceltips, excelforfinance, exceldatatables, datadrivendecisions

---
Copyright (c) Gondola