Excel Formulas

How to Calculate Natural Logarithm in Excel (4 Methods)

What Is a Natural Logarithm? A natural logarithm is the logarithm of a number to the base of e. e is a constant number which is approximately ...

How to Convert Cm to Feet and Inches in Excel – 3 Methods

The dataset contains students' names and their height. To convert cm to feet and inches:   Method 1 - Using the CONVERT Function ...

How to Log Transform Data in Excel – 4 Methods

The dataset below showcases the number of deaths up to June 1st, 2022 in 6 different countries. What Is Log Transform? Log Transform ...

How to Calculate Logarithmic Growth in Excel (2 Easy Methods)

In this article, we will learn to calculate logarithmic growth in Excel. Mainly, there are two types of growth. They are logarithmic growth and ...

Convert Cubic Feet to Cubic Meters in Excel: 2 Easy Methods

Method 1 - Use CONVERT Function to Convert Cubic Feet to Cubic Meters in Excel Steps: Select a cell to apply the formula. We selected cell ...

2 Methods to Use Millimeter (mm) to Square Meter (m2) Formula in Excel

Suppose you have several square-shaped Exhibits with Dimensions in millimeters(mm) and you need to convert them to square meters. Method 1 - ...

How to Calculate the Average Ratio in Excel – 2 Methods

The sample Dataset showcases Products, Sales in January, and in February. Method 1 - Using the GCD Function to Calculate the Average Ratio ...

Round Down to Nearest 10 in Excel (3 Effective Ways)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

How to Calculate Standard Error of Proportion in Excel (with Easy Steps)

The article will show you the proper steps to calculate the Standard Error of Proportion by using Microsoft Excel. It’s an important parameter in the ...

How to Calculate Sharpe Ratio in Excel (2 Common Cases)

In this article, we will explain how to calculate the Sharpe Ratio in Excel. Basics of the Sharpe Ratio The Sharpe Ratio, also known as the ...

How to Calculate the Debt Service Coverage Ratio in Excel (2 Examples)

Dataset Overview Let’s say we have a user’s Debt and Income Statement, or Balance Sheet as shown in the image below. And we want to find the Debt ...

How to Calculate Sortino Ratio in Excel (2 Methods)

  What Is the Sortino Ratio? The Sortino ratio is a risk-adjustment statistics metric used to calculate the return from a certain investment ...

How to Convert Percentage to Ratio in Excel (4 Easy Ways)

We have the following dataset containing the mark sheets of some students. Scores are given in percentages. We will convert these percentage values ...

How to Calculate Odds Ratio (OR) in Excel

Understanding Odds Ratio (OR) The Odds Ratio (OR) represents the likelihood of an event occurring in one group compared to another group. ...

How to Round Time to Nearest 15 Minutes in Excel (6 Quick Methods)

Suppose, you have a list of timestamps of each time a new data entry occurs in your worksheet. Now to analyze the data entry frequency, you want to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo