Data Sensitivity Analysis in Excel - What If Data Tables

VBA/Macros Course (40% Discount): https://www.teachexcel.com/vba-course...


Excel File: https://www.teachexcel.com/excel-tuto...
Excel Forum: https://www.teachexcel.com/talk/micro...

Multiple ways to conduct a Sensitivity Analysis on your data in Excel - this is a great feature that allows you to test the outcome of changing one or multiple inputs.

Here you will learn how to do a horizontal, vertical, double, and multiple Sensitivity Analysis using the What If Data Table feature. The double version is a two-variable analysis and the multiple version allows testing the output from multiple formulas at the same time.

This is a handy tool to have in your pocket when you are working in Excel and, though it seems confusing at first, it really only requires getting the table structure input correctly.

Once you understand how to use this feature, you will be able to quickly and easily see by how much changing an input will change calculation output in the worksheet in Excel.

I hope you enjoy this Excel Data Analysis tutorial :)

TeachExcel.com