Building for Sensitivity Analysis

In the previous chapters, you investigated a wizard that could take in and store user input. In this chapter, you’re going to create a dashboard that allows you to perform sensitivity analysis based on the metrics described in the previous chapter. Figure 8-1 provides a preview of what’s to come.


Figure 8-1. Analysis of alternatives decision support system

The tool shown in Figure 8-1 allows you to do many things quickly and efficiently, much of it with only a small amount of VBA code. As you’ll see, ...

Get Advanced Excel Essentials now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.