2, we first create a new excel form and open. The first line needs to be enlarged to do the title, and to put their own company LOGO, so that you can highlight the formal quotation.
3, then we need to empty a line under the title, and write the product quotation, certainly the name of the document to write clearly, and need to be centered. Then below the empty line, the left side of the quotation written on the single number, the right side of the date of the quotation, these are necessary.
4, and then down, the left side to fill in the customer's information, put the customer in front of the customer to show respect for the customer, the right side to fill in their own company information, company information is generally, name, contact person, contact number, fax, email and so on. According to each company's different self-editing.
5, and then the following we began to produce the body of the form, which needs to be mentioned is the production of the form before we need to mark the front of the figure in the paragraph, of course, you can re-edit. This will allow customers to be more clear and concise.
6, and then the form name details of the input layout, enter the name you want to quote, model, quantity, price and so on. Here to mention is that we first do not rush to adjust the font, first layout of the overall situation. Finally make adjustments.
7, and then we add a border to the table content, and then look at the other positions still need to adjust what, such as the title of the offer, we have not been centered
8, there are customer information and the offer of the company's information have not yet done to make further adjustments, we are the corresponding cell merger, and then look at the distance between the left and right to make adjustments
9, we can first preview, the above part is largely completed, the feeling that the following is still missing something. We also need to do some quotes below the form of instructions. For example, the payment method and offer validity, etc., it is necessary to add some terms and conditions and so on.
10, at the bottom we also need to add the customer's confirmation, seal or signature confirmation, this is also a must have, and more important, so as to show the norms.
11, finally we previewed again, the overall coordination, and can be said to be the initial molding, then we go to adjust the font size in all aspects.