Latest Blog Posts

How to Highlight Duplicates in Two Columns Using Excel Formula

If you are looking for some special tricks to highlight duplicates in two columns using the Excel formula, you've come to the right place. In ...

How to Use VBA to Set a Range Variable to Selection in Excel (5 Methods)

In this article, we will demonstrate some ideas about how to use Excel VBA to set a Range variable to selection. We can execute some common ...

Excel VBA: Loop Through Columns in Range: 5 Methods

Method 1 - Loop Through Columns to Find a Value Range Using VBA in Excel A large dataset to work with. In the dataset, Column A holds the order ...

Interest Only Mortgage Calculator with Excel Formula (A Detailed Analysis)

When you take out a loan to buy something and wish to return it over time with monthly payments, you may need to know the amount of the monthly ...

Excel Auto Fit Row Height for Wrap Text (4 Methods)

    Method 1 - Keyboard Shortcuts to Auto Fit Row Height and Text Wrap in Excel The sample dataset contains a list of top ten books by ...

How to Make an Excel Table Expand Automatically (3 Ways)

In the sample dataset below, some aspects of the table can become unclear due to inadequate row height and column width. Method 1 - Make ...

Excel VBA Code for Each Row in a Table (Add, Overwrite, Delete, etc.)

Excel Table is an interesting feature of Microsoft Excel. A table is a group of cells with data for a particular use. In Excel, we can use data from ...

How to Find Highest Value in Excel Column (4 Methods)

We’ll use the following dataset to discuss 4 methods for finding the highest value in a Excel column. Method 1 - Find the Highest Value in ...

How to Search by Sheet Name in Excel Workbook (2 Handy Methods)

Method 1 - Right-click the Navigation Button The Navigation button can be found just above the Status bar. In an Excel workbook containing ...

Compare Two Tables and Highlight Differences in Excel (4 Methods)

We have two tables that show the pricing of the same product in two shops. We'll highlight the differences between the price columns. How to ...

VBA to Loop through Rows of Table in Excel (11 Methods)

  Consider the following dataset, which we'll use to showcase looping through rows in a table. Method 1 - Embed VBA to Loop ...

How to Find Lowest Value in an Excel Column (6 Ways)

To demonstrate all the methods, we'll use the same dataset below. It shows Bitcoin prices by months in dollars. We'll look for the lowest price on ...

How to Add Dashes to SSN in Excel (6 Methods)

Microsoft Excel offers multiple ways to add dashes to social security numbers (SSNs), including using formulas or the Format Cells dialog box. In ...

How to Use VBA for Each Row in a Range in Excel

In this article, we will demonstrate how to use Excel VBA to iterate through each row in a range effectively, where the rows contain either single or ...

How to Extract Text Between Two Commas in Excel: 4 Methods

Method 1 - SUBSTITUTE and MID Functions to Extract Text Between Two Commas Steps: Select cell C5 and write down the following formula for the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo