Latest Blog Posts

How to Use Formula for Car Loan Amortization in Excel?

We can easily calculate the car loan amortization by using Microsoft Excel financial formulas. This is an easy task. While purchasing a car, ...

How to Remove Hyperlink Permanently in Excel (4 Ways)

If you want to Remove Hyperlink in Excel Permanently in an easy and quick way, this article is for you. Here we will walk you through some easy and ...

Excel VBA: Format Number with Comma (2 Examples)

How to Write Code in the Visual Basic Editor Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the ...

How to Hide Formula in Excel Using VBA: 4 Methods

Method 1 - Embed VBA to Hide the Formula of a Range in Excel Steps to Protect a Sheet: Go to the tab Review. Click Protect Sheet from the ...

VBA INDEX MATCH Based on Multiple Criteria in Excel (3 Methods)

This is the sample dataset for illustration. We will extract a certain result residing in one column based on conditions from the other two columns. ...

How to Format Phone Number with Dashes in Excel: 2 Methods

Method 1 - Using Format Cells Option 1.1 Using Special Category Excel has some built-in number formats which you can access from the Format Cells ...

How to Format Phone Number with Country Code in Excel (4 Methods)

  Method 1 - Using Format Cells Dialog Box Select the range containing phone numbers. Press Ctrl+1 to open the Format Cells dialog ...

How to Put Parentheses for Negative Numbers in Excel

The following sample dataset of Purchase Price and Selling Price are provided in USD for each Product. If you subtract the Selling Price from the ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo