Blog Post 5 Excel

Blog Post 5 Excel
Today we learnt about having a new sheet and adding in discount codes, and adding in codes to get a certain amount off the total. To make data neater borders are recommended. Also can use the conditional format for bad and good, in different colours. Green = Good and Red = Bad. Then after this we worked out how we could use the price bought in and then the price sold for to work out the overall price. As well as this using the conditional formatting the colour of the green cell with the overall profit changes if the price went below £2500 profit. To work out profits.

Today we learnt about having a new sheet and adding in discount codes, and adding in codes to get a certain amount off the total. To make data neater borders are recommended. Also can use the conditional format for bad and good, in different colours. Green = Good and Red = Bad. Then after this we worked out how we could use the price bought in and then the price sold for to work out the overall price. As well as this using the conditional formatting the colour of the green cell with the overall profit changes if the price went below £2500 profit. To work out profits.

Written on January 22, 2018