How to Use Excel IFNA Function (5 Suitable Examples)

Excel IFNA function is primarily used to handle the #N/A errors. It returns a specific value as per your instruction if such a #N/A error occurs; ...

How to Use the CLEAN Function in Excel – 10 Examples

This is an overview. CLEAN Function in Excel Function Objective The CLEAN function removes all non-printable characters from a text. ...

How to Sum Multiple Rows in Excel (4 Quick Ways)

  Download the Practice Workbook Sum Multiple Rows.xlsx 4 Quick Ways to Sum Multiple Rows in Excel Method 1 - Using the SUM ...

How to Remove 0 from Excel (7 Methods)

When we work with spreadsheets not prepared by us, we face different types of number formats in cells. For example, phone numbers may contain leading ...

How to Add Characters in Excel (with Formula, Flash Fill & VBA)

Here's an overview of a method where characters are added using Flash Fill. Download the Practice Workbook Add Characters.xlsm ...

How to Unhide Columns in Excel (8 Methods)

In this article, we are going to illustrate 7+ methods with examples to unhide columns in Excel. The feature to hide a column in Excel makes columns ...

How to Select Specific Data in Excel (6 Easy Methods)

  We have a datasheet where ID, Marks, and Student Names are given in columns B, D, and C, respectively. We will use the dataset to select ...

How to Calculate in Excel If Cells are Not Blank: 7 Exemplary Formulas

Method 1 - Combine IF and AND Functions to Calculate If Cells are Not Blank Step 1: Add a row to show the calculation. Step 2: Go to ...

How to Remove Single Quotes in Excel (6 Ways)

Consider a dataset of product descriptions for some products. The texts in the product description column lie between single quotation marks. If you ...

Why VLOOKUP Returns #N/A When Match Exists (with Solutions)

We will be using a sample product price list as a dataset to demonstrate all the reasons. Reason 1 - Lookup Value Doesn’t Exist in the ...

How to Apply Conditional Formatting to Color Text in Excel

While working with a big dataset in Excel that contains numerous entries, we need to find texts based on their specific text values, conditions, and ...

INDEX MATCH vs VLOOKUP Function (9 Practical Examples)

Here's an overview of using the INDEX-MATCH and the VLOOKUP functions in a dataset. INDEX-MATCH vs. VLOOKUP Function in Excel: 9 Examples ...

How to Use Nested VLOOKUP in Excel: 3 Methods

Method 1 - Using Nested VLOOKUP in Excel to Extract Product Price Steps: Click on the cell that you want the Price of the ID (e.g. cell beside ...

How to Use the VLOOKUP Function in Excel VBA – 4 Examples

Quick View: Sub VLOOKUP_with_User_Defined_Lookup_Value() Book = InputBox("Enter the Name of the Book: ") Set Rng = Range("B4:D13") MsgBox ...

How to Remove Partial Data from Multiple Cells in Excel (6 Methods)

Dataset Overview To make the explanation clear, we'll use a dataset representing product information from a fruit shop, but some information is ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo