USING MS EXCEL, CREATE A CUSTOMER DATABASE WITH AT LEAST 10 ENTRIES, WITH SCREENSHOTS

Customers information:

Product table:

9 columns were created to store the relevant data of the product :

Product ID, Product Name, Unit Price, Stock Quantity, Stock Sold , Sale Price, Total Cost, Total Sale, Profit .

I also calculated the Total Cost, Total Sale and Profit using formulas within Excel 

Total Cost : =SUM([@[Unit Price]]*[@[Stock Quantity]])

Total Sale : =[@[Unit Price]]*[@[Sale Price]]

Profit : =[@[Total Sale ]]-[@[Total Cost ]]

 

I have added a pie chart for the total coast and bar graph for the profit.