Latest Blog Posts

How to Remove Parentheses from Phone Numbers in Excel

Consider the following dataset with some people and their phone numbers with parentheses. We'll remove the parentheses. How to Remove ...

How to Delete All Named Ranges in Excel (2 Ways)

Suppose you created a huge number of named ranges in your worksheet but now there is no use for these named ranges. To delete all named ranges in ...

Using an Excel Formula to Change the Phone Number Format

The dataset showcases phone numbers before and after changing their formatting. Changing Inconsistently Formatted Phone Numbers to a ...

How to Apply Number Format in Millions with Comma in Excel (5 Methods)

Method 1 - Using Custom Format to Apply Number Format in Millions with Comma in Excel 1.1 Use of Placeholder Pound (#) Sign STEPS: Select the ...

How to Change the Name of an Excel Column from Numerical to Alphabetical (2 Ways)

To demonstrate the methods, we’ll use the following dataset representing some products’ prices. The column names are in numerical order. ...

How to Create an Excel Filter Using a Drop-Down List Based on the Cell Value – 3 Steps

Step 1 - Set up a Unique List to Create a Drop-Down List Filter Based on the Cell Value in Excel Copy the data. Here, the data in the Category ...

How to Hide Formula in Excel without Protecting Sheet (2 Methods)

The sample dataset consists of sales of six salespeople in January and February. We can see the total sales in another column. We'll hide the ...

How to Convert Date to Year in Excel (3 Methods)

Dataset Overview We'll use the list of dates below to convert to year. Method 1 - Convert Date to Year Using Excel YEAR Function ...

How to Convert Date to Day of Week in Excel (8 Methods)

02/04/2022 represents a date, it does not provide any information on the day of the week. We will convert that value to the day of the week. ...

How to Autocomplete Data Validation Drop Down List in Excel

The Data Validation feature offers control over the values that can be input into a cell. Instead of entering values as usual into the cell, values ...

How to Format Excel Values as Millions with One Decimal Place (6 Methods)

Scenario Suppose we have a dataset with large sales values that are cumbersome to read quickly. We want to use a custom number format to display ...

How to Remove Currency Symbol in Excel (6 Ways)

Excel automatically includes a Dollar symbol for the cells formatted as currency. We will show you how to remove the currency sign from the cells. We ...

Names Not in Name Manager in Excel: 2 Solutions

Method 1 - Manual Solution to the Problem Names Not in Name Manager If the Name Manager does not show defined names, that does not mean no defined ...

Excel Data Validation Drop Down List with Filter (2 Examples)

Let’s consider a dataset containing area-wise sales data of several fruits. We will create a Data Validation drop-down list of areas mentioned in the ...

How to Use Dynamic Named Range in Excel Chart (Step by Step)

  Step 1 - Preparing the Dataset for a Dynamic Named Range in Excel We’re going to use the following dataset that illustrates the growth of ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo