Excel Formulas

How to Calculate Eigenvalues and Eigenvectors in Excel

  What Are Eigenvalues? The Eigenvalues are a set of scalar values associated with a set of linear equations that has a non-zero absolute ...

Delta Hedging in Excel – 3 Examples

What Is Delta Hedging? In stock markets, delta hedging is used to lower the risk and maximize profit. Example 1- Calculate Delta Hedging Using ...

How to Calculate Eigenvectors in Excel (with Detailed Steps)

In linear algebra, when a set of equations forms a square matrix, we are able to form eigenvectors of that matrix. An eigenvector is a non-vector ...

How to Calculate Quartile Deviation in Excel (4 Easy Methods)

This tutorial will demonstrate how to calculate quartile deviation in Excel. It is essential to use quartile deviation in almost every aspect of our ...

How to Use Conditional Formatting with the IFERROR Function in Excel – 4 Examples

The dataset showcases Name, Salary, Week, and Per Week Salary. To determine per week salary by dividing Salary by Week: Use the following ...

How to Use Excel DGET with Dynamic Criteria (with Precise Steps)

Have you ever wondered how to apply the DGET function of Excel for multiple dynamic criteria? The DGET function of Microsoft Excel is one of the ...

How to Use AND and OR Functions in Excel (3 Practical Examples)

While working in Excel, we often use the AND function. Sometimes we also use the OR function. There are times when we might need to use both the AND ...

How to Find the Distance Between Zip Codes Using a Formula in Excel – 2 Methods

The sample dataset has 2 types of columns (Location 1 and Location 2). Method 1 - Using a Geometric Formula to Find the Distance Between ...

How to Use IF and IFERROR Combined in Excel (3 Examples)

Example 1 - Calculate the Sales Bonus We have two columns containing Sales Target and Sales Achieved for some products. We’ll check in Column E if ...

How to Calculate Vector Multiplication in Excel (2 Useful Examples)

For scientific analysis, we may have to calculate vector multiplication. We can use the Excel spreadsheet for this multiplication. In this article, ...

How to Separate Quotient And Remainder in Excel (5 Easy Ways)

When you divide a number by another number it returns a quotient and a reminder. If you are looking for a way to separate these two in Excel then you ...

How to Calculate Uncertainty in Excel (3 Effective Ways)

Method 1 - Using the Uncertainty Formula We have a set of readings of a certain parameter. We are going to determine the uncertainty of the ...

How to Calculate Kurtosis in Excel (2 Methods)

  Formula to Calculate Kurtosis Despite having a biased estimation if you do not have the full-scale data of a given phenomenon, we will ...

Delta Neutral Strategy in Excel (2 Practical Examples)

When evaluating assets or stock options, we have to think dynamically as we can take many options, as well as the prices can change at any time. In ...

How to Lookup in Excel Dictionary (2 Suitable Ways)

One of the most useful features of Excel is having a dictionary that enables us to check for meaning and spelling. In this article, we will learn ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo