How to Work Out Percentage Increase in Microsoft Excel
A post from our Video Tutorials blog
Written by Jordan James
On occasion, data may need to be formatted as a percentage and there are a few rules to consider with this.
[ Video tutorial produced by Activia Training and purchased by ZandaX ]
When entering figures such as 50 or 75 then clicking the Percent symbol on the Home tab will add the percentage sign but it will also multiply your data by 100. When using this method it is advised that you enter the data in decimal format e.g. 0.50 or 0.70 and then applying the percentage format. You can also manually type "50%" which will stop Excel from multiplying the figure by 100.
We can set up Excel to calculate percentage values automatically e.g. the value of 20% of the weekly total of 23,500. You may need to work out VAT or TAX values or maybe commission rates against sales figures. You might need to add a percentage on top of costs to cover your profit or work out margins.
All of these come from knowing how to insert percentages in the cells.
Our Excel course cover all aspects of Excel calculations including percentages as mentioned above.
Excel is a very flexible application and it is easy to change future values but it may be useful to learn how to hide and protect important cells that contain percentages or formulas to prevent users or clients from viewing or changing these values.
Want Better Excel Skills?
We have online courses with full 12-months' access. RRP from $49 limited time offer just $12.00
Get a solid foundation in Project software to create solid, resilient project plans.
You don't need prior experience with Project: just be able to use a PC with Microsoft Windows.
Microsoft Project Advanced
The Advanced course takes you to a level that will put you in complete control of your projects.
You should, of course, be fully conversant with the skills and concepts taught in the Introduction course.
Become a Visio master with our two intensive but very easy-to-follow CPD certified Microsoft Visio courses.