Latest Blog Posts

Ranking Based on Multiple Criteria in Excel (4 Cases)

The sample dataset contains student scores in Math and Psychology as well as each student's group. We'll rank the students according to the scores. ...

How to Stack Rank Employees in Excel (3 Methods)

We’ll use the following dataset, which contains four columns for employee attendance. How to Stack Rank Employees in Excel: 3 Easy Ways ...

How to Filter Multiple Values in One Cell in Excel (4 Methods)

The sample worksheet contains information about several sales representatives of Armani Group. The name of the Products and the Revenue Earned by the ...

How to Generate Random Numbers in a Range with Excel VBA

Here's a quick overview of the code that assigns random numbers. Sub Random_Numbers_with_Rnd() Bottom = 11 Top = 20 Random_Number = ...

How to Calculate Weight Loss Percentage in Excel (5 Methods)

Suppose we have the dataset below of weight measurements taken every 15 days for 4 months, and we want to calculate the weight loss percentage for ...

Random Selection Based on Criteria in Excel: 3 Methods

Method 1 - Random Selection Based on Criteria Using INDEX Function Steps: Type the following formula in cell G8. ...

How to Enter within a Cell in Excel: 5 Methods

The following Employee List table shows ID No, Name, and City columns. Using this table, we will show you how to enter within the cell. ...

How to Add a New Line with the CONCATENATE Formula in Excel – 5 Methods

This is the sample dataset.   Method 1 - Using the CONCATENATE Formula to Add a New Line The Combined column was added to the ...

How to Replace a Line Break with Comma in Excel (3 ways)

We have a dataset of 5 strings. In these strings, the fruit’s name, its quantity, the delivery location, and the delivery state of these fruits are ...

How to Find Duplicates in Excel and Copy to Another Sheet (5 Methods)

Suppose you have the following dataset. Method 1 - Use an Excel Formula to Get Duplicates and Copy to Different Sheet Steps: Add a ...

How to Merge Excel File to Mailing Labels (With Easy Steps)

In this tutorial, we will explain how to merge an excel file into mailing labels. Labeling is necessary for a variety of reasons, including marketing ...

How to Display Day of Week from Date in Excel (8 Ways)

Here's a simple dataset of some dates that we'll convert into days of the week. Method 1 - Using the TEXT Function to Display the Day of ...

Using the INDEX-MATCH Formula to Return Multiple Values Horizontally – 2 Steps

Introduction to Excel INDEX Function Objective: Returns a value of reference of the cell where a specific row intersects with a specified ...

How to Highlight Partial Text in Excel Cell (9 Methods)

Suppose you have the following dataset. Method 1 - Using the SEARCH Function to Highlight Partial Text in Excel Cell Steps: Select ...

Print Titles in Excel Is Disabled, How to Enable It?

We will use the dataset below to demonstrate why Print Title doesn’t work in certain cases and how we can resolve the issue.  Reason 1 - ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo