Thursday, December 27, 2012

How to Make a Sales Order Form in Excel 2007


1. Open a new workbook in Microsoft Excel 2007. Click on the 'Office' button on the top left hand corner and select 'New.'
2. Select the Microsoft Office Online under 'Templates' and type sales order in the search box. Hit 'Enter.'
3. Select a template such as 'Sales order (Simple Blue design).' Click on the 'Download' button.
4. Fill in information on the company name, slogan, date, invoice, customer ID, return address, and shipping address. In order to add the company logo, go to cell A1 and click on the 'Insert' tab in the toolbar. Click on 'Picture' and find the picture on your computer and click on the 'Insert' button.
5. Enter the following information pertaining to the order: salesperson's name, job, shipping method, shipping terms, delivery date, payment terms, due date, quantity, item number, description, unit price, discount, and sales tax. The line total cell is automatically calculated by multiplying the quantity by the unit price, and subtracting any discounts. The total discount cell, subtotal, and total cells are also automatically calculated using formulas.

Blogger news