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 ...

Excel analyzes quantitative variables by arranging them into pivot tables. These tables sort data into groups, totaling the figures that fall under each qualitative division.