Quotation Making Tutorial-How to Make Price List

How to make a quotation 1: How to make an EXCEL quotation? Tick off the grid line under the options in Sichuan/Tools/Options/Views/Windows and confirm.

Question 2: How to make a quotation with pictures and insert it directly?

Question 3: How to quote with excel table? I used the Vlookup function. At home, I automatically get the unit price after selecting items, and then I automatically get the combined price after adding the quantity.

Question 4: How to make the quotation sheet? Hehe, you are full of energy. Don't bother. Download the same software as word from Kingsoft Guardian. There are various forms in it. Anyway, there's nothing to say about this.

Question 5: How to make a quotation sheet with Excel, an OFFICE software in Office. It appears in the form of a grid. Just fill in one by one according to your idea, add a border, and the font spacing is medium. It is very easy to use. Just try it.

Question 6: How to make the quotation sheet? I can help you, but you need to explain the requirements.

Question 7: How to quote with pictures? Table method is as follows:

Excel version reference: 20 10

1. Put the cursor in the table.

2. Click Page Layout-Background, and then select the desired picture.

3. Click Insert Finish.

Step 4 check the effect

Question 8: How to make a quotation sheet with pictures? Excel table, click the insert drop-down box above to select the right side of the picture, select the picture to be inserted from the file, and click Insert. it doesn't matter

Question 9: I want to make a quotation. How to do it with pay? Please draw a sketch. .

Question 10: How to use the form for automatic quotation? Professional software, which can automatically insert documents.

How to make a price list 1 We need to use excel tables for quotation. Of course, you can also use word.

2. We first create a new excel form and open it. The first line as the title needs to be widened, and your company's LOGO should be put in to show the formality of the quotation.

Then we need to leave a blank line under the title and write down the product quotation. We must clearly write down the name of this document and center it. Then leave a blank line at the bottom, write the quotation number on the left and the quotation date on the right. These are all necessary.

4. Then fill in the customer information at the bottom and left, put the customer in front to show respect for the customer, and fill in your own company information on the right. Company information generally includes name, contact person, telephone number, fax, email, etc. Edit by yourself according to the difference of each company.

5. Then let's start making a word list. What needs to be mentioned here is that before making the table, we need to mark the paragraphs in the previous picture. Sure, you can edit it again. This will make customers more clear.

6. Then enter the details of the table name, and enter the name, model, quantity, price and so on you want to quote. What I want to mention here is, don't adjust the font in a hurry, first arrange the overall situation. Finally, make adjustments.

7. Then we add a border to the table content, and then see what other positions need to be adjusted, such as quoting the title. We haven't put it in the center yet.

8. Customer information and quotation company information have not been further adjusted. We have merged the corresponding cells and then adjusted them by looking at the left-right distance.

9. We can have a preview first. The upper part is basically completed, and I feel something is missing below. We also need to explain some quotations under the table. For example, the terms of payment and the validity period of the quotation. And it is necessary to add some clauses.

10. At the bottom, we also need to add the customer's confirmation, stamp or signature for confirmation. It is also necessary and important to show the specifications.

1 1. Finally, after we preview it again, the whole thing will be more harmonious, and it can be said that it has taken shape. Next, we will adjust the font size from all aspects.

How to make quotation sheet with EXCEL? Create a new excel table and rename it as a reference, which is convenient for us to find files.

Select the cells in columns A-G, then select "Merge Cells", click in the middle, and enter the title "Report Unit Price".

Change the height of the title line to 35. You can set it freely here, as long as it looks beautiful.

Then in the second line, we fill in the product number, product name, specification, quantity, unit price, amount, delivery date and other information. , and can also be deleted freely according to actual needs.

Here I marked "Communication" in white on a black background, so as to distinguish it from the upper part, facilitate reading and finding important information, and the color can be set freely, which is very beautiful.

In the second half, we need to add the buyer's contact person, the buyer's contact phone number, the buyer's fax phone number, the buyer's address and the buyer's postal code.

Supplier contact number, supplier contact person, supplier fax number, supplier address and supplier postal code.

After filling in all the information, we set the table border as a solid line, thus completing a simple quotation.