Excel Formulas

How to Insert Timestamp in Excel (6 Easy Ways)

Here's an overview of inserting a timestamp into an Excel table via VBA. Read on for the full discussion. Download the Practice Workbook ...

How to Use Non Linear Interpolation in Excel

In this Excel article, we will learn how to calculate non-linear interpolation Excel. While working on a dataset, we need to deal with those data ...

How to Do Three Way Reconciliation in Excel: 5 Methods

Method 1 - Inserting Bank Statement and Transactions Record in Dataset Insert the bank statement for the month of July in a sheet titled ...

Excel ISBLANK vs IsEmpty (Uses and Comparison)

In this article, we will learn about ISBLANK vs. IsEmpty in Excel. Microsoft Excel is a popular tool for organizing and managing data. When you need ...

How to Use Arithmetic Operators in Excel (a Detailed Guide)

Types of Operators in Excel There are four kinds of operators for calculation. They are: Arithmetic Comparison Text concatenation ...

How to Create a Min-Max-Average Chart in Excel – 4 Steps

This is an overview: Download Practice Workbook Download the practice workbook. Min Max Average Chart.xlsx What Is a ...

How to Use Excel IF Statement for Increment by 1 (3 Examples)

In this article, we will demonstrate how to use the Excel IF statement to increment by 1. We will also increment by 1 using the COUNTIF function, and ...

Excel Color Index Numbers

In this article, we will get Excel color index numbers using Excel VBA. Here, we will learn how to get color index numbers in Excel and how to change ...

Compare Two Lists in Excel for Matches (All Methods and Uses)

Here's an overview of comparing two lists for matches with an exact match via IF. How to Compare Two Lists for Matches in Excel Method 1 ...

3D Interpolation in Excel: 4 Easy Methods

Method 1 - Finding the Value of Z Find out the value of the Z from the Z = SIN(x2+y2)/√(x2+y2) equation. We used the following formula in the D5 ...

How to Calculate Safety Stock in Excel (6 Easy Methods)

In this article, we will demonstrate some of the most commonly used methods of calculating safety stock in Excel, from the simple arithmetic way to ...

How to Calculate Economic Order Quantity in Excel

  What Is Economic Order Quantity? It means the optimum level of order quantity, not higher or lower. Economic Order Quantity (EOQ) is a ...

Excel Color Index Formula

In this article, we will explain how to use the Excel color index formula. One of the standout features of Excel Color Index is its ...

How to Make a Bill of Materials in Excel (2 Types)

  Type 1 - Making a Bill of Materials for a Single Product   Step 1. Create a Basic Dataset for Making a Bill of Materials We have ...

Excel Formula to Change Cell Color Based on Text (3 Easy Methods)

Suppose you have the following dataset: Method 1 - Applying Conditional Formatting Steps: Application of Cell Rules Select the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo