Use Descriptive Statistics. Go to the “Data” tab on the Ribbon. Click on “Data Analysis” in the “Analysis” group. If you don’t see this option, you may need to add the Analysis ...

Investors can use Excel to run technical calculations or produce fundamental accounting ratios. Corporations may use Excel to run a capital budgeting analysis, risk analysis or discount cash flows.