Posts

Showing posts from March, 2018

reflective

Reflective I learnt a lot about website and not only website I studied about excel and formula and more information with using wix and blogger. I started with this create wix account for creating website and use more option to add in website like manage product or create home page and how to using separate page. Moreover, I learnt about how to add payment applications or security to website then I use cookies on my website and my security is Mcafee. I add my payments a lot so there are pay-pal, credit card and debit card. I added more information in my website such as term and conditions, return policy and delivery, after that I learned how to add applications such as searching bar and Live chat, then I tested about how live chat and the search bar works for website UX testing. The last section I learnt about excel formula because I have to use with a website, temperate form which is used for keeping customer details and customer payments also then I finished and submitted.

creating my home page grapphic

Image
1.create blank page first and then determine size of homepage there are width and height 2.use pentool to make background and add color 3. select picture which is i want put in homepage by using rectangular macaque tool and the move this picture to middle  4. i use horizontal type tool with creating text box to write company name and slogan

excel formula

How a spreadsheet can be formatted when you want to format cells in Microsoft Excel, you can do it manually, by selecting fonts, font colour and size, background colours and borders, or you can do the formatting quickly and automatically using styles. If you used styles in other programs, you'll be familiar with the concept: a style a mixture of formatting that you can apply over and over, like paint.  How a SUM is worked out in Excel (formula) =SUMIF ( C2:C5) How do COUNTIF(S) and SUMIF(S) function COUNTIF is a function that will count (as in 1,2,3...) the number of entries within a range if certain criteria are met, and the data within each entry can be text or numbers. SUMIF is if you need to sum a column or row of numbers, let Excel do the maths for you. Select a cell next to the numbers you want to sum, click Autosum on the Home tab, press Enter, and you are done. When you click Autosum, Excel automatically enters a formula (that uses the SUM function) to sum numbe...

live chat working

Image
this is live chat inbox so i can see who contact me by wix live chat

Website UX testing

Image
Domain name:  https://schowhan786.wixsite. com/p1624961x website look professional and it has 8 pages but this website got some problem with live chat but now he fix it.  you can see picture from below he changed chat now to wix live chat this website he show how to using HTML code with website also searching bar can use now i can search some fruit or vegetables in website    social link working in website when i click on their, this link will go on new window. contact page is working now i use contact page for testing now you can see on picture

website

Image
this is website sell furniture and more product as we investigated to customer what they really want furniture at home. we design classic and thinking follow new trend by using high quality material

Sale order

Image
How you would manage customer orders? i manage customer order by using sale order form to know the information that who we sell to i using SUMIF formula to calculate total price which unit price multiply Qty and this sale order i charge for sale tax 0.20 which is 20 percent of total this formula from below =IF(SUM(G39)>0,SUM((G39*G40)+G39),"") Why using an excel database is a good idea to manage this data? i use excel for manage details about customer and it fully necessary to has this form for ordering one time because we can know how customer pay us and what kind of delivery are they want?. when customer write details finish so then we will process this form and sent product to customer.

product inventory

Image
my product inventory i sell 10 products in website. this is website sell only furniture and some stuff that office always have

FAQ and Live chat

Image
This is my FAQ in website i select more question about mostly people will ask and i put live chat below on the left