How to Make a Price List in Excel (Step by Step Guidelines)

Step 1 - Making an Outline of the Price List Template We'll start with the following dataset that contains various product details, including ...

How to Remove Comments in Excel (7 Methods)

Dataset Overview We have a dataset containing student details (Name, ID, Scores). In Cell B8 and C12, there are two notes. Additionally, in Cell D7 ...

How to Highlight Cell Using the If Statement in Excel (7 Ways)

Let’s say we have the following dataset: Sales Representative's Name, their Sales Area, and the Number of Units Sold in each month of the first ...

Shortcuts to Insert New Row in Excel (6 Quick Methods)

Rows run horizontally along the worksheet. In Excel rows are denoted by numerical values like 1,2,3,4 etc. In this tutorial we will see 6 methods to ...

How to Sort an IP Address in Excel – 6 Methods

Excel treats an IP address as text. This is an overview: This is the sample dataset. Method 1 - Sort the IP Address Using an ...

How to Use VBA Str Function in Excel (4 Examples)

In Excel, we can use various functions to work quickly, and also we utilize VBA to do the work fast. In Excel VBA, there are so many functions that ...

How to Link Cells in Excel (7 Ways)

Why Do We Need to Link Cells in Excel? When you create a link between cells or external cell references in a sheet, it helps us maintain the same ...

The Hyperlink in Excel is Not Working -3 Solutions

The sample dataset contains Hyperlinks. Solution 1 - The Pound (#) Sign is Not Accepted in Hyperlinks If the link contains the Pound (#) ...

How to Insert a Clustered Column Chart in Excel – 4 Methods

Method 1 - Create a Clustered Column Chart for Region-Wise Quarterly Sales data This is the sample dataset. Step 1: Inserting a ...

How to solve If Excel Sort Is Not Working (2 Solutions)

Solution 1: Delete the Same Sheet's Reference from the Formula If 'Sort' is Not Working Problem: In the following dataset, we calculated the ...

How to Add Sort Button in Excel (7 Methods)

We have an Excel file that contains information about the employees of a company. The worksheet has the Name, Age, Gender, Date of Birth, States they ...

Hyperlink in Excel VBA: Properties and Applications

While working with VBA in Excel, we often have to deal with the hyperlink. In this article, I’ll show you can work with the hyperlink in Excel. ...

How to Link Sheets in Excel with a Formula – 4 Methods

The following dataset showcases Salesman, Product, and Net Sales of a company. Method 1 - Creating a Link Formula in Excel to Link Sheets 1.1 ...

How to Use VBA While Wend Statement in Excel (4 Examples)

The While…Wend Statement is a logical function in Excel VBA. The statement is used to create a While loop. When you are uncertain about the necessity ...

How to Use VBA RTrim Function (5 Suitable Examples)

The VBA RTrim function is a built-in String or Text function in Excel. The RTrim function is only applicable in VBA macros. We can’t use the RTrim ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo