Excel Formulas

How to Concatenate Rows in Excel with Comma (4 Easy Methods)

We'll use the following example where we have a list of G-7 countries in 7 rows (B5 to B11). We'll put the entire list in a single cell, with the ...

How to Model Uniform Probability Distribution in Excel (3 Ways)

Looking for ways to model uniform probability distribution in Excel? Then, this is the right place for you. Here, you will find 3 suitable ways to ...

How to Calculate Variance Inflation Factor in Excel

In this article, we will learn to calculate the variance inflation factor in Excel. It is also expressed as VIF. Variance Inflation Factor or VIF ...

How to Calculate Semi Variance in Excel – 3 Simple Methods

Semi Variance evaluates the variation among the observations in a sample. Semi-variance deals  with the observations that are below the average of ...

How to Remove Chart Border in Excel (with Quick Steps)

Whether you are wondering how to remove a chart border in Excel, you have come to the perfect spot. We regularly need to build charts in Excel for ...

How to Calculate Lead Time in Excel (2 Examples)

What Is Lead Time? Lead time refers to the duration between the start of a process and its completion. Specifically, it represents the time required ...

How to Calculate Current Age in Excel (2 Easy Ways)

Method 1 - Nesting YEARFRAC and TODAY Functions to Calculate Current Age In Microsoft Excel, you can get your current age by nesting the YEARFRAC ...

How to Calculate On-Time Delivery Performance in Excel: A 3-Step Procedure

Let’s say your dataset contains arrival times, both actual and estimated, for ten stores, and you would like to calculate your delivery performance. ...

How to Create Minimum Variance Portfolio in Excel: 2 Methods

Method 1 - Using Matrix to Create Minimum Variance Portfolio (Multi Assets) Steps: Need to calculate the Excess Returns of these companies. Go ...

How to Calculate Conditional Probability in Excel (2 Easy Ways)

Looking for ways to calculate conditional probability in Excel? Then, this is the right place for you. Here, you will find 2 easy ways to calculate ...

How to Create a Project Budget in Excel – Easy Steps

Here’s an overview of the dataset:   Step 1 -Creating a Project Budget Header Choose a header for the summary and project ...

How to Create an Option Probability Calculator in Excel

Overview of Option Probability Probability represents the likelihood of an event occurring among all possible outcomes. In the context of options, ...

How to Do Trapezoidal Integration in Excel (3 Suitable Methods)

  Introduction to Integration in Excel As there is no direct way to find the integral of a function in Excel, we will use the concept of ...

How to Get Simulation Probability in Excel (with Easy Steps)

Microsoft Excel is a powerful software. We can perform numerous tasks on datasets using Excel tools and features. There are many default Excel ...

How to Calculate Productivity Percentage in Excel (4 Useful Methods)

Suppose you have the following dataset: Method 1 - Find the Labor Productivity Percentage Steps: To multiply the number of laborers ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo