Excel can calculate percentages quickly and practically. The Microsoft program has specific formatting for data of this type, preventing you from having to multiply the result by 100 and manually insert the percentage symbol (%). It is also possible, for example, to set the divisor value in a formula to calculate the percentage of entire worksheets by dragging a single cell.
10 advanced Excel tips and tricks
In the following tutorial, discover some ways to calculate percentage in Excel. The procedure was performed in the latest version of Office 2016, but the tips are also valid for users of previous editions of the Microsoft program.
Check out tips on how to calculate percentage in Excel Photo: Divulgao
Want to buy cell phones, TV and other discounted products? Meet Compare dnetc
Step 1. Select the cells in which the percentages will be calculated and set the option "Percentage". This helps in the formatting of the cell, avoiding that you need to multiply the result by 100 and manually insert the sign "%";
Formatting cells for percentage calculation Photo: Reproduo / Helito Beggiora
Step 2. Now, one of the ways to calculate the percentage by dividing the desired number by the total. To do this, insert the equal sign ("=") at the beginning of the line and enter the data. Use the "/" bar to indicate the division. After pressing Enter, the result will be automatically calculated and displayed as a percentage;
Calculating a percentage manually Photo: Reproduo / Helito Beggiora
Step 3. Another way to calculate a percentage by selecting the spreadsheet cells. In this case, insert the equal sign ("=") at the beginning of the line and click on the desired data;
Calculating percentage of cells Photo: Reproduo / Helito Beggiora
Step 4. If you want to calculate the percentage of an entire column, you can set the total (divisor). Thus, when dragging the cell, only the dividend will vary. To do this, just insert the monetary symbol ("$") between the letter and the cell number you want to fix;
Setting the divisor value Photo: Reproduo / Helito Beggiora
Step 5. Once this is done, select the cell with the percentage formula. Then, click on the point in the lower right corner and drag down or up. The percentage of all rows in the table will be calculated automatically.
Drag the cell formula to calculate the percentage automatically Photo: Reproduo / Helito Beggiora
What Excel VGA? Find out in the dnetc forum.
How to create charts in Microsoft Excel