## How to Find Q1 and Q3 in Excel

To calculate the Interquartile Range, you have to first find the first quartile (Q1) and third quartile (Q3) values. If…

## 9 Ways to Remove Leading Zeroes in Excel

Excel is programmed to remove the leading zeroes from the worksheets by nature. But sometimes you may find the leading…

## An Overview of SUBSTITUTE Function | Microsoft Excel

The SUBSTITUTE function is one of the text functions in Microsoft Excel. You can use it as a standalone function…

## An Overview of RIGHT Function | Microsoft Excel

The RIGHT function is one of the most commonly used text functions in Microsoft Excel. The  RIGHT function is usually…

## How to Tackle #CALC! Error in Excel

While working with formulas in Excel to do your necessary calculations, you may encounter various errors. One such error is…

## 2 Ways to Create a Stem and Leaf Plot in Excel

The Stem and Leaf plots help to note down multi-digited numbers really fast. You may need to create a Stem…

## 2 Ways to Make Residual Plot in Excel

To find the non-linear values in a specified range, you may need to apply the Residual Plot to your assignments….

## How to Fix #SPILL! Error in Excel

Excel is renowned for its powerful array formulas that can perform calculations on multiple cells simultaneously. However, working with dynamic…

## How to Solve #NULL! Error in Excel

The #NULL! error occurs when you attempt to perform an intersection operation that references non-contiguous ranges or cells. In this…

## How to Solve #REF! Error in Excel

The #REF! error occurs when a formula references a cell or range that is invalid or has been deleted. In…