How to Freeze Columns in Excel (5 Methods)

While working with a big dataset sometimes we need to know how to Freeze Columns in Excel as well as Rows, or both of a worksheet. It’s necessary to ...

Conditional Formatting If Cell is Not Blank

Method 1 - Use the Conditional Formatting ‘Highlight Cell Rules’ Option If a Cell Is Not Blank Steps: Select the entire dataset B5:D13. ...

How to Use TYPE Function in Excel (8 Examples)

The TYPE function in Excel will return an integer number based on the type of data that you are entering. In this article, you will be able to know ...

How to Remove Formatting in Excel Without Removing Contents

"Removing formatting in Excel without removing contents" means separating the raw data (text, numbers, formulas) from formatting (font styles, ...

VLOOKUP Not Working (8 Reasons & Solutions)

Although VLOOKUP has some limitations, the reason why VLOOKUP is not working is usually human error. To demonstrate the possible issues and their ...

How to Swap Columns in Excel (5 Methods)

Let's assume we have a dataset with First Names, Last Names, Salaries, and Countries in Columns B, C, E, and D respectively. Method 1 - ...

Excel LOOKUP vs VLOOKUP: With 3 Examples

Method 1 - Dealing with Approximate Match One of the main differences between LOOKUP and VLOOKUP functions is that the LOOKUP function is bound to ...

How to Group and Ungroup Columns or Rows in Excel

  Consider you have data in existing cells that contain names from different countries. They have different room numbers to be allocated ...

How to Find If Cell is Blank in Excel (7 Methods)

In this article, we will discuss if an Excel cell is blank or contains any data. Sometimes, while working with spreadsheets, we might need to find if ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo