Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

Open a blank Excel spreadsheet. Type a header in one of the columns in the worksheet. This is your first independent variable. Type the appropriate data in the rows below the column.