up vote 1 down vote. There's a couple of ways you can do sensitivity analysis on Excel. You can use data tables or the scenario manager. It depends on the number of variables you want to change in the analysis and what sort of output you'd like.Check out the following posts to learn more about both the methods.http://awaisa.wordpress ....our problem is a more straightfoward sensitivity analysis. Data Tables are a simple way to flex inputs through a model for simultaneous outputs, 1 way (1 changing variable) and 2 way tables (flexing a table of paired row and column inputs) can be added easily. 1  http://www.homeandlearn.co.uk/excel2007/excel2007s7p1.html.