Excel Formulas Archives

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

Aug 21, 2023

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 Do GST Reconciliation in Excel (4 Suitable Methods)

How to Create Multiple Invoices from Excel Spreadsheet

Aug 21, 2023

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 Create Multiple Invoices from Excel Spreadsheet

How to Combine Two Formulas in Excel (3 Ways)

Aug 20, 2023

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 Combine Two Formulas in Excel (3 Ways)

How to Calculate Pearson’s Coefficient of Skewness in Excel

Aug 17, 2023

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 Calculate Pearson’s Coefficient of Skewness in Excel

How to Insert Timestamp in Excel (6 Easy Ways)

Aug 17, 2023 2

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 Insert Timestamp in Excel (6 Easy Ways)

How to Use Non Linear Interpolation in Excel (

Sep 4, 2023

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 Use Non Linear Interpolation in Excel (

How to Do Three Way Reconciliation in Excel (Step-By-Step)

Aug 14, 2023

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

How to Do Three Way Reconciliation in Excel (Step-By-Step)

Excel ISBLANK vs IsEmpty (Uses and Comparison)

Aug 10, 2023

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

Excel ISBLANK vs IsEmpty (Uses and Comparison)

How to Use Arithmetic Operators in Excel (Detailed Guide)

Aug 28, 2023

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 Use Arithmetic Operators in Excel (Detailed Guide)

How to Create Min Max and Average Chart in Excel

Sep 21, 2023

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 Create Min Max and Average Chart in Excel

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

Aug 8, 2023

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

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

Excel Color Index Numbers

Aug 16, 2023

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)

Aug 7, 2023

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

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

3D Interpolation in Excel (with Easy Steps)

Aug 7, 2023

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

3D Interpolation in Excel (with Easy Steps)

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

Aug 7, 2023

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