We will now look at a set of analysis tools called what-if analysis in Excel 2019. This category consists of three tools—namely, Goal Seek, Scenario, and Data Table. In this book, we will only focus on Goal Seek and Scenario. Now, let's look at how to use the Goal Seek tool:
- Open the SSGSchoolA.xlsx workbook and select the BRITTON-FINAL sheet. We will show you a really simple example of how to use Goal Seek. Goal Seek allows you to find out missing information based on the data you already have. For instance, take a situation where a student gets four results back from the exams they have already sat but still has one final exam to sit in order to pass the course. We can work out the average result of the five exams (the ...
