Create a Bill in MS Word for Operations Effortlessly

Bill in ms word for Operations

hi and in today's microsoft word tutorial i'm going to quickly show you how to use formulas in word now obviously when we've used excel before we can do lots of different calculations which are really useful but sometimes we just want to do simple calculations let's say for example if you were adding up an invoice or a table or just wanting to get some details from some accountancy you've been doing so i'm going to show you how to add up these columns and rows and also some other sums you can do as well so as you can see i've got a total here a total here and a total down here and that's just to show you how you can have a total at the beginning of your row at the end of your row and at the bottom of your columns now let's start at the end here if i click in the cell here go up to layout and go along to formula now automatically this dialog box will appear and word has understood that you probably want to add up everything to the left of this cell so all of the numbers just move this out the way so all of the numbers here you want to add up and if that's the case then you can just simply go ahead and click ok and then word has added up all those for you if i just take this out and go over to the left hand side if i go up to layout again and go along to formula you'll see that word's not quite sure so we can go down to this paste function here click on the drop down and go down to sum and then you can see it gives us these brackets here if i type the word in right because i want to add up everything to the right and click ok you can see that now word understands what i want to do and has added up all the numbers to the right in addition when you come to your columns if you select a cell at the bottom of your column go back up to formula and you see once again word has interpreted your table and believes that you want to add up everything above if that's the case then just go ahead and click ok now if you have a situation like we did up here where we clicked on formula and it wasn't in there for us and we have to manually put it in in order to do the rest of the columns without having to retype everything just simply highlight it click command or control c on your keyboard which will copy it click ok when you click on the table again go to formula and all you have to do is paste and that formula will come up again now if it's not a sum that you want to do then you have other options again click at the bottom or to the side whichever line or column of figures you want to deal with go back up to formula and then go down to this paste function here click on the drop down and you can select from any of these options here so let's say we wanted average click on average now what you will find is that word will put that average after the sum now if you press enter now this won't work so what you actually need to do is to get rid of all of this then go down to average then type in above and then click ok now again if you want to do that to the subsequent columns get rid of this type equals go down to average type in above and as we did before highlight everything command or control c to copy it click ok go along to the next column formula command or control v and it will automatically paste click ok along to the next column paste click ok and that's the easiest way to place that formula in all of those different cells so i hope that's helped you today if it has please subscribe and have a great day you