Lesson#117: How to split up characters of text in excel
Here I will show you a nice trick to split up characters of text in excel. …
Lesson#117: How to split up characters of text in excel Read more →
Excel Funtions
Lesson#115: Information functions with Conditional Formatting
Here I will share general tips about Conditional Formatting and some Information functions. These functions are …
Lesson#115: Information functions with Conditional Formatting Read more →
Lesson#114: How to highlight cells with text or non-text values
We will discuss how to highlight text values or non-text values among an array. In the …
Lesson#114: How to highlight cells with text or non-text values Read more →
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#106: How to VLOOKUP pictures in excel
Okay, friends here I will show you some interesting tricks about Excel. That is how to …
Lesson#105: Excel function OFFSET and some examples
Here I will show some examples related to the function OFFSET. Before starting I will discuss …
Lesson#105: Excel function OFFSET and some examples Read more →
Lesson#103: 4 Ways to find duplicate values in a worksheet
Often we need to find the duplicate values in an Excel worksheet. Here in this post, …
Lesson#103: 4 Ways to find duplicate values in a worksheet Read more →