Excel Formulas

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 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 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 ROUND Function in Excel (9 Examples)

In certain circumstances, we prefer the rounded or approximate number rather than the exact number for making communication easier. The ROUND ...

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

Today we will show how you can use the RANDBETWEEN function of Excel to get any random integer between two given numbers. RANDBETWEEN Function ...

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

When you have a decimal number in your dataset, you can use the INT function in Excel to get the nearest integer. Basically, we will discuss in this ...

How to Use ROW Function in Excel?

When you have a tiny dataset, it’s easy to find the row number, but in the case of a larger dataset, you may have to use the ROW function. In this ...

How to Use OFFSET Function in Excel?

Microsoft Excel provides various functions to maximize and speed up your productivity. Today, I will be showing how you can extract a particular ...

How to Use ROWS Function in Excel?

The ROWS function is a popular Excel built-in function that can be categorized under the LOOKUP and REFERENCE Functions. This function returns the ...

How to Use NOT Function in Excel (8 Useful Examples)

The NOT function in Excel returns a logically opposite value. In this article, you’ll learn to use this function and also discuss its application ...

How to Use IFS Function in Excel (3 Examples)

While working in Microsoft Excel, there are various formulas to make our work easier. The IFS formula is one of them. It has a wide range of ...

How to Use TRUE Function in Excel (10 Ideal Examples)

The TRUE function has a special type of compatibility in returning results based on logical conditions. In this article, I’ll discuss how to use the ...

How to Use WEEKDAY Function in Excel (with 8 Examples)

Excel WEEKDAY Function: Syntax & Arguments Syntax =WEEKDAY(serial_number, ) Return Values 0 to 7 (in numbers) ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo