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
Post a Comment