Excel Formulas

### How to Do GST Reconciliation in Excel (4 Suitable Methods)

In this article, you’ll learn how to do GST reconciliation in Excel with 4 suitable methods. The methods include using different functions like the ...

### How to Create Multiple Invoices from Excel Spreadsheet

In this article, we will learn to create multiple invoices from an Excel spreadsheet. In terms of business, efficient invoicing processes play a ...

### How to Combine Two Formulas in Excel (3 Ways)

In this article, we will learn how to combine two formulas in Excel. Microsoft Excel is a powerful tool for data analysis, calculations, and ...

### How to Calculate Pearson’s Coefficient of Skewness in Excel

In this article, I am going to show how we can calculate Pearson's Coefficient of Skewness in Excel. Excel offers two functions SKEW and SKEW.P to ...

### How to Insert Timestamp in Excel (6 Easy Ways)

In this article, you will learn how to insert timestamp in Excel. Here, I will show you different methods for inserting timestamps. So, you can use ...

### 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 (Step-By-Step)

In this article, you’ll learn how to do three way reconciliation in Excel with 5 simple steps. You’ll also learn what is three way reconciliation ...

### 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 (Detailed Guide)

In this article, you will learn everything you need to know about how to use arithmetic operators in Excel. The main application of Excel requires ...

### How to Create Min Max and Average Chart in Excel

In this article, we will learn how to create a min max and average chart in Excel. We’ll also learn how to add or draw max min or average lines in an ...

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

In this article, we are going to show you how to use Excel IF statement for increment by 1. Along with the IF statement, we will also discuss the ...

### 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)

Comparing two lists in Excel allows you to determine variation between two sets of data. You can compare two lists in Excel for matches to identify ...

### 3D Interpolation in Excel (with Easy Steps)

This article demonstrates the process of doing 3D interpolation in Excel. Basically, we have created a customized UDF (User defined function) based ...

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

Safety stock is essential in many sectors, specially in those that deal with inventory management and supply chain operations. It makes sure that a ... Advanced Excel Exercises with Solutions PDF  