Excel Basics

How to Find and Replace Values Using Wildcards in Excel

Today we are going to show you how to find and replace using wildcards. While dealing with data in Excel you may need to eradicate errors or modify ...

How to Find External Links in Excel: 6 Quick Methods

Method 1 - Use Find Command to Search External Links Used in Formulas Steps: ➤ Press CTRL+F to open the Find and Replace dialog box. ➤ In the ...

How to Copy Same Value in Multiple Cells in Excel (4 Methods)

To demonstrate all the ways to copy values, let's use a dataset with Book Name, Author, and In Stock columns that denote a book collection. Some ...

How to Number Columns in Excel Automatically (3 Suitable Ways)

Here we have a data set with the sales record of some products for some years in a company. We'll enter values inside the row called Product No. to ...

How to Combine Date and Time in One Cell in Excel (4 Methods)

While making a time log of activities in Excel, you may want to enter both the date and time in a single cell. In most cases, you may have dates in ...

How to Concatenate with Space in Excel (3 Suitable Ways)

To demonstrate how to use the concatenate function, we will use a dataset with the First Name, Middle Name, and Last Name columns. We will apply ...

How to Use Autofill Formula in Excel (6 Effective Ways)

  For these methods, we’ll use a sample dataset overview as an example in Excel to make it easy to understand. For instance, in the given ...

How to Concatenate Date and Time in Excel – 4 Formulas

Formula 1 - Combining the CONCATENATE and TEXT Functions to Join Date and Time in Excel Columns B and C represent dates and times. In Column D, ...

How to Concatenate Range in Excel (5 Useful Methods)

We’ve got a dataset with the Product ID and Product Name of some products of a company named Mars Group. The values are stored in the Cell range ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo