How to make Pareto chart in Excel | Productivity

How to calculate percentage in Excel | Productivity

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: DivulgaoCheck out tips on how to calculate percentage in Excel Photo: Divulgao

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 BeggioraFormatting cells for percentage calculation Photo: Reproduo / Helito Beggiora

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 BeggioraCalculating a percentage manually Photo: Reproduo / Helito Beggiora

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 BeggioraCalculating percentage of cells Photo: Reproduo / Helito Beggiora

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 BeggioraSetting the divisor value Photo: Reproduo / Helito Beggiora

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 BeggioraDrag the cell formula to calculate the percentage automatically Photo: Reproduo / Helito Beggiora

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

How to create charts in Microsoft Excel