How to use the Purchase Order template in Microsoft Excel

In this article we will learn about how to prepare the Invoice template in Microsoft Excel.

Purchase order template is an extremely simple business and budget friendly solution. If you want to create a purchase order, and if you already use Excel or Open Office, simply download our free purchase order template, and you can whip put a purchase order in a matter of minute with this version. You only add a logo or color scheme command forms to customize the form.

The most widely use of purchase order and Invoices is where bulk order purchase happen.

The company sends purchase order to the supplier/vendor for purchase items then supplier/vendor send items with the invoice to the company. Purchase order template is an extremely simple business and budget-friendly solution. Creating a sales invoice is very easy, just follow the following steps.

Select File > New > Search invoice in the search box and select the type of template from many templates.

PO 1

After selecting,Excel will create a readymade purchase order template which will look like this.

PO 2

Enter the details as indicated in the above image.

The template will result the output as in the image below.

PO 3

Your invoice is ready to send

You just have to add content and let Excel does your work. Hope you learned How to use templates making Purchase orders and Invoices in Excel. You can perform these functions in Excel 2013 and 2010. Find more articles about Excel here. Feel free to mention your any unresolved query. We will help you.

Popular Articles:

50 Excel Shortcut to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel 2016

How to use the SUMIF Function in Excel


  1. There are plenty of free purchase order templates available on the internet. You can google them. you can also search for "purchase" in excel 2016. go to file, click new and search for "purchase".

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.