## How to Remove Commas in Excel [9 Smart Ways]

In this article, I will show you how to remove commas from the names (placed in the middle / in between / last) and the numbers in Excel. Download Excel Workbook At first, download the workbook ...

## Excel Custom Number Format Multiple Conditions

In this article, we are going to discuss the Excel custom number format multiple conditions. We will learn about the meaning and uses of different symbols of the custom number formatting. The custom ...

## How to calculate IRR (internal rate of return) in Excel (9 easy ways)

In this article, I will discuss how to calculate IRR (internal rate of return) in Excel. I will focus on several topics like: Calculating IRR using Excel’s IRR & XIRR function Calculating ...

## Excel Data Validation Based on Another Cell

Data Validation is an important feature in Excel. In this article, we will see how Excel data validation based on another cell is created. Data validation makes a list more creative and ...

## INDIRECT Function Excel: Get values from different sheet

While working in Excel, there are many cases where you want to refer your worksheet to a different worksheet. The topic that we will be discussing in this article is how to use Excel INDIRECT ...

## Excel Index Match single/multiple criteria with single/multiple results

In this article, we are going to discuss an important topic which is "Excel INDEX MATCH multiple criteria multiple results". Finding the exact result for this is very difficult, so we are going to ...

## How to remove leading zeros in Excel (8 easy ways)

In this article, I will show you a good number of techniques on how to remove leading zeros in Excel. We don’t create all our worksheets ourselves. Sometimes we deal poorly formatted worksheets where ...

## VLOOKUP Formula to Compare Two Columns in Different Sheets!

If you have two big columns and you want to compare them, you can use Excel’s VLOOKUP function. In this article, I will show how you can use VLOOKUP formula to compare two columns in different ...

## Using VLOOKUP with IF Condition in Excel (5 Examples)

VLOOKUP is one of the most powerful and top used functions in Excel. Using IF logical function with VLOOKUP makes the formulas more powerful. In this article, we shall see a good number of ...

## How to Merge Excel Worksheets without Copying & Pasting

In this article, we will be familiarized with the topic which is "Merge Excel worksheets without Copying & Pasting". The problem that occurs while copying different elements of a worksheet in ...

## Excel Dynamic Range Based on Cell Value

In this article, we will be discussing the "Excel Dynamic range Based on Cell Value". Here, we will be creating dynamic ranges without selecting them based on some cell value. We will be performing ...

## How to Make Excel Spreadsheet Bigger when Printing

Printing in an efficient way creates a lot of positive impacts on the mother environment and your office balance sheet. So, I always inspire people to print in a smart way. In this article, I will ...

## Excel conditional formatting based on another cell text [5 ways]

In this article, we will be familiarized with an interesting topic which is "Excel Conditional Formatting Based on Another Cell Text". Excel Conditional Formatting makes it easy to highlight data in ...