Microsoft Excel 2010: How to Calculate Percentages in Excel 2010

Are you stuck in the middle of your task just because the percentage that you calculated isn’t accurate? Just follow the simple steps mentioned below to complete the task in a jiffy and that too without moving anywhere away from your favorite Microsoft Excel 2010 application. There are different and very handy formulas available in this application and they definitely help you speed up your task. So, make all your calculations precise and fast in this wonder application of yours. If you are using a Windows-based PC, the following is what you need to do…

In example 1, we’ll calculate a ‘Percentage as a Proportion’. To do so:

1. Select the cell where you want to display the result and right click on it.
2. Click ‘Format Cells’, select ‘Percentage’ from the category list and then click ‘OK’.
3. Type ‘=reference to the cell containing the sample size / reference to the cell containing the size of the full set’.
4. Press ‘Enter’ to calculate the proportion percentage.

In example 2, we’ll calculate a ‘Percentage Change. To do so:

1. Select the cell where you want to display the result and right click on it.
2. Click ‘Format Cells’, select ‘Percentage’ from the category list and then click ‘OK’.
3. Type ‘=(reference to the last cell containing the attribute you want to calculate the percentage change of - reference to the first cell containing the attribute) / reference to the first cell containing the attribute’.
4. Press ‘Enter’ to calculate the percentage change.

Footnotes:

Did you see how simple it was? For a quick recap of the above mentioned solution steps, here is a short video that you can check out. To watch it now, click on the window below:

http://www.youtube.com/watch?v=JMjUc22lykE