Are you a Microsoft Excel user? We teach you how to how to get the percentage in Excel to make it easier for you. At this point, Microsoft Excel has become a very important software for both companies and individuals who need to organize, calculate and analyze large or small amounts of data. In fact, it is normal that you have ended up in this article, because one of the most common operations in Microsoft Excel is none other than calculating percentages.
But also for different end uses, whether to find out a final discount for a purchase, to analyze the evolution of a business or to make calculations at school, college or wherever you need it. Microsoft Excel will not only help you with the calculation, you will also be able to present it in a very, very visual way.
It is true that although Microsoft Excel is more than practical, we may find it difficult to use as it can become very complex. Within the software there is an abysmal amount of tools to help you, and all at once they overwhelm anyone who is not familiar with it. That is why in Tecnobits We are here to help you with Excel and how to get the percentage in Excel. Don't worry about anything, because You will learn the different methods and fundamentals to make quick and simple percentage calculations, but we may also drop you some complex functions, in case you already have a more advanced level in Excel. In any case, let's get on with the article on Excel!
Methods to know how to get the percentage in Excel
First of all, just in case, I'd like to tell you that a percentage is nothing more than a division, or in other words, a fraction of 100. It's another way of expressing proportions and also an excellent way of comparing data. This way, you'll be able to adjust and analyze values automatically. For example, If you are in marketing or sales, you can present a sales analysis, budgets, or different ratings and notes.. It will save you time. Having said that, let's move on to the first method to learn how to get the percentage in Excel:
Calculate the percentage of a value
- Enter values: Put the total value in any sow and the partial value in another. That is, if you have a total value in A1 and put a partial value in B1.
- Apply the percentage formula which is none other than =b1/A1 in a new cell and now press the Enter key.
- Once you have this, convert it to percentage by selecting the cell and changing the format to percentage from the home menu. It will do this automatically.
By the way, if you are interested, in Tecnobits We have another article on How to Send Emails Directly from Excel.
Calculate the percentage increase or decrease
- Enter the start and end values by placing the start value (again) in cell A1 and the end value in cell B1.
- Now apply the percentage change formula, to do this use =(B1-A1)/A1 in a cell
- Convert it back to percentage using the same method as above. Click on the specific cell and click on percentage under Home. Excel will do it automatically. And you will have another way to get the percentage in Excel.
We promised you some advanced method, and that's how it's going to be. Now we move on to how to get the percentage in Excel but with functions. This may not be for everyone, but if you want to start using Microsoft Excel, you should learn how to use functions.
Calculate percentages using the product function for multiple calculations
This function is good for how to get the percentage in Excel but above all to calculate percentages in multiple cells. The product function is very useful. For example, to calculate the total percentage in a complete column, it is as follows:
- Select the column or cells in question for partial and total values
- Now you will have to write the formula =PRODUCT(B1:B10)/PRODUCT(A1:A10) you can replace the cells according to your data.
- Now you will have to format the cell as a percentage as we had done in the previous formulas.
Additional tips on how to calculate percentages in Excel
We are going to give you some final advice so that, in addition to knowing and learning how to calculate the percentage in Excel, you can also start using Microsoft Excel better:
- Use shortcuts or keyboard shortcuts, for example Ctrl+Shift+% applies the percentage format that we told you you had to do at each end point of the methods.
- Pay attention to the decimalsIn advanced Excel you can adjust the number of decimals
- Avoid mistakes like splitting values, make sure that the divisor is not zero and you will avoid another typical error in Excel
We hope that this article has been easy for you to understand and apply, and above all that you now know how to calculate the percentage in Excel. Microsoft Excel It is a basic tool in many jobs, so it doesn't hurt to spend a few hours on the program, since you will be investing in yourself.
Passionate about technology since he was little. I love being up to date in the sector and, above all, communicating it. That is why I have been dedicated to communication on technology and video game websites for many years. You can find me writing about Android, Windows, MacOS, iOS, Nintendo or any other related topic that comes to mind.