Latest Blog Posts

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 - ...

How to Extract Text after Second Comma in Excel?

Method 1 - Extract Text after the Second Comma with MID and FIND Functions We have a dataset containing Teams and Top players. Our main goal is to ...

Generate Random Number between Two Numbers in Excel (4 Ways)

In this article, we will learn to generate a random number in Excel between two numbers. In Excel, there are different built-in functions that can ...

How to Highlight Duplicates in Multiple Columns in Excel (4 Ways)

Let's consider a dataset of 10 employees of a company. The point scale of this company is in column B. Their performance results for 2 months, ...

How to Make a Percentage Bar Graph in Excel -5 Methods

.This sample dataset contains 3 columns: Quarter, Brand, and Share, regarding the global shipment of smartphones in the last quarter of 2021. ...

How to Freeze Random Selection in Excel

Often you need to generate random numbers or strings for specific purposes, especially in the case of statistical sampling. However, you have to ...

Excel VBA: Combined If and Or (3 Examples)

While working with VBA in Excel, we often have to use combined If and Or to carry on a task when at least one among multiple conditions is satisfied. ...

How to Round a Multiplication Formula in Excel (5 Easy Methods)

We’ll use the following dataset that represents some clothing Prices and Discounts. Method 1 - Use the ROUND Function to Round a ...

How to Calculate Percentage of Month in Excel (4 Easy Ways)

Assume you have a set of dates in a spreadsheet and want to know what percentage of the year or month has passed or remains based on the given date. ...

Using the INDEX MATCH Function with Multiple Criteria and a Wildcard in Excel – 2 Easy Steps

  The Excel file contains information about several sales representatives. This is an overview. Step 1- Create a Drop Down List to ...

How to Select a Random Sample in Excel (4 Methods)

Method 1: Using the Data Analysis Toolbar to Select Random Sample Steps: Go to the Data tab in the ribbon and select the Data Analysis tool. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo