Excel Formulas

How to Convert Units in Excel – 3 Methods

Method 1 - Using the CONVERT Function to Convert Units in Excel 1.1. Converting Units in a Single Cell Convert the Temperature from Celsius to ...

How to Calculate the Ratio of 3 Numbers in Excel (4 Ways)

Method 1 - Using the Basic Division Formula STEPS: Select your output cell (E5 here). Insert the formula: ="1:"&C5/B5&":"&D5/B5 ...

How to Calculate Antilog in Excel (With 3 Criteria)

Using log and antilog is very common in mathematical calculations. So, users may have to calculate log and antilog in Excel also. To make long, ...

How to Do Inverse Log in Excel (3 Methods)

Introduction to Log and Inverse Log Suppose we have a number, 1000 (the Result). Additionally, we have another number, 10, which we’ll call the ...

How to Convert Millimeters (mm) to Inches (in) in Excel (3 Quick Methods)

Method 1 - Using the Excel CONVERT Function to convert Millimeter (mm) to Inches (in) The CONVERT function is a built-in function in Excel that ...

How to Convert Square Feet to Square Meters in Excel (2 Quick Methods)

Assume you have a dataset where houses are categorized based on their sizes in square feet. Now you need to convert the sizes from square feet units ...

How to Calculate a Logarithm in Excel (6 Methods)

What is a Logarithm? A logarithm is a mathematical operation that quantifies how a specific number, known as the base, grows by repeatedly ...

How to Convert MM to CM in Excel – 4 Easy Methods

The sample dataset showcases “Name” and “Height” in Millimeter units (MM). Method 1 -Using the CONVERT Function to Convert MM to CM in Excel ...

How to Plot Log Log Graph in Excel (2 Suitable Examples)

Overview of a Logarithmic Scale In the figure below, you can see that the population is increasing at a steeper rate from 1900-to 2000 in the world. ...

How to Make a Mileage Log in Excel (2 Handy Methods)

This article illustrates how to make a mileage log in Excel. A mileage log is simply the record of mileage driven by a vehicle. Besides, it also ...

How to Convert Inches to Square Feet in Excel (2 Easy Methods)

It is pretty common to feel the need to change units of quantities during a calculation. One of the most frequent conversions needed is the ...

Excel Logarithmic Scale Start at 0 (A Detailed Analysis)

The reason the "Excel logarithmic scale doesn't start at 0" is that the log zero value is undefined. A number like this cannot be a real number, ...

How to Calculate Covariance Matrix in Excel (with Easy Steps)

Covariance refers to the measurement of how one variable defers to another. The variables do not have to be dependent on one another. The formula for ...

How to Calculate Compa Ratio in Excel (3 Suitable Examples)

The Compa ratio is very common when it comes to business. Using this ratio, we can understand the employee’s salary range and whether we give them a ...

Converting CM to Inches in Excel (2 Simple Methods)

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. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo