Excel Basics Archives

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

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

How to Create a Drop Down List From Another Sheet in Excel (2 Methods)

Sep 23, 2021 Excel Basics

When you are working with a large database and you need to pick a specific item from a list, a drop-down list can help you in this situation. Using a ...

How to Edit Drop-Down List in Excel (4 Basic Approaches)

Sep 23, 2021 Excel Basics

In Excel, a drop-down list is a helpful feature to fill the right data in a field (cell or column) swiftly. Once you build the drop-down list you ...

How to Make a Drop Down List in Excel (Independent and Dependent)

Sep 23, 2021 Excel Basics

When analyzing large amounts of data, the use of drop-down lists streamlines the experience. And you can make this drop-down list within a minute in ...

VLOOKUP To Compare Two Lists (Same or Different Sheets)

Sep 23, 2021 Excel Basics

Performing a comparison between a couple of lists is one of the familiar tasks in Excel. Today we are going to show how to compare two lists using ...

How to Create Custom Sort List in Excel

Sep 23, 2021 Excel Basics

While working in Excel, we often have to sort a range of cells according to our own needs. Sorting these manually may take a lot of time and it is ...

Excel Auto Sort When Data Changes (9 Examples)

Sep 23, 2021 Excel Basics

In Microsoft Excel, there are numerous procedures to auto-sort a table or an array if someone changes data. In this article, you'll learn how you can ...

VLOOKUP with Two Lookup Values

Sep 23, 2021 Excel Basics

Depending on circumstances you may need to use multiple lookup values with VLOOKUP. For easing your effort, today we are going to show you how to use ...

Combining SUMPRODUCT and VLOOKUP in Excel (2 Examples)

Sep 23, 2021 Excel Basics

In Excel, you may need to use different sum family functions: SUM, SUMIF, SUMPRODUCT, and so on. Depending on circumstances, it’s quite common to ...

Combining SUMPRODUCT and VLOOKUP in Excel (2 Examples)

VLOOKUP with 2 Conditions

Sep 23, 2021 Excel Basics

In Excel, you may need to search values using different lookup functions: LOOKUP, VLOOKUP, HLOOKUP. Today we are going to show you how to use VLOOKUP ...

How to Write Greater Than or Equal To in Excel IF Function

Sep 23, 2021 Excel Basics

The IF function in Excel is a logical function where you may need to use various comparison operators: equal, not equal, greater than, less than, and ...

How to Sort Duplicates in Excel (Columns and Rows)

Sep 22, 2021 Excel Basics

Sorting is one of the most common tasks in the daily use of Excel. You need to perform various sorts; sort multiple columns, sort dates, sort data ...