Create a Simple Proforma Invoice Format in Excel for Support

Simple proforma invoice format in excel for Support

So after that, if you want to take a print of it, then how can you do it? You will press the Control P button from the keyboard and you can see that our format in the print preview is looking absolutely accurate, so as soon as you print it, Hello everyone, in today's video we will create a new and mobile format. Let's see how this format is created. First of all we will set the size of the page . We will go to the page layout and after that we will start with the size of the page and slide it to A4 and then go to the view. We will change the view of the page. If the page is Leo then we should have the settings of the page. Now let 's start the format that we have to create, we will add this area and do it as per our wish and after that the next area is A, then after that the people of the company will delete it and will do these JAT pictures, whatever you have. People, you can add it here, we will simplify it here, we will reduce its size, we will crop it, now we will set it in this way and after that we will type here, slide it and make it central lineman and its We will change the tax and will make it bold and delete it and we will OK the option that appears above it, then after this we will add the details, first of all we will add the company name and after that we will add the address and after that we will add the phone. Number and after that we will add email address and after that we will add website and after that we will add date and after that we will add and and after that we will add below which is Bluetooth, we will mention it, we will start this area and we will select it and inside this We will fill the color and its test color will be white and it will be bold, we will fill the company name and present it here and after that we will add next, we will slide this area and do it as per our wish, we will fill the color and its test color will be They will make it white, make it bold and add it here, copy it and paste it here and then add it below, they will create the table of Hanuman, first type the serial number, next add the description and then add the next . We will add the unit price, next we will add it, slide the mount area here and apply border to it and OK it, after that simply you can change the design of the border, go to home and click on Formattable, from here you can select any table. You can do this and after this we will reduce the size of the column, after that we will do the color change in it and go to design and convert and do range and if you remember this then we will merge this area and OK it and We will apply a border on top of it and do it as per our wish and then add it below and drag it down and merge it. Go to Merge and click on the merge class and type software here and then do after and below and add grand. Hotel and apply border on top of it and add the term and respect comment below and after that add bank information below and type repair add this area and merge it and board it and then here We will add and merge it and make it bold, change it a little bit, slide this area and make it no full and this time we will make it enough and remember it from the bottom as well and after that this area which is A also We will add its color and no fill and like this we will also color it and after that and make it central admin and make this area left and slide this area and make it central lineman and start this area and add currency on top of it. Whatever your currency is, you can start from here and after that you will set it in the area below and apply the currency format here also, type the item and add the quantity and add the unit price, then to create the amount. For this we will add formula, we will type and add greater, give zero then multiply it, unit will multiply quality and set it, we will do max product, how will we set this? So our format is complete, if you want to do it through PDF, then how will you do it and after talking a little about the terms and conditions, these promises are visible and if you want to do it through PDF, then How will you do it? Press F12 from the keyboard and whatever name you want to name it, type the name here and then slide the shop type of it like PDF and click OK. Whatever person wants to do from the video, WhatsApp or email. If you want to do this, then it is a big format, then after that if you want to take a friend of it, then how will you press the control P button from the keyboard and you can see that our format in the print preview is looking absolutely accurate, so you can As soon as you click on the friend cover, you can take its print without any hassle. Friends, if you like this video then please like the video and also subscribe to the channel. See you inshallah with a new topic. Allah Hafiz.