Latest Blog Posts

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

How to Make a Data Validation List from Table in Excel (3 Methods)

  Here's a sample data set to use for the validation list. We opened the Data Validation option from the Data tab. We ...

How to Insert an Image into a Cell with Excel VBA (2 Methods)

Quick View Sub Insert_Single_Image() Image_Name = "Argentina" Image_Location = "E:\ExcelDemy\National Flags" Image_Format = ".png" ...

FIND Function Not Working in Excel (4 Reasons with Solutions)

Overview of the FIND Function Description The FIND function is used to locate a particular character or substring inside a text string ...

How to Find and Replace in an Excel Column (6 Methods)

Dataset Overview Let’s assume we have a dataset of a company’s sales with columns A to G representing Delivery Date, Region, Sales Person, Product ...

Using the INDEX-MATCH Function with Multiple Criteria for a Partial Text in Excel – 2 Methods

The Excel INDEX Function The INDEX function returns the value of a cell at the intersection of a row and column in an array or range. Syntax ...

How to Merge Data from Multiple Workbooks in Excel (5 Methods)

We’ll use the following dataset that represents some salespersons’ sales in different regions. We’ll use two more workbooks, which also represent ...

How to Name a Column in Excel (3 Easy and Effective Ways)

Method 1 - Using Table Title to Name a Column in Excel In the following table, we can see that the columns are represented by the English letters A, ...

How to Show Formulas When Printing in Excel

In day-to-day use, users need to show Excel formulas when printing. Showing formulas in print may be the result of various users' requirements. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo