Here I will discuss an interesting formula. With this formula, we can calculate the percentage of …
Lesson#112: Calculate the match percentage of text which matches another text. Read more →
Here I will show you how to extract parts of text separated by a special character. …
Lesson#111: Extract parts of text separated by a special character Read more →
Here I will show how to separate characters from the text where any text appears. Here …
Lesson#110: Separate characters from the text where any word appears Read more →
Here I will show you a funny trick to make a dancing chart in excel. For …
Lesson#109: Tricks to make a dancing chart in excel Read more →
Hi friend. Here I will show a method to divert a user to anywhere in the …
Lesson#108: How to divert the user to another cell in workbook when clicked Read more →
Here I will discuss a long topic about Excel Gantt chart making. I will show how …
Lesson#107: How did I add MS Project features to the Excel project schedule Read more →
Okay, friends here I will show you some interesting tricks about Excel. That is how to …
Do you know which is the easiest method to separate words from the text? It is …
Lesson#104: The easiest method to separate words from a text Read more →
Here in this post, I will show you how to hyperlink all files and folders in …
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. …
Lesson#100: Making a master formula to separate words from the sentence Read more →