Data Table in Excel is an amazing tool to conduct sensitivity analysis. It enables a user to measure the change in the outcome when an input variable is changed.
In this video, learn how to use a two-variable data table. In this video, I showcase an example on how the Monthly Loan Payment changes when the Number of Months and the Loan Amount changes
Read the full tutorial and download the example file:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
very helpful!!! tysm 🙂
THANK YOU!!!
Excellent teaching and to the point. High five to you.. 🙂