How to Use MEDIAN Function in Excel (4 Suitable Examples)

While working in Excel, we may need to find the median value in a range of data that actually reflects the median level of the dataset. We can ...

How to Freeze Rows and Columns at the Same Time in Excel

We have an Excel worksheet with information about a company. We'll freeze the column header and the employee names so they stay on the screen while ...

How to Use LOOKUP Function in Excel?

Here's an overview of the article, which represents a simplified application of the LOOKUP function in Excel. You’ll learn more about the dataset as ...

How to Use AVERAGEA Function in Excel (10 Examples)

In Excel, the AVERAGEA function works to get the average value of any kind of given data type, whether numeric values or text or boolean, AVERAGEA ...

What Is Table Array in Excel VLOOKUP?

What Is Table Array Argument in VLOOKUP Function? The Table Array argument in the Excel VLOOKUP function is used to find and look up the desired ...

How to Use ColorIndex in Excel VBA (4 Examples)

Excel VBA ColorIndex Codes Check out the picture below for the ColorIndex of all the colors available in Excel VBA. Here’s a dataset with ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo