Excel Functions

How to Use SEARCH Function in Excel (3 Suitable Examples)

In Excel, we need to deal with a large number of formulas and functions. Moreover, the Excel SEARCH function is quite familiar function in use. This ...

How to Use TEXT Function in Excel (10 Examples)

In Microsoft Excel, the TEXT function is generally used to convert a numeric value to a specified format for various purposes. In this article, ...

How to Use RIGHT Function in Excel (6 Suitable Examples)

RIGHT is another popular function in MS Excel that is used to get the last character or characters in a text string, based on the specific number of ...

How to Use MID Function in Excel (5 Ideal Examples)

While working in Excel, we often need to extract a specific number of characters from a cell. This can be achieved by both the LEFT and the RIGHT ...

How to Use LEFT Function in Excel (4 Suitable Examples)

Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use REPT Function in Excel (8 Suitable Examples)

In Microsoft Excel, the REPT function is generally used to repeat a text or a character a defined number of times in a cell. In this article, you’ll ...

How to Use Excel MAX Function (6 Useful Examples)

In this article, we will learn how we can use the MAX function in Excel. We will also discuss various applications of the MAX function in different ...

How to Use the FIND Function in Excel (7 Methods)

Method 1 – Extracting the Position of a Specified Character in a Text In the following dataset, Column B contains text values, and Column C ...

How to Use LEN Function in Excel (7 Suitable Examples)

Microsoft Excel provides a function called LEN for counting letters, numbers, characters, and all spaces. LEN is a short form of LENGTH. The LEN ...

How to Use CONCATENATE Function in Excel (4 Easy Methods)

Today I will be showing how you can join two or more texts or numbers into one single text value using the CONCATENATE function of Excel. ...

How to Use AVERAGE Function in Excel (5 Ideal Examples)

Excel provides several statistical functions to help you perform tasks easily and swiftly. Today we are going to show you how to use a statistical ...

How to Use SMALL Function in Excel (4 Common Examples)

In Microsoft Excel, the SMALL function is used to extract the nth lowest or smallest value from a range of cells containing numerical data only. In ...

How to Use RAND Function in Excel (5 Examples)

Excel provides several math functions to help you perform mathematical tasks easily and swiftly. Today we are going to show you how to use a function ...

How to Use MIN Function in Excel (6 Relevant Examples)

In Microsoft Excel, the MIN function is generally used to extract the lowest or smallest value from a range of cells containing numerical data only. ...

How to Use LARGE Function in Excel (7 Easy Examples)

In this article, you will learn about the Excel LARGE function and how to use the LARGE function with criteria, duplicates, multiple criteria, text, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo