MS Excel

on

 Progress 

In this blog I will show the progress in creating the product table for the website and insert the formulas inside the tables to calculate. 


1) Firstly, I filled the table as shown below :



2) To calculate the Total Cost by multiplying the 'unit price' with the 'stock quantity' as shown below I inserted the formula : 



3) After the calculation it will show the Total Cost pf the product and I used this for all the Total Cost cells by dragging it down : 



4) For the Total sale I used the same formula that I have used in Total Cost shown below the final calculation for the table : 



5) The calculation for the profit I used different Formula which is subtracting the Total sale from Total cost by inserting the formula in the first cell I dragged it down to calculate it for all cells and below is the final calculation :

6) Finally I have created a pie chart and a bar chart as shown below : 






Comments

Post a Comment