 Welcome back to another video. So in this video, we're going to be taking a look at percentages. I have looked at this in previous videos, but it continues to be one of the most or frequently asked questions that I receive. So how to increase the number by a percent and basically anything else revolving around percentages. So in the workbook, I've got a couple of sheets and we're just going to go over a variety of different percentage calculations that you may need or wish to calculate. And what I'll do is I'll make this workbook available via a link in the description so you can download it after we've watched a video or if you want to jump ahead and get it now, you borrow means you can. So we'll just step through each one of these really simply and just go over how the calculation works and just give you the information that you need. So the first one we're going to look at is comparing against a baseline. So I'm looking at this first table here. So you can see we've got monthly sales figures and what we've got the first of December 2019 all the way through to November of this year. And all we want to simply do is for each of these months, so in 2020, we just want to compare this current sales figure against the figure in December. So we can see that the company, for example, obviously sales have been reducing. And we just want to compare each of these to this baseline number we're calling in December, just so we can see what it looks like. So in order to do it, it's very simple, we're going to start on the top part here and all we're going to do is go equals and take the current sales number divided by again, in this first example, that same sales number. But this time we're going to lock C nine, so by pushing f four ones. So it's always going to refer back to C nine. If I hit enter, you'll see you've got the value of one. And then as I pull this down, I'm just going to get to the bottom here and go fill without formatting. And the last thing we need to do is convert these to a percentage. You can see that we now have that picture. So what it's telling us is obviously this first one here in blue is kind of irrelevant. It's just going to be our 100% number. So we know that 350,000 is 100% of 350,000. But as we move on, we can see how sales have changed as it's gone on. So if we were to jump ahead to May, for example, we can see that the sales in the month of May are actually 28% of what they were in December last year. So obviously, it's not good, but it would actually give you the numbers to actually visualize this in a graph. So if I wanted to put this into a graph, all I simply need to do is highlight all these, go on to insert, pick graph, probably a line graph for this. And you can now see we have this picture here. And this is quite a commonly used graph or metric, shall I say, I'll use this in previous packs. And it just demonstrates obviously of previous supply or demand being 100%. How does the sort of picture look thereafter? And you can see there's a big drop off here initially, and it started to build up again. But I've digressed and done in the charts, but this is how you can also do a percentage when you're trying to compare it to an initial baseline. So the next one we're going to look at is percentage change. So I've got two options here for percentage change, and you'll, you'll see what I'm doing as we step through. The first one is the most simplest of the two. But to be fair, they're both quite simple. If we want to compare 2020 sales against 2019, so obviously 332 against 360, all we need to do is go equals the 2020 number divided by the 2019 number, hit enter, we'll pull this number down, and let's just convert that to a percentage as well. And what we can see is that when we compare these two numbers for January, we can see that 332,000. So the sales for 2020 are 92% of what they were in 2019. So it's a very similar calculation or is the same calculation as we looked at in this first baseline one. But obviously it's going to show us obviously how things have changed. It's going to just use to say 2020 2019 as the baseline to compare 2022. So yet we can see sales in 2020 were 92% of what they were in 2019. And as we go through, we can see that jumped down to some bigger ones actually sales are now 121% of what they were in 2019 for September. So that gives you another way of comparing, for instance, or in this example, two years worth of data. Carrying that on and often what you'll find is you might not want, even though you're wanting to see what the percentage change was as we have here in February, we don't want to show it as 103%. We actually just want to show what the change was. So it was actually 3%. So we'll move on to option two to do just that. This calculation is slightly different, but it's the same principle. We're going to do equals and open brackets. And the first part we're going to do is we're going to take the 2020 number and deduct from it the 2019 number. And if I was just to do that calculation as it stands, you can see we've got minus 27,500. So it's a reduction. So to turn that into a percentage, we want to take the actual change amount. So this 27,500 and divide that by the 2019 number. So we're basically saying what is the reduction? It's that 27,000. Okay, what is 27,000 as a percentage against 360,000? Oh, and I haven't actually even put it in there. So yeah, 27,000 divided by 360. So we can see what, you know, what is a percentage of 360,000. And it's not brought anything up first. But if you copy that down, convert these to a percentage, you can there see we've actually now got just the actual change percent. And the reason it's beneficial is again, looking at this first row for January, we can see in the first table was showing actually it was 92% of what it was the previous year. But actually the benefit of having this change percent in option two is actually clearly shows what's happened. It's gone minus 8%. And anyone who's used to working percentages or Excel to you that probably doesn't carry much weight. You probably think yeah, it's just tell me exactly the same thing. But if you're working with an audience or maybe not too sure what they're looking at, or they just need a really clear and concise number without having to try and work anything out, obviously, that is the favorable way of using option two, because it clearly shows them regardless what the numbers were, it's gone down by 8% minus 8%. And then so on and so forth for all those other numbers as well. So the next one we're going to look at here is a percentage change of bite baseline. So what we've done in that third one, we basically copied this table from the first one over here. So we've gone through calculations and we now know that each one of these is a percentage of that previous baseline. But just like an option two here, we want to actually know what the actual change was. So rather than saying, okay, we know it's 95% of what it was, we just want to show obviously it's a reduction of x%. In order to do that, again, really simple one to do all we need to do here is go equals, and we're going to enter the number one, because one refers to 100%. And as I'll go over this in the next sheet, but as we know, percentages in numbers and especially in Excel, they are treated as a decimal number. So if you wanted 50%, obviously it's 0.5, with number one referencing 100%. So all we need to do is go 100% minus the percentage we have here, hit enter, copy this down. Obviously I'm going to just do about formatting. That one's not done a percentage. And you can now see we've kind of got the inverse really of what it was. So we now know that the percentage of baseline here, so our sales here were 95% of what they were in December, and that reflects a reduction of 5%. So we know there's been a change of 5%. And if you wanted to get clever, obviously just like the changes, then obviously you could add the minus sign in here as well if you wish. But the purpose here was literally just to show you how you can obviously get the like say the inverse here. So rather than the 95, okay, what was the actual change, which is 5%. So moving on, and I hope I'm not going for this too quickly, but I'm trying to keep it nice and concise without spreading the video out more than it needs to be. And this is the table I was referring to in that last example. So if you weren't aware, obviously percentage as you see it formatted in Excel will display like this. So 100%, 75%, 50% and 25%. And because we reflect them as a decimal number, this is how you can see it looks here. So the real simple calculation is, as if you want to work out what 25% of 100 is, all you need to do is go 100 times 0.25. And then you can see it's given us 25. So that's the real quick way of obviously doing your manual maths with percentages in Excel, well, even just on the calculator as well. But what we're going to do is going to cover off a couple more calculations in this sheet here. So the first thing we want to do is increase by percentage. So we've got similar sales numbers that we looked on the last sheet. So we've got the sales total. And this time we've been told a percentage that we want to increase this sales amount by. In order to do that, all we need to do is go equals. And let's sort of step back a bit here. So if we were to remove percentages from this for one second, so let's change that back to the general, we can see obviously the decimal number that obviously refers to the percentage that we're trying to do, just obviously unformatted here. So if we wanted to obviously increase 332,000 by 5%, what we actually need to do is we want to times that by 105%. So in order to do that, all we simply need to do now is convert as such our increased number to reflect 105% rather than just 5%. So in order to do that, all we're going to do is go equals and we'll do one which refers to 100 plus the 0.05. And if we to put this back to a decimal as well, you can see that we now have a value of 1.05. And this is the actual number we want to times our sales by. So just to tidy our calculation up, all we need to do here is put this into brackets. The part was actually calculating our actual number we want to increase or times by. And all we need to do is go select sales times by that calculation, which gives us 105%, hit enter. And you can see that's now been updated for us. And if I was to put an easier number in here, so let's say 100,000, we can see it's done obviously 105,000 because we know 5% of 100,000 is 5,000. So obviously at 5,000 added onto 100,000 gives us our correct result of 105,000. And if I copy that down for all these other calculations, let's get rid of decimal places, change that back to a percentage, you can see how our result has changed there. Next one from that would be how to decrease by a certain percentage. So it's going to work exactly the same apart from rather than add our increase to one, we're simply going to deduct it from one to give us the opposite. So what we're going to do here is go equals 1 minus 5%, which gives us 95%, or if we're going to here makes it easier. So obviously 1 minus that gives us 95 or 0.95 referring to 95%. And that is exactly the same. So all we need to now do is go sales times point or sales times 95%, obviously we reflect a 5% decrease. So all we're going to do here is at the front, we're going to go sales times by that. And that gives us our result, we'll copy it down, get rid of the decimal places. And yet just to put an easier number in here, so 100,000, you can see obviously a decrease 5% of 100,000 we know again is 5,000. Therefore to decrease by 5,000 would give us a result of 95,000. The next one we're going to look at here and we've only got two more. So please just bear with us if you made it this far. So find 100%. So we've been given these numbers, so we've got five numbers here. And we know that for this first example, our number of 50 reflects 5% of its total value. So we want to find out what 100% of 50 is when we know that 50 is equal to 5% of that number. So to easily do this, all we need to do is go equals, take our number divided by our 5%, which is not point 05. And that will give us our result. And for us, it's going to be a thousand and it's not 1000 pounds would change it to number. So if we go to general on this one, there we go. So you can see that yet we know 50 is 5% of 1000. So to obtain this result, all we need to do is take our initial number, divide it by the percentage that it reflects, or it is of that other number. And that's how we can then get our 1000 result. And as you copy that down, you'll see how all the rest of these ones work. And obviously some of these are easier than others. So obviously 200 is going to be 10% of 2000. So that's an easier one to work out. And the very last one, and I sort of did touch on it down here, is if you wanted to do any calculations manually, the easiest way is to just type them in. So let's say we wanted to work out what 5% of 100 was, all we need to do is go equals, take our value of 100 times by 0.05. And you get the value of five, as you can see there, just put this back to general. Alternatively, if you didn't have the number of 100, and you just wanted to do the type the maths in, so you're just trying to work something out, if you just typed in 100 times 0.05, again, that would give you your 5%. If however you wanted to do decrease by 5%, again, all you need to do is go equals the same calculation, 200, 200, being our number. And then we're going to times that by minus 0.05. So I've literally just done a minus sign there rather than the plus over here. And you can see that we've got that same result as well. So that gives us minus 10. And everything in between. So if you want to do obviously increase 100 by 100 by 5%, all you need to do times 1.05. And that will do the result for you. So I hope all that made sense. As I said, I'm going to make this document available to you via a link in the description. So if you click that link, you're about to download the document and get all the calculations you need. And then hopefully this, what the video will serve as a purpose of showing you just different calculations of percentage that you can either use, or obviously the answers if you did have any questions. And also if you've got the word book, you can obviously refer to that as and when you need, if you want to do any of these calculations. So I hope you enjoyed that video. If you did, please do give the video a like. I'd be greatly appreciated by myself. And if you're new to the channel or you have watched one of our videos before, please don't forget to subscribe to the channel and hit that bell notification button. So you're notified of all of our future videos. So lastly, thank you very much for watching and we'll see you in the next video.