Exercise 27

Analysing of Database from the usage of Excel

A normal product Database normally contains :

• Product code
• Products name
• Stock quantity
• Price of unit
• Amount of stock sold
• Profit           

How to create your own database.

Step 1: First off you will add product code , product name , sock quantity , price , sold stock ,profit. Each into one cell.

Step 2

You need to add your information into each column, in this screenshot it also shows you how to calculate total cost from your sales price and stock that is sold. (sold*sales = total cost)

Step 3: you need to repeat this for total sale and profit

but instead for them you do this.

For total sale its stock (solid * sales price) but for profit its (total sale - total cost)

For the final step you need to figure out overall profit  you need to type =SUM and then drag your cursor over the profits and then press enter. After that you will get your total sum.

Then for the final step you will repeat the previous step but this time for total sale and total cost

I have also made a graph for my Products , which shows that there is an overall profit from my products.

I also made a pie chart to show which product has the highest profit which is product 4(3060ti).