Create the Perfect Bill Format in MS Word for Finance with Ease

Bill format in ms word for Finance

hi everyone welcome to techpista in this video i'm going to show you how to create a auto calculated invoice in word some people would like to create the invoice by using microsoft word but word table they manually calculate the table column values for example in the invoice product price quantity they need to calculate for total price in this case how they can set up auto calculated formula in word let's learn how you can setup this in my word document i have created the invoice format in the invoice format i have a product's name quantity unit price and total then i have a subtotal tax and grant hotel so first i have to calculate for the quantity and unit price so i have to select the cell then go to home then click on the layout here i have to click on the formula here we have to multiply the quantity and unit price so that we have to remove this then go to select the function as product inside of the bracket i have to enter the left the left means you have to calculate the numerical value from this left side so that you have to make sure this column should not only add at the numeric value if you added this it's it's also calculated so you have to make sure what are the fields you need to calculate it that fields only shows here for example quantity and unit price only shows here then the number format should be 0.00 then click ok now the quantity and unit price calculated automatically so we have to apply this formula to all rows so i have to copy this and paste for all rows but the problem is field is not updated so we have to select the field and right click and click on the update fields so do the changes in all rows now we have to calculate the subtotal for this 5 rows so i have to select the subtotal rows then go to formula here i have to add the sum that means we have add this value as a sum inside of the bracket we have to add above the means the subtotal calculated above the rows now the total value has been calculated we have to add the number format so again go to formula here i have to choose 0.00 now the format has been corrected so now we have to add the tags so we have to select the tax row then go to formula before go to the formula you have to know about the cell's internal value the internal value is by default the column has a alphabetical that means first column i say a and second column as a b and third column is c and the fourth column is a d and the row number is internal name is numeric value one two three four five like this so you have to why you have to know this because we have to use the internal name here select the text cell and click on the formula so we have to add the formula so we have to remove this so we have to calculate this value so so what are the internal name for this row first is a b c that means this is the column is c value because this is one column this is a c column and the row number is one two three four five six seven that mean we have to add c seven then we have to multiply and inside of the bracket i have to add 5 divided by 100 then the number format should be 0.00 then click ok now you can check it out this is the tax the tax value properly calculated so now we have to add the grant total so that means we have to the subtotal and tax value should be sum so i have to select the grant title cell click on the formula here the formula should be sum that is okay but inside of the bracket we have to add rows internal value that means we have to add the subtotal subtotal value that means the internal name should be a b c c 7 7 means 1 2 3 4 5 6 7 so c 7 comma the next row is c 8 then the number format should be select and click ok now you can check it out the grand total has been calculated so if you change the value for the quantity as a 30 so it's not updated automatically so you have to manually update the fields so every time you have to update the fields so in this way you can create the auto calculated invoice in microsoft word thanks for watching this video if you have any question under the comment section [Music]