Lesson#113: How to highlight cells with errors in it
I will show you how to highlight cells with errors among an array of values. Here …
Lesson#113: How to highlight cells with errors in it Read more →
Lesson#112: Calculate the match percentage of text which matches another text.
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 →
Lesson#111: Extract parts of text separated by a special character
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 →
Lesson#110: Separate characters from the text where any word appears
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 →
Lesson#109: Tricks to make a dancing chart in excel
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 →
Lesson#108: How to divert the user to another cell in workbook when clicked
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 →
Lesson#107: How did I add MS Project features to the Excel project schedule
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 →
