File to download: Customer Quote sample.docx
You may want to include simple calculations in some of your Word documents, notably Quotes and Invoices. Ideally the quotes and invoices are generated from an Accounting system. But for a lot of small business owners, Microsoft Excel may already be their Accounting system.
I have seen many small business owners use a calculators to do calculations and then manually plug in the numbers into a Word document. It would be easier to embed an Excel object into the form. Please see the below steps how to create one.
Click the “Insert” tab on the Ribbon and click the “Object” command.
In the “Object” pop up screen, choose “Microsoft Office Excel Worksheet” and click the "OK" button.
In the Excel Object, please type in necessary headings and contents, create formulas for calculations, and format it with shades, bold types, borders, etc. Drag the corner of the Excel object to size it the way you want.
Get rid of the gridlines by clicking the “View” tab on the ribbon and unmark the “Gridlines” box.
Below is the finished Word document. To add or change something, you can just double click the Excel Object to edit. The Word document can be saved as a template and used over and over again. Same principal can also be applied for invoices, late notices, refunds, etc.