Create Your Online Bill Format in Excel for Purchasing

Online bill format in excel for Purchasing

welcome to the Virtual Office training today we will learn how to create po purchase order in Microsoft Excel just go to the file new on office template search box just type purchase order and press enter it will show the different type of purchase order just click one of them and press download and it will show the purchase order on Excel just change the logo of your company here right click change picture and select the company logo and insert it will show the company logo here which is your company name just type the name of your comp company suppose your company is computer world and you if you have any slogan just type here and if you don't know just remove it and type the address of your company City phone number and email here if you have any PO number just type the PO number and date is automatically display the two date because here is a function of today and today is 27 number it will display the 27 November date and if you have any customer ID just type and if you don't know just remove it just type the name of the vendor company name uh State address uh and City and phone number here vendor name is uh sheras and companies r s and type the address of uh these companies and so on and type the city and type the phone number here and where you want to sh ship this product just type the name of the company name of the person company name address and so on City and phone number here and shipping method if you have any shipping method by air by uh bus by train just type the shipping method and shipping term if you have any term then you you uh you have to type here and delivery date here I have I want to purchase some LCD just type the quantity here item number and LCD what is the item LCD and unit price of LCD is 8,000 $800 and it will calculate uh the amount automatically because uh if you multiply this amount of uh this quantity to the unit price then it will display the total amount and subtotal is if you have another item just type the quantity suppose we have purchase we have to purchase 25 keyboard and amount is $100 then it will display the total amount and it will automatically calculate the total amount here sub tootal is here and total amount is not displayed just double click here it will display the amount and if you have any cell tax just type here for cells for example cell taex is five % and it will uh calculate the 5% here and total amount is 44,6 25 celex is 5% and total amount is here just type the uh remaining option remaining uh field here and and your PO will be created and looks like here just Ty uh click the preview button you can see the PO here and there is some missing word here go to the page uh go to the view and select the page break preview and drag it to this here and now you can see the complete po here and you can print by click here hope this tip will be very helpful for you thanks for watching