Latest Blog Posts

How to Combine Multiple Columns into One Column in Excel

Method 1 - Using the CONCATENATE or CONCAT Function to Join Multiple Columns into One Column in Excel In the following picture, the three columns ...

Opposite of Concatenate in Excel (4 Options)

  Method 1 - Split Text into Multiple Cells with Formula In the following table, Column B contains five distinct cells, each of which contains ...

How to Perform Predictive AutoFill in Excel (6 Easy Ways)

The sample dataset includes Serial No. and Name in columns B and C, respectively. We'll use these values to fill the columns via Predictive Fill. ...

How to Concatenate in Excel (5 Easy Methods)

One of the most important features of Excel is to collect and contain data from various places into a single cell. In other words, to concatenate. ...

How to Concatenate Two Columns in Excel – 2 Methods

This is the sample dataset.   To concatenate the First Name and Last Name:   Method 1. Combine Names in Two Columns ...

VLOOKUP Example Between Two Sheets in Excel

Example 1 - Using VLOOKUP Between Two Sheets in the Same Excel Workbook In the following picture, Sheet1 is representing some specifications of a ...

How to Add Numbers in Excel (5 Easy Ways)

While working in Excel, we often need to add numbers for various purposes. After creating a data set, you may feel to edit or add numbers within the ...

How to Auto Populate from Another Worksheet in Excel

Method 1 - Linking Excel Worksheets to Auto Populate from Another Worksheet Sheet1 contains some specifications of smartphone models. In ...

How to Number Rows in Excel (9 Simple Methods)

In Excel, you may come across repetitive tasks often. To number rows is one of these tasks which can be a time-consuming one. There are several ways ...

How to Create a Drop-Down List in Multiple Columns in Excel: 3 Methods

Method 1 – Creating an Independent Drop-Down List  In the dataset below, we see Camera Lens Models and prospective model names. We will use these ...

How to Auto Update Drop-Down List in Excel: 3 Methods

We have a list of payment types for which we want to create a drop-down list. However, to insert any other payment types, we want to update our ...

How to Create Multi Select ListBox in Excel (With Easy Steps)

  Step 1 - Creating an Excel Table from a Dataset Create a dataset with the information of 10 City Names and their Total Population on a ...

How to Autocomplete from List in Excel (4 Easy Ways)

In this article, we will describe various techniques to autocomplete cells or columns from a list in Excel. We used Excel 2019 here, but the ...

How Do I Add 7 Days to a Date in Excel (5 Methods)

Let’s consider a situation where you are working in an online bookstore and after every seven days, you have to deliver certain books to some ...

Excel Dependent Drop Down List (Create with Easy Steps)

In this article, we will demonstrate how to create a dependent drop down list in Excel. To explain the process, we'll use the following data set with ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo