 Hello everyone and welcome back to another video. In this video we're going to be looking at percentage calculations So this is still a question that I regularly asked and both through the YouTube our social media channels and also in person When dealing with Excel spreadsheets and just percentage calculations so I thought it'd be really good just to bring together four different examples of calculations that we need to use for Reasons we need to find out the percentage to numbers numbers to put it up bluntly So I pulled those together and was going to go through them in this video here today Just to remind you that if you want to download this exact workbook that I'm working with now or any of the previous Workbooks reviews if you just go to this link here the essential excel UK dot com Ford slash blogs Ford slash tutorials You'll see the full list of tutorials that we've been through and then from each of the tutorials You'll find a bit more description then you find a new to and also you will have their link available to download the exact Workbook we're using particularly useful if you're following along at home Or you just want to have the template to actually try for yourself or even just to see what I've done in that template Okay, so we're up there delay. Let's just jump straight in so the first one. We've got is percentage of total So this is where we've got a number so you can see what the total of a hundred and we want to know what? 65% is of 100 so do excuse if some of these are very simple because from sake Well, we're doing it in Excel So chances are we are needed to do a calculation to work out the value But the reason I asked some apologies is because 65% of a hundred probably most of you will find that quite easy Calculation, but it just helps with proving that the calculation is working quickly as we go through this So the easiest way to work this formula is we simply need to go equal sign So all these are going to use a formula basically in short Equals we'll take our starting number and we're then going to times that by so using the Hashtag sign there so shift and the number eight or if you've got the extended keyboard You'll have that symbol on the right side there and we're going to times it by our percentage that we have here Hit enter and you can see the value arrived is 65 All we then need to do is to copy this down and you can see we've got result for all of those other options as well Some of them are decimal numbers So if you wanted to you could obviously remove decimal places, but for the purpose this will keep those places there It's worth pointing out this time for any of those not aware in Excel Even though we've got 65% shown here This is due to the formatting what Excel actually recognizes the number behind the percentage which is if you go into general We can see that percentages are all actually referenced as those decimal places So again not to give simplistic maths guidance, but as we know a percentage is a representative of a number between zero and One so obviously one being a hundred percent and then all these decimal places representing that percentage place So all our calculations doing is simply times in a hundred by 0.65 Which gives us the answer of 65 and it's obviously that naught point six five that refers to 65% so we'll just put that percent there the formatting back to show percentage But just for any that weren't aware that is how it works And ultimately if you have found yourself in this position where you've got these decimal places You wanted to convert them to show as a percentage all you need to do is highlight this do the reverse what we've just done You can either push the percentage button here or from your drop down here You can find percentage and there you go and I'm just going to remove those decimal places just so it looks a bit Tidy for those percentages So that's the first one. So how do you find a percentage of total all we need to do is we take the total number and We times it by the percentage amount and that will give us obviously the Number value of that percentage So next one so we've got increased by percentage well actually that shouldn't be increased that should say increase So apologies for that. So how can we increase our before number by this percent? So this is where our calculation now gets a bit more Technical but we're just getting a bit more detail to our calculation So the first one you need to do is obviously take our starting number So for us that is going to be equals our before number so F10 here And then what we're going to do is we're now going to be using the plus symbol and Actually before we jump into this Let's just quickly look at this from a basic standpoint and we'll just convert these percentages back to our number Values which can be general there So as we know from our previous example, we know that these decimal numbers represent a percentage Or basically represent a percentage So in order for us to increase by this percentage What we need to do is we need to initially Turn these into for this first one. We don't want this to be five percent. We want it to be 1.05 percent So that actually no, sorry. I said that wrong. We want it to be 1.05 as a decimal number What would represent a hundred and five percent? So therefore our calculation becomes 100 times 100 and five percent would obviously give you that five percent uplift So if we to just do this at the moment, so we went equals the hundred times 0.5 as you know, it would just give us five percent because it's just time it was just saying, okay Well, what's five percent of a hundred and we know that over here That's obviously the same calculation used there obviously just different numbers So what we actually want to do is rather than times by naught point zero five. We want to times by one point zero five What gives us that five percent uplift? So we know that our number before was a hundred five percent of a hundred is five Therefore we want to add that five to the one hundred to give us the after one hundred and five And I hope that makes sense. I made a mistake in the middle there But hopefully that did make sense to you and you're following along still So how do we turn this five percent into? 105% without messing with the numbers we've got there Well, simply all we need to do is just make a little addition to the end of this formula. So we're going to simply do Times by open brackets And we're going to do the number one what signifies a hundred percent Plus the percentage that we have here in column G. What obviously is our naught point five And then we're going to close our brackets and hit enter and you can see that that now has done The same result as what we did manually and if I was just to put in this column to the side here That's second part of the formula. All we doing is equal one plus naught point naught five So you can see that this is the number we're actually times another four number by so we're now going to go 100 times by one point zero five gives us a hundred and five what reflects an increase of five percent And now all we need to do is copy that formula down We can change our percentage here back to our percentage formatting. That's nice and tidy and there we go We can now see that 100 increased by five percent is a hundred and five and so on and so forth So 50 increased by 25 percent would give us 62.5 percent So it all comes together Just as desired So next the inverse of that is to look at how can we decrease a number by a given percent So it works very much in the same as this first example here in by increase But rather than a hundred plus that number, we're going to be doing one Minus that number that we want to require So for us what we're going to be here so we can just put this in manually now So what we actually want to do is we want to say, okay, what is One i.e 100 percent minus our desired decreased percentage What is 0.05? I kept the numbers here the same and we can see it's 95 percent So what we actually want to do what we're now going to be doing is Having done this calculation is we're going to be timesing our starting number by on by 95 percent to work out what that decrease value is And again, hopefully you're still further along and that does make sense So what i'll just do is put that calculation aside here. So we're going to be doing equals one minus The percentage we want to decrease by So we can see it's 95 percent, but we'll just put that to a number And let's pull that down And let's put them to the left there So we can see that these are actually the percentages that we want to be timesing our starting number by So 50 reduced by 25 percent is the same as 50 times seven or 75 percent of 50 200 decreased by 50 percent is obviously the same as 200 times by 0.5 i.e 50 percent So I hope that makes sense. So what we need to now do is just add this to our calculation So it's going to be equals our before number times by open brackets one minus our desired percentage reduction close brackets hit enter And you can see it's got a percentage in at the moment, but we'll just format that back to general And we can see that 100 reduced by 5 percent or 100 minus 5 percent equals 95 And then what we can simply do is just drag that all the way down And you can see all those Results based on the different percentages we want to reduce by So that is how we then do Click contents So that's now how we've covered how we do percentage of total So how do you find what number or what is 65 percent of 100? We've looked at how to increase a number by a percentage. So 100 Add 5 percent is 105 and we've looked at decreasing percentage. So 100 Reduced by 5 percent gives us 95 So the last one we're going to be looking at is Calculating percentage change. So it's kind of looking at this first one always first Well, we're looking at many of them to be honest, but it's kind of pulling it all together So for this one, we want to say We've got a before number of 100 We've got an after number of 110 So what is the percentage change that's happened to go from 100 to 110? So for this we're going to now do another little calculation and it's in two parts So again, what we'll do on the side here is we'll do the first part Say that we can see what that looks like and actually we're doing the change column So what we're going to first be doing is simply equals our Results or our light latest number are after number the number that's happened after the change minus The before number And we know that that's going to be 10 So we can copy that actually what I'm doing. I want to change my mind once again So let's just put it over to the side here And all will hopefully make sense in a second So all this calculation is doing is taking our after number and Minicing off the before number so we can see what the number difference is So once we've done that we can copy that down and we can see that we've got some additions and some reductions So we can see we've got Plus 10 plus 10 plus five We've had a reduction of 100 reduction 25 in addition of 20 and a reduction of five So these are all the numbers that have changed what have happened to our starting number The next thing we need to do is the last thing we need to do is now say, okay We know what has changed by so what is this number as a percentage of our before number? So kind of going back to this first example we had here So what we need to do is oh, and I'm so sorry, but I just now realized a mistake I made here This is not shouldn't be percentage change. This should be number So hopefully that's not that confused people throughout this whole video So this is obviously just a number and this is a percentage our originally was going to do this in a different order But yeah, so you can see ignore whatever that header was it should be number um So we are sorry sorry going back to our percentage change at the end here. We know what the number has changed by So all we now need to do is we have to understand what this is a percentage of our before number So we can go equals Amount changed divided by our hundred Gives us a percentage and let's copy that down change it to percent And we can now see that our what our percentage change is so our 100 starting number changed to 110 Is a is a percentage increase of 10 percent? And just skimming down and we can see that our before number of 200 reduced to 100 is a reduction of 50 percent So it's pretty much there all we now need to do is combine these two pieces of information together So the first thing we want to do is rather than reference our q10 here So our number we've generated we're just remove that and replace it with the calculation within brackets So we're going to do open brackets after number minus before number Close brackets So this is calculated for us this number 10 And then it's going to be divided by our before number And you can see what the same result of 10 percent there. Let's copy that down Clear contents of that final column because we don't need it and there you go We can now see the final result there for us So I hope that's been nice and clear for you in understanding how to do these various Percentage calculations as I mentioned at the start of the video You've got the link here and you'll also find that same link below the video in the video description So all you need to do is go to that link you'll find this one this video again And you're also better find another link will allow you to directly download this exact tutorial workbook So you can go through it You can actually see all the calculations in there for yourself And you can also play around with these different before and before and after numbers or percentages What will also help you understand how the formula is working If this is your first time watching one of our videos or stumbling across the channel Please do hit that subscribe button and also hit that bell notification as well So you're notified of all of our future videos. We're very close on getting to 4000 subscribers So again, if you're a regular viewer, please do hit that subscribe button As it would be greatly appreciated to help us get to that or past that 4000 number If you did enjoy the video, please do give it a like It's not only greatly appreciated by myself as it shows me the videos and the content you'd like to see more of It also does help that all important youtube algorithm to help more people find this video So thank you very much for watching and I'll see you in the next video Before you go, don't forget to check out the other videos on our channel You'll see everything from other functions and formulas through to tips and tricks We've also created some playlists so you can see these categorized together So make sure you check those out and get all those useful information And obviously as always, don't forget to subscribe and hit that bell notification button