Excel Functions Archives - Page 18 of 40

How to Use INTERCEPT Function in Excel

Nov 11, 2025

In scientific research, it is required to calculate predicted values. Because in market research or data science, prediction is usually more ...

How to Use NORMINV Function in Excel

Nov 11, 2025

In real life, statistical calculation is our quotidian work. By using Microsoft Excel, we can easily perform these statistical calculations. The ...

How to Use the SIN Function in Excel – 6 Examples

Aug 10, 2024

This is an overview. SIN Function in Excel Function Objective: The SIN function is used to determine the sine of angles in ...

How to Use the SIN Function in Excel – 6 Examples

How to Use QUARTILE Function in Excel: 5 Suitable Methods

Jul 5, 2024

Method 1 - Use the QUARTILE Function to Find Quartiles of Salaries Steps Use the following formula in cell E5: =QUARTILE(C5:C10,2) ...

How to Use QUARTILE Function in Excel: 5 Suitable Methods

How to Use the Excel SLOPE Function – 5 Examples

Aug 15, 2024

The Excel SLOPE Function Description The SLOPE function returns the slope of the linear regression line with known y and x data points. The ...

How to Use the Excel SLOPE Function – 5 Examples

How to Use Excel PRICE Function (3 Appropriate Examples)

Nov 11, 2025

Excel PRICE function is under financial functions, calculates the price of per $100 face value of a bond that pays interest periodically. Quick ...

How to Use Excel PRICE Function (3 Appropriate Examples)

How to Use Excel DSUM Function: 4 Methods

May 25, 2024

Method 1 - Using DSUM as a Function Like all other functions, DSUM is an Excel function, and it works as such. You just have to declare the ...

How to Use Excel DSUM Function: 4 Methods

How to Use the CHAR Function in Excel – 8 Examples

Aug 13, 2024

The American System Code for Information Interchange, or ASCII, is a character encoding standard used in digital communications. A unique integer ...

How to Use the CHAR Function in Excel – 8 Examples

How to Use PERCENTILE Function in Excel (With an Example)

Nov 11, 2025

Calculating percentiles is a common task in Excel for any business purpose or other institutional purposes to analyze data. You can easily calculate ...

How to Use PERCENTILE Function in Excel (With an Example)

How to Convert Date to Number in Excel (4 Methods)

Jul 6, 2024

Method 1 - Converting the Date to a Serial Number in Excel with the DATEVALUE Function We will convert a date to a number in Excel. Here is an ...

How to Convert Date to Number in Excel (4 Methods)

How to Use IRR Function in Excel (4 Examples)

Nov 11, 2025

The IRR function is a financial function in Excel. It returns the Internal Rate of Return (IRR) for a given cash flow (the initial investment and a ...

How to Use IRR Function in Excel (4 Examples)

How to Use TTEST Function in Excel (5 Methods)

Jul 11, 2024

Introduction to TTEST Function in Excel ▶ Function Objective The TTEST function in Excel is used to determine the probability of a significant ...

How to Use TTEST Function in Excel (5 Methods)

Excel N Function (6 Practical Examples)

Nov 11, 2025

The Excel N function is used to check whether a value is a number or not. It returns a Boolean value of either "TRUE" or "FALSE" based on the ...

How to Use the Excel UNIQUE Function to Extract Unique Values (20 Examples)

Jul 28, 2024

Dataset Overview In large datasets, duplicate values or repeated occurrences of the same values can be a common issue. To address this, you can ...

How to Use the Excel UNIQUE Function to Extract Unique Values (20 Examples)

How to Use Excel WEEKNUM Function (5 Examples)

Jun 4, 2024

In this article, we’ll demonstrate various examples of how to use the WEEKNUM function effectively in Excel. Introduction to the WEEKNUM ...