-
Continue reading →: EXCEL – count words in a cellIn Excel we can use forumlas to count the numbers of words in a given cell. We will make use of a combination of different text-functions available in Excel. In the image below – we have our word in cell C7 – how many words is there? Well, we can…
-
Continue reading →: EXCEL – find the longest stringIn Excel we can combine a number of functions to retrieve the longest string or word in our worksheet. We are going to combine the LEN,MAX,INDEX,MATCH functions to get the longest string in our worksheet. Enter some data in column C: In this minimal example we can see that the…
-
Continue reading →: VLOOKUP from another sheetIn the last 2 post we have seen how we can use VLOOKUP to retrieve values for us. Those examples go t information from the same sheet. In this part we are going to see how we can access data from another sheet in Excel. Enter the following data in…
-
Continue reading →: LOOKUP value between two numbersIn this part we are going to explain how we can lookup values between two values – and return a corresponding result. Below we have some temperatures, to the right is our lookup and references. Take the first temperature, its 0 – if we look in our right table the…
-
Continue reading →: EXCEL – USE VLOOKUP TO GET SIZE OF PLANETThe Excel VLOOKUP function is very powerful and can be used in a number of ways to retrieve information. The important thing to remember is that the lookup value must appear in the first column of the table – to the left that is. Here is a quick summary of…
-
Continue reading →: Excel – Calculate highest score – Part 2In the previous part we saw how we can get the highest value in a range using the =MAX() operation. In this part we are going to output the location of the highest score in a given range. The final result are going to look like this: For details regarding…
-
Continue reading →: Excel – Calculate highest scoreIn Excel we can easily calculate grades based on scores – and in that way also calculate the higest grade among student. Enter some names and grades in Excel – like below The get the highest value we are going to make use of the =MAX function The syntax for…
-
Continue reading →: EXCEL grade calculatorIn Excel we can assign a pass or fail grade to students based on score for an exam. Enter some student names and grades in Excel like below: Now for the grades in column C – we are going to make use of the =IFS() function This function checks multiple…
-
Continue reading →: Simple Excel Function for Temperature ConversionIn this part we are going to see how we can use Excel as an converter from Celsius to Fahrenheit. We are going to make use of the function =CONVERT(number,from_unit,to_unit) This function converts a number from one measurement system to another. Start by entering some values in a column –…
-
Continue reading →: EXCEL BMI CALCULATORIn Excel we can make our own BMI Calculator using simple mathematical formulas. Start by entering some heights and weights in Excel – and make a column for the calculated value. In Cell E6 enter the following formula: =D6/C6^2 To fill the rest of the cells – just drag the…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Excel tutorials 