adspace


How do I create a scenario summary report in excel?

Answer Posted / Abhishek Saxena

To create a scenario summary report, follow these steps: 1. Set up your data with different scenarios in separate sheets. 2. In the summary sheet, use Excel's SUMIF or INDEX-MATCH functions to pull data from each scenario sheet. 3. Use Excel's What-If Analysis tools (Data Tab > Scenario) to create and manage multiple scenarios.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is wrap text in excel?

721


Which is latest version of excel?

722


How much is excel for ipad?

714


What is left formula in excel?

685


Why can't I see the tabs on my excel spreadsheet?

724


Image result for how do I compare two columns in excel

668