How to Ignore Blank Cells in Range in Excel (8 Ways)

  Consider the following dataset containing the Selling Price and Cost Price of some products of a company. We will use it to demonstrate how ...

How to Create a Formula in Excel to Change Date by 1 Year

In this tutorial, we will learn how to create a formula in Excel to change the date by 1 year. While you are working with date type information you ...

How to Set Cell to Blank in Formula in Excel (6 Ways)

We'll use the example dataset, which includes information on Region, Product, Quantity Price, and Sales. There are some blank cells in the Quantity ...

How to Copy and Paste Formulas from One Workbook to Another in Excel

  Method 1 – Using the Paste Option to Copy Formulas from One Workbook And Paste to Another Steps: Go to Book1 and copy the data (E5:E10) ...

How to Copy Values and Formats with Paste Special in Excel VBA

Method 1 – Applying an InputBox in VBA Paste Special Steps: Go to the Developer tab. Click on Record Macro. Set Excel_Paste_Special_1 ...

How to Delete Infinite Columns in Excel (4 Methods)

Excel 2007 and all the newer versions have 16384 columns in total. When you are working with a smaller dataset, these huge numbers of unused columns ...

How to Delete Multiple Rows in Excel at Once (5 Easy Ways)

The dataset below, Sales of "ABC" Company, shows sales information for products on various dates. It has four columns: Order ID, Product, Amount, and ...

How to Convert Degrees Decimal Minutes to Decimal Degrees in Excel

Calculation for Converting Degrees Decimal Minutes to Decimal Degrees 60 minutes is equal to one degree: 1° = 60' 1/60 degrees equals one ...

Using VBA to Count Duplicates in a Range in Excel – 4 Methods

Method 1 - Embed VBA to Count Duplicate Values in a Range in Excel In the following dataset, Column B contains random numbers. D5 displays 2473. ...

Using VBA to Copy a Formula from the Cell Above in Excel – 10 Methods

This is an overview. The dataset shows mathematical results in column B. The formula behind the results for each cell is shown in Column D. If ...

Excel Advanced Filter: Apply “Does Not Contain” (2 Methods)

The sample dataset contains the Product Name, Product Category, and the shipping Address of customers. We will use Excel Advanced Filters does not ...

How to Use an Advanced Filter If the Criteria Range Contains Text in Excel – 5 Methods

This is the sample dataset.   Method 1 - Using an Advanced Filter for a Cell That Contains Unique Text Values The dataset ...

How to Calculate Working Days between Two Dates in Excel (4 Methods)

Method 1 - Use the Excel NETWORKDAYS Function to Calculate Working Days Between Two Dates Case 1.1 - Calculate Working Days Between Two Dates ...

How to Apply VBA PasteSpecial and Keep Source Formatting in Excel: 4 Easy Examples

Method 1 - Add Input Box by Using VBA PasteSpecial and Keep Source Formatting in Excel Press  Alt  +  F11   to start a Macro. Click on the ...

How to Count Duplicates Based on Multiple Criteria in Excel

Method 1 - SUMPRODUCT Function to Count Duplicates Based on Multiple Criteria Enter the following formula in cell F5, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo