Latest Blog Posts

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

How to Use Formula for 30 Year Fixed Mortgage in Excel?

Method 1 - Calculating Per Installment Payment for 30 Years Fixed Mortgage Using PMT Formula Steps: Select the Cell where you want to Calculate ...

How to Change the Scope of a Named Range in Excel – 3 Methods

This is the sample dataset. Method 1. Using the Define Name Feature to Change the Scope of a Named Range Steps: Go to Formulas >> ...

Excel Mortgage Repayment Calculator with Offset Account and Extra Payments

What Is Mortgage Repayment Calculator with Offset Account? According to the AMP website, an offset account can be linked to a loan account. The ...

How to Fix If Right Click Copy and Paste Are Not Working in Excel (11 Solutions)

We have a dataset containing information about several Armani group sales representatives. Columns B, C, D, and E give the sales representatives' ...

How to Add Item to Drop-Down List in Excel (5 Methods)

Adding items will depend on how a drop-down list is created. We will consider the following dataset for this purpose. Method 1 - Add Item ...

Get the First Day of the Current Month in Excel (3 Methods)

Microsoft Excel offers a handful of methods to get the first day of the current month. You can also get the first day of any random month or for the ...

How to Insert Picture from URL Using VBA in Excel (2 Methods)

We will use the sample dataset below to insert images into the blank column (Image column) from the URLs given in the URL column. Method 1 - ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo