Do you know which is the easiest method to separate words from the text? It is Text to Columns. Yes, my friend, there is no other easiest way to do it. Now I show you the easiest method to separate …
Lesson#104: The easiest method to separate words from a text Read more »
Often we need to find the duplicate values in an Excel worksheet. Here in this post, I will discuss 4 Ways to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT The Excel MODE function returns the …
Lesson#103: 4 Ways to find duplicate values in a worksheet Read more »
How to avoid name conflict errors when copying a sheet in Excel. In this post, I will discuss a serious problem faced by many Excel users. Whenever we try to copy a sheet Excel sometimes shows an error. The name …
Lesson#102: How to avoid name conflict error when copying a sheet in Excel Read more »
Here in this post, I will show you how to hyperlink all files and folders in the worksheet within a minute. This can be done very easily. Often we need to make the summary of soft copies and link those …
Lesson#101: Hyperlink all files and folders in the worksheet within a minute Read more »
Hello. Now we will learn how to make a master formula to separate words from sentences. For that, I will use functions, TRIM, MID, SUBSTITUTE, REPT, and LEN. 1st step: I will change the text by replacing all the <SPACE> with …
Lesson#100: Making a master formula to separate words from the sentence Read more »
OK. I am back again with some crazy formula. Here in this post, I will show you how to make a formula to separate words from a full name. Here in this above picture, I have a list of names …
Lesson#99: Formula to separate words from a full name Read more »
So I have discussed creating a chart and what type of data is suitable for what type of chart. Now I am going about a detailed discussion about the features and options behind the chart. These are very important when …
Here I will show you some examples for column charts and bar charts as well. Column charts can be used to represent data or values graphically which are arranged in categories. Here we are having a whole year of average …
