Learn || Apply || Share
Proper formatting is what makes the text look more clean and neat. Excel PROPER function can help us in capitalizing the 1st character of every word in the text, let us how to use it. 1. What is the PROPER Function? 2. What is the Syntax? 3. How to use it with an example? 1. … Continue reading How To Use Excel PROPER Function – A Quick Guide
Excel LEN function can be of great use during the data validation. Many a time, we might be required to limit the text size to a particular length, which can be determined using this function. 1. What is the Excel LEN Function? 2. What is the Syntax? 3. How to use it with an example? … Continue reading How To Use Excel LEN Function – Complete Guide
There is always a possibility of extra spaces being added to the text by mistake, which needs to be taken care of before performing any operations on the data. Excel’s TRIM function can be used to achieve the same…!!! 1. What is the Excel TRIM Function? 2. What is the Syntax? 3. How to use … Continue reading How To Use Excel TRIM Function – Complete Guide
Suppose we have the date of birth of an employee available with us and we just want to take out the year part of it. Let us see how excel’s RIGHT function can help us with that…!!! 1. What is the RIGHT Function? 2. What is the Syntax? 3. How to use it with an … Continue reading How To Use Excel RIGHT Function – Tutorial
Many a time during the on-boarding process, we might be required to take the first few letters from the name to form the login username. Let’s look at how helpful the Excel’s LEFT function can be to us…!!! 1. What is the LEFT Function? 2. What is the Syntax? 3. How to use it with … Continue reading How To Use Excel LEFT Function – Explained
Sometimes we might want to convert the text to LOWER case irrespective of whatever case it has been entered as. Excel LOWER function can be used to achieve the same. Let’s see how to use it in detail… 1. What is the LOWER Function? 2. What is the Syntax? 3. How to use it with … Continue reading How To Use Excel LOWER Function – A Quick Guide
Sometimes we might want to convert the text to UPPER case irrespective of whatever case it has been entered as. Excel UPPER function can be used to achieve the same. Let’s see how to use it in detail… 1. What is the UPPER Function? 2. What is the Syntax? 3. How to use it with … Continue reading How To Use Excel UPPER Function – A Quick Guide
An average is the most used mathematical function in our daily life. It can be during the score calculation or financial maths, we end up using the average most of the times. Excel AVERAGEIFS function can come handy during the calculations where you need to apply more than one filtration before finding the average. Let’s … Continue reading How To Use Excel AVERAGEIFS Function – A Complete Guide
An average is the most used mathematical function in our daily life. It can be during the score calculation or financial maths, we end up using the average most of the times. Excel AVERAGEIF function can come handy during the calculations where you need to apply some filtration before finding the average. Let’s see how … Continue reading How To Use Excel AVERAGEIF Function – A Quick Guide
An average is the most used mathematical function in our daily life. It can be during the score calculation or financial maths, we end up using the average most of the times. Excel AVERAGE function can come handy during the calculations. Let’s see how to use it in detail… 1. What is the AVERAGE Function? … Continue reading What Is Excel Average Function – A Quick Guide