Excel Basics

How to Enter Time in Excel: 4 Methods

Method 1 - Enter Current Time in Excel i. Using Keyboard Shortcut to Enter Time Step 1: We have a dataset containing only the names of some ...

Find And Replace Multiple Values in Excel (6 Quick Methods)

Method 1 - Use the Find and Replace Tool for Multiple Values in Excel Case 1 - Find and Replace Text Values In the table below, we want to replace ...

How to Create List from Range in Excel (4 Easy Ways)

Method 1 - Creating a Drop-Down List from Range The following sample dataset will be used for illustration. 1.1 Independent Drop-Down ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo