Excel Formulas

How to Make an Availability Schedule in Excel (with Easy Steps)

In this article, we'll demonstrate how to create an availability schedule template in Excel, as in the video and image below. Watch Video – ...

How to Reference a Named Range in Another Sheet in Excel (3 Examples)

  What Is Named Range in Excel and How to Create It Names frequently refer to individuals, things, and locations in daily life. For instance, ...

How to Use the Excel INDIRECT Function with Named Range (2 Examples)

Named Ranges are a powerful feature in Excel that allows you to assign a name to a range of cells, making it easier to reference and use that range ...

How to Perform Permutation and Combination in Excel VBA

In mathematical analysis, especially in the fields of Probability and Statistics, Optimization, and Data Analysis, Permutation and Combination are ...

How to Use Sales Run Rate Formula in Excel (3 Handy Examples)

The sales run rate is used to estimate a company's potential future revenue based on its present revenue. It is determined by dividing the total ...

Excel If Cell Begins with Certain Text Then Return Value

Consider the following dataset of products and their IDs. We can search for a specific product using a predetermined value or a given value in a ...

Excel Formula to Calculate Number of Days Between Two Dates

In this article we will demonstrate several methods to calculate the number of days between two dates using a simple formula. Download ...

How to Create Running Subtraction Total in Excel (2 Easy Ways)

We'll use a concise dataset of 11 rows and 6 columns, which are Region, Rep Name, Item, Units, Unit Cost, and Total. Method 1 - Using ...

Excel MIN Function Returns 0: 2 Possible Scenarios

We're going to cover the cases where the Excel MIN function returns 0, as well as some workarounds to deal with this. Here's an overview of the ...

How to Find Coefficient of Determination in Excel: 4 Methods

Method 1 - Find the Coefficient of Determination from the Correlation Coefficient 1.1 Using Arithmetic Formula Steps 1: Multiply the ...

How to Calculate the Stock to Sales Ratio Using a Formula in Excel – 4 Steps

This is an overview: The Stock to Sales Ratio The stock to sales ratio is calculated by dividing the value of the average inventory held ...

How to Use Excel ISBLANK to Identify Blanks in Range

Example 1 - Use the Excel ISBLANK Function in a Range to Know If a Cell Is Blank We have a list of values in B5:B9. Use the formula in cell C5. ...

How to Apply Cubic Spline Interpolation in Excel (with Easy Steps)

Cubic Spline Interpolation is a curve-fitting method to interpolate a smooth curve between discrete data points. We use this interpolation in various ...

How to Add a Text Prefix with a Custom Format in Excel – 4 Examples

This is an overview: Example 1 - Add a Designation Prefix Steps: Select D5:D14. Press Ctrl+1. In the Format Cells window, go ...

How to Calculate Sales Conversion Rate Using Formula in Excel

In this article, we will demonstrate how to calculate the sales conversion rate formula in Excel. What Is the Sales Conversion Rate? The ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo