What If Analysis in Excel: A Comprehensive Guide. What-if analysis in Excel is a powerful tool that allows you to explore different scenarios and outcomes by changing input values in your formulas.