Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells. For example, to pass a driving theory test, I need to get 80% of the questions correct.

On of the most common uses of Excel is to calculate values. For example, if you're keeping track of inventory of your office supplies, you add up the total amount of each item by adding the cells ...

Example of Calculating Variance in Excel In the example below, we will calculate the variance of 20 days of daily returns in the highly popular exchange-traded fund (ETF) named SPY, which invests ...

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

2] Calculating Interest Compounded Half-yearly in Excel Here, we have to add one more value to our data, compounding periods per year. As explained above, two half years make a complete year.

We’ll add a new column to the Table, column F, for the daily subtotal. To do so, enter the header text, Daily Subtotal, into cell F2, and the Table will extend automatically.

The article How to Calculate the Average Return for the Share of Stock in Excel originally appeared on Fool.com. the_motley_fool has no position in any stocks mentioned.