The best way to do sensitivity analysis in excel is to use Data Tables. Data tables provide a shortcut for calculating multiple versions in one operation and a way to view and compare the results of all of the different variations together on your worksheet.