Excel Functions

How to Use Excel SHEET Function (6 Examples)

Microsoft Excel has a variety of functions and tools. The Excel SHEET function accepts only one argument, value, which can be a reference, a ...

How to Use Excel XOR Function (5 Suitable Examples)

Excel XOR Function: Syntax and Arguments ⦽ Function Objective: Performing exclusive OR function ⦽ Syntax: XOR(logical1, ,…) ⦽ ...

Best value How to Use Excel XOR Function (5 Suitable Examples)

How to Use ROUNDDOWN Function in Excel (5 Methods)

While working with numbers that have decimal parts in Excel we need to round down those numbers for ease of calculation or decimal parts of the ...

How to Use LINEST Function in Excel: 4 Suitable Examples

Method 1 - Simple Linear Regression Using the LINEST Function Steps Select the range of cells E5:F5. Type the following formula: ...

How to Use the SUBTOTAL Function in Excel (3 Methods)

Introduction to the SUBTOTAL Function The SUBTOTAL function returns a list or database and falls under the Math/Trig function category. It offers 11 ...

How to Use RATE Function in Excel (3 Examples)

The RATE function in Excel is a financial function that calculates the interest rate per period of an annuity to pay off a loan or the rate of return ...

How to Use SQRT Function in Excel

Below is an overview image of how to use the SQRT function in Excel. Introduction to the SQRT Function Function Objective: The SQRT ...

How to Use SHEETS Function in Excel (5 Useful Examples)

Introduction to Excel SHEETS Function The SHEETS function is a built-in function added in the Excel 2013 version which returns the number of ...

How to Use COS Function in Excel (2 Examples)

In this article, we are going to discuss the Excel COS function, its uses, how to use it with degrees, COS square, why COS 90 is not zero, and how to ...

How to Use CONVERT Function in Excel

Here's an overview image of using the CONVERT function in Excel. CONVERT Function: Syntax and Arguments ⦿ Function Objective The ...

How to Use CORREL Function in Excel (3 Examples and VBA)

In Excel, the CORREL function is used to determine how closely two sets of data are associated with each other. In this article, we will show you how ...

How to Use Excel MONTH Function: 6 Methods

Method 1 - Simply Use Excel MONTH Function to Get the Month Number Steps: Type the below formula in Cell C5. =MONTH(B5) The ...

How to Use the CELL Function in Excel – 5 Examples

This is an overview:   The CELL Function in Excel Function Objective: The CELL Function returns information about a cell ...

How to Use YEAR Function in Excel (5 Examples)

We store various dates in the Excel sheet to store any information on any work, projects, or data. By using the YEAR function, you will be able to ...

How to Use YIELD Function in Excel (4 Effective Examples)

In some cases, we have to calculate the yield based on a security or purchased bonds. Mathematically, we need to solve a complex equation for ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo