Excel Formulas

How to Convert Inches to Feet and Inches in Excel: 5 Methods

Method 1 - Applying INT and MOD Functions Steps: Select cell D5, type down the formula below, and press ENTER to get the result in feet and ...

How to Plot a Log Scale in Excel (2 Methods)

The following table contains the Name, Month, and Salary columns. We want to plot a log scale in Excel for this table. Method 1 - Using ...

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo