Fresh Excel Tips

In this exercise, we have a Column that contains 5 digit numbers and we would like to extract them and add them to each other. So, if a cell contains 11223, then result that we would want to be returned is 9 (1+1+2+2+3=9). To do this, we will be using the MID Function to find [...]

In this exercise we will be using the OR function to check cells for certain values. The formula will check column A for the text “fresh” or “excel” and return TRUE if it finds either word, otherwise, if the criteria is not met, it will return false. Here is how we will apply the OR [...]

In this exercise, we woud like to calculate the average speed at which a vehicle travelled between London and Manchester City. On the way to Manchester City, the average speed was 70 Kph and on the way back to london, the average speed was 55kph. To calculate the overall average speed, we will use the [...]

In this exercise, we have values in cells that need to be divided and put into separate cells. For example, in cell Cell A1, we have Mail-man and we need to put both Mail and man into separate cells separated by “-”. To do this, we will use the TRIM, LEFT, MID and FIND Functions. [...]