1, first of all, the production of the table header, in the first column, enter the company name, in the second line, enter the word "Quotation", you can merge the cells so that the input text is displayed in the center.
2, and then enter the contents of the following chart suppliers and contacts related information.
3, after the production of specific quotations form, according to the following chart of the details entered into the corresponding accounts.
4, you can add a picture column in the back of each serial number, for the quotation unit to insert pictures to use.
5, and finally enter the description of the information need to pay attention to, and in the lower right corner of the form to enter the inquiry and contact information can be.
excel2010 graphic template how to useIn order to make their own pivot charts more attractive, and go to great lengths to dress up the charts very beautiful. However, in the future work, if you need to create a similar chart, whether it is necessary to re-modify the chart to beautify it? Let me bring you excel2010 graphic templates below the use of methods.
excel2010 graphic template set the following steps:
Save the template
In Excel2010, just their own design of a nice chart saved as a chart template, and then create a similar future charts, chart templates can be based on the charts to quickly create the same beautiful charts.
1, first in the Excel worksheet, select the pivot chart has been designed, and then switch to the "Pivot Chart Tools" of the "Design" context tab, in the "Type" option group, click the "Design" tab. "Options group click Save As Template button, shown in Figure 1.
Figure 1 Save as Template button
2, in the Save Chart Template dialog box that opens, for the chart template to give an easy to understand the name, and click the Save button to save it in the default directory, as shown in Figure 2.
Figure 2 Save Template
Application Template
Save the chart template, when the need to create the same appearance again when the chart (the chart can be a pivot chart, can also be an ordinary Excel chart), you can quickly generate the template based on a beautiful chart. This article to create a common Excel chart as an example.
1, in the Excel worksheet, select the chart data source, switch to the "Insert" tab, in the "Chart" option group click the dialog box launcher button, shown in Figure 3.
Figure 3 Dialog Launcher
2, in the immediately opened "Insert Chart" dialog box, click the left navigation bar in the "Template"
folder
, and then in the "My Templates" folder
. "My Templates" list, select the previously saved chart template, as shown in Figure 4.
Figure 4 my template
3, click OK button to close the dialog box, a beautiful chart with a template similar to the creation of a successful, at this time, only according to the actual situation in the "title" placeholder to enter the title of the actual meaning of the title of the text can be completed to finalize the chart of the production, as shown in Figure 5.
Figure 5 rapid production of charts
Since the establishment of the chart template, each time the design of the chart, with the help of which to simplify the production of charts,
Working efficiency
has been effectively improved.
On excel2010 graphic templates related articles recommended:
1.excel2010 create a template of the tutorial
2.excel2010 make
Gantt chart
Template tutorial
3.Excel2010 how to convert data into graphs
Assuming that excel has a template picture how to insert the required pictureIf you mean how to insert a picture, then you can choose "Insert" - "Picture", and then select the picture that needs to be inserted, inserted after editing the location can be.
If you want to have a new template in the picture you need, then you can insert the picture you need in that template, save as xlt format template can be.