How to Calculate Pecentage Using Excel

1. Browse to the Excel file containing the data for which you wish to calculate a percentage, and then double-click that file to open it in Excel 2010.
2. Locate the cells containing the data that represents your 100 percent value and the cell to which you are comparing it.
3. Note the cell names for those two particular cells. For example, if one piece of data is in the upper-leftmost cell, then the cell name would be 'A1.'
4. Click inside the cell in which you want to display the percentage.
5. Type '=AA/BB,' where 'BB' is the name of the cell containing your 100 percent value, and 'AA' is the name of the cell containing the amount to which you are comparing it.
6. Press 'Enter' to perform the calculation.
7. Right-click the cell into which you just typed your formula, and then click 'Format Cells.'
8. Click the 'Number' tab at the top of the window.
9. Click 'Percentage' in the column at the left side of the window, and then click 'OK.'