ExcelDemy - Free Excel Tutorial & Online Courses

How to Link a Cell Value with a Drop Down List in Excel (5 Ways)

Sep 24, 2021 Excel Basics

The drop-down list is a great helper When you are working with a large database and you need to pick a specific item from a list. Using a drop-down ...

How to Populate a List Based on Cell Value in Excel (6 Ways)

Sep 23, 2021 Advanced Excel

In MS Excel, sometimes we may need to determine or find values based on some criteria or condition from a list. Assuming we have a task plan with the ...

How to Use TEXTJOIN Function in Excel (3 Examples)

Sep 23, 2021 Excel Functions

TEXTJOIN is one of the most important and widely used functions in Excel that has been available from Excel 2019. Today I will be showing how you ...

Conditional Drop Down List in Excel (Create, Sort and Use)

Sep 23, 2021 Excel Basics

In Microsoft Excel, the applications of the conditional or dependent drop-down list are immense in the field of data analysis. And creating this ...

How to Auto Populate Cells in Excel Based on Another Cell

Sep 23, 2021 Advanced Excel

How good would it be if cells get filled automatically? Most of the time we will love that. Today we are going to show you how to auto-populate cells ...

How to Create Dynamic Dependent Drop Down List in Excel

Sep 22, 2021 Excel Formulas

Today I will be showing how you can create a dynamic dependent drop-down list in Excel using both Formulas and Tables. What is a Dynamic Dependent ...

How to use IF Statement to Create a Drop-Down List in Excel

Sep 22, 2021 Excel Basics

It’s quite often that you need to create a conditional drop-down list. The IF function is a useful one while dealing with any “conditional” ...

How to Remove Drop-Down List in Excel

Sep 23, 2021 Excel Basics

In MS-Excel drop-down list helps us to enter input correctly and properly. It is one of the most used properties in Excel. Fortunately, Excel ...

INDIRECT Function with Sheet Name in Excel (4 Criteria)

Sep 23, 2021 Excel Formulas

In Microsoft Excel, the INDIRECT function is generally used to return the reference specified by a text string. In this article, you’ll learn how you ...

How to Use VALUE Function in Excel (5 Common Examples)

Sep 23, 2021 Excel Functions

Excel provides several text functions to perform your desired text-related tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Reference Worksheet Name in Formula in Excel

Sep 23, 2021 Excel Formulas

We may know how to work with more than one worksheet in Excel. But sometimes while working with more than one worksheet, we have to reference one ...

INDIRECT VLOOKUP in Excel

Sep 23, 2021 Excel Formulas

The INDIRECT function in Excel helps the users to lock the specified cell in a formula. Therefore, without changing the formula itself, we can modify ...

Formula Using INDIRECT INDEX MATCH Functions in Excel

Sep 23, 2021 Excel Formulas

In MS Excel, INDIRECT, INDEX, MATCH functions are the most used functions. These functions can be used to find some specific data from any given ...

How to Use VLOOKUP for Partial Match

Sep 23, 2021 Excel Formulas

There may arise a situation where you need to perform a partial matching within VLOOKUP. To assist you, today we are going to show you how to operate ...

VLOOKUP and Return All Matches in Excel (7 Ways)

Sep 23, 2021 Excel Formulas

There are several ways to apply VLOOKUP or vertical lookup in Microsoft Excel to return data based on multiple matches. In this article, you’ll get ...

Latest Posts