Excel Functions

How to Use TRANSPOSE Function in Excel?

Here's a quick view of the TRANSPOSE function in the following image. Introduction to the Excel TRANSPOSE Function Here are the syntax ...

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

  Introduction to TEXTJOIN Function in Excel Summary Concatenates a list or range of text strings into a single string using a delimiter. ...

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

In this article we will demonstrate how to use Excel's VALUE function to convert various types of data into numbers. Here is an overview: ...

How to Use CHOOSE Function in Excel?

Below is an overview of our sample dataset. Example 1 - Using CHOOSE Function to Get Data from Selected Range The CHOOSE function will ...

How to Use SEQUENCE Function in Excel (16 Examples)

Here's a brief overview of SEQUENCE(5,3,10,5). To learn exactly how we got there, follow the instructions below. Introduction to the ...

How to Use SORT Function in Excel?

An Overview of the SORT Function in Excel: Introduction to the SORT Function in Excel: Syntax and Arguments ⦿ Objective: Sorts a given ...

How to Use ISLOGICAL Function in Excel (4 Examples)

In Microsoft Excel, the ISLOGICAL function is generally used to check whether a given argument contains a boolean value (TRUE or FALSE) or not. In ...

How to Use the ISTEXT Function in Excel (8 Examples)

Excel ISTEXT Function: Syntax and Argument In this section, we will explain the syntax and argument of the ISTEXT function. ISTEXT Function of ...

How to Use the ISNA Function in Excel – 3 Examples

This is an overview. The ISNA Function in Excel The ISNA function is an INFORMATION function in Excel. It checks whether a cell contains ...

How to Use ISEVEN Function in Excel (2 Suitable Examples)

Today I will be showing how you can decide whether a number is even or odd using the ISEVEN function of Excel. This function helps us to define even ...

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

The ISODD is one of the Excel information functions. It is a reference function that assists to show if a given number is odd or not. This article ...

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

The ISNUMBER function in Microsoft Excel is commonly used to determine whether a given argument contains a numerical value. The above ...

How to Use the TRIM Function in Excel (7 Examples)

Introduction to the Excel TRIM Function The Excel TRIM function is categorized under the TEXT functions. It removes the extra spaces from a text ...

How to Use ISBLANK Function in Excel (3 Examples)

In this article, we will discuss Excel's ISBLANK function, as in the following gif. Excel ISBLANK Function: Syntax and Argument ISBLANK ...

How to Use the SUBSTITUTE Function in Excel (7 Examples)

In this article, we will demonstrate some uses of the SUBSTITUTE function with examples. Excel SUBSTITUTE Function: Quick View ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo