Using MS Excel, create a customer database with at least 10 entries, with screenshots to document and show your progress

 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 ]]

Then i added a pie chart for the total coast and bar graph for the profit.