Latest Blog Posts

How to Divide and Multiply in One Excel Formula: 4 Methods

Method 1 - Using Traditional Division and Multiplication Formula Steps Select the cell D5 and enter the following formula: =(B5/C5)*B5 ...

How to Update Hyperlink in Excel Automatically (2 Ways)

We have a dataset containing brief information about some books, their writers, and hyperlinks where you can find these books to read. We will use ...

How to Format a Phone Number with Extension in Excel – 3 Methods

The image below showcases phone numbers with extensions before and after formatting: Method 1 - Using a Custom Number Format Each phone ...

How to Make a Comma Separated List in Excel (5 Methods)

We have an Excel file that contains information about various types of fruits. These fruits are listed in the column titled Fruit in that Excel ...

How to Open a Hyperlink in the Google Chrome Browser using VBA Code in Excel (3 Methods)

Overview of the Shell Function The Shell function is used to run an executable program using its file location from inside a VBA code. This function ...

How to Find and Replace Hyperlinks in Excel (3 Quick Methods)

After setting hyperlinks in Excel you can easily edit them or find and replace them using some features of Excel. This article will provide you with ...

How to Multiply Multiple Cells in Excel – 4 Methods

The sample dataset showcases product quantity and unit price. Method 1 - Using the Asterisk Sign to Multiply Multiple Cells in Excel ...

How to Combine Duplicate Rows in Excel without Losing Data (6 Methods)

To demonstrate our methods to combine duplicate rows without losing data, we’ll use the following dataset: Method 1 - Merging UNIQUE, IF ...

How to Do Matrix Multiplication in Excel (5 Examples)

Method 1 - Performing Matrix Multiplication of Two Arrays in Excel Let’s take two individual matrices A and B. In Excel, we will treat them as ...

How to Merge Rows with Commas in Excel (4 Methods)

Dataset Overview To explain the methods, we will use a dataset that contains information about the Department and the Age of some employees of a ...

How to Merge an Excel File into a Word Document – 2 Examples

Example 1 - Merge a Single Page in an Excel File into a Word Document The sample dataset showcases a sales report: Sales Rep, Product ID and ...

How to Make Multiplication Table in Excel (4 Methods)

If you are looking for some special tricks to make a multiplication table in Excel, you've come to the right place. There are numerous ways to make a ...

Excel VBA: Add Hyperlink to Cell in Another Sheet (2 Examples)

In this article, we'll demonstrate how to add a hyperlink to a cell in another sheet using VBA in Excel. Excel VBA: Add Hyperlink to Cell in ...

How to Make Gridlines Darker in Excel (2 Easy Ways)

In this tutorial, we will show you how you can make gridlines darker in Excel. When we open a workbook Microsoft Excel automatically adds gridlines ...

Excel VBA to Find Duplicate Values in Range: 7 Examples

Method 1 - Use VBA For Loop to Identify Duplicate Values in a Range Step 1: Go to the Sheet Name section at the bottom border of each cell. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo