Exercise 28

 Order form using Excel

In this blog I will be demonstrating in steps on how to create an order form by the use of excel.

The first step is highlighting your product list and then naming it in the e5 box, you should name it as ProductList.

The second step will be making your Product look up , you will highlight and then name  your entire table , this way if you ever need to get information from it , you only need to write its name.You should name it ProductLookUp.

In the next step you will need to add  a new sheet on the same excel document and that is where you will be  writing down your product number , product name , price , quantity and total into different cells.

 You will then need to highlight however many cells you want underneath your product number, then you will press data validation furthermore you will need to  press on the allow box and change it from any value too list. Furthermore a new box will appear which you will need to type in =ProductList

Your next step is to write =VLOOKUP under your product name , after  that press onto your cell underneath your product number also add a comma in between each value .The product number here is B8.You will then write ProductLookUp after that you will write the number that is associated with the column that has your product name which for me is 2 and lastly you will write false.

You will then repeat it for price , quantity and total.

Next step is getting your total price by writing down =SUM and then highlighting your total.

Lastly the most time consuming step,  the copying of the previous steps but this time to get your customers details.For example in step 1 you will do Namelist instead of Product list.