Database Put me in a frame



Database customers and products





For creating my database I used Excel 2016. I open a new page and I named my table Database product and Database customer.

Database product

I used a table function to create a table. For table title cell I used merge cells to link all cells together.
For total stock Quantity, I used the SUM formula for totalizing all stock quantity. Also, I used a scale color for the definition of the table. For the diagram, I accessed the diagram menu which is built-in Excel 2016, the diagram shows all stock Qty. I added on the table bottom a subtotal function.
 To find how many products are in stock I use SUM formula:

  =SUM(C3: C12)  => 124

Farther I use the SUM function to find the total income generated by sold pictures.
The formula I used is
                                                                =SUM(G3: G12)
                                













Database customer: For the customer database, I used Excel 2016. I create a table where I recorded all the customer's name, address, email address, telephone number, and orders. I used table formating to formate the table, also merge cells to create one title table's cell.





For the customer database, I use COUNTIF formula to centralized all dates about how many customers are from Romania, UK or the USA. I use the following formula  :

                                     = COUNTIF(D4: D13," Romania")  => 3 customers



Furthermore, I want to know in percent how many people are from those countries and I use diagram function to represent this percent and I obtained 30% Romania, 60% UK and USA/Bulgary 10%.
I attached bellow the screenshot from my excel work.




I use the show formula function for I can show all the functions I used in Excel.









Comments

Popular Posts