-
Continue reading →: EXCEL countdown timerWe can use Excel to a lot of things – one way is to use it as a timer Lets create a simple countdown timer. In column A we set the date – the other columns are going to show us how long it is until our set date. For…
-
Continue reading →: EXCEL Age calculatorHere we are going to look into how to create a simple age calculator. It requires input as in the form of your birthdate YYYY-MM-DD Start by entering some headings into Excel We are going to make use of the =TODAY() function. This is a built-in function that returns the…
-
Continue reading →: EXCEL COIN TOSSIn this part we are going to simulate a coin toss. We are going to simulate flipping a coin 10 times and see what the outcome gets. This are going to be pretty easy – we are going to make use of the =RANDBETWEEN() function. As you probably know the…
-
Continue reading →: EXCEL Random password generatorSometimes it is useful to use Excel to generate passwords for us. In this part we are going to make Excel generate 4-characters random passwords for us. We are going to use two different functions for this. The CHAR function returns a character when given a valid character code. For…
-
Continue reading →: Draw Random Values in Excel: A Step-by-Step GuideIn this example we will look at how we can draw a random value from a list in Excel. Start by entering a few values in column A – like below. We are going to use two functions here to make this work The RANDBETWEEN generates a number between 2…
-
Continue reading →: Shuffle Lists in Excel: A Step-by-Step GuideIn this part we are going to see how we can randomize or shuffle a list in Ecxel. Note! We use Excel365 for this – older versions requires a different approach. Start by entering some names of values in column A. Now we need to assign a random value to…
-
Continue reading →: Create a Simple Random Word Generator in ExcelIn this post we are going to see how we can make a simple random word generator. For this we are going to make use of 2 functions: The Randbetween generates a value between a specified bottom value and a specified top value =Randbetween(1:50) The above generates a random number…
-
Continue reading →: How to Generate Random Numbers in Excel EasilySometimes we need to use random numbers in Excel to handle certain situations. The Excel RAND() function returns a number between 0 and 1. This function requires no arguments at all. The RAND() function on its own is very simple to use. Lets clarify with a small example Type =RAND()…
-
Continue reading →: How to Use the Excel FIND FunctionSometimes we need to find a specific character or a group of characters in Excel. There are more than one way to do this, but here we are going to look at the =FIND function. This particular function looks for one text string within another. It does not return the…
-
Continue reading →: Extracting Strings with Excel’s MID FunctionThe MID-function is used for string-manipulation. It is used to extract a part of a string. The function looks like this: MID(text,start_num,num_chars) Text – is the original text/cell value start_num – the position of the first character what you want to search for num_chars – this is the number of…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Excel tutorials 