Latest Blog Posts

How to Reset Comment Position in Excel (With Easy Steps)

Sometimes while working on Excel, we insert too many comments and notes, and often their position needs to change so that they don’t hide the ...

How to Convert Numbers to Barcode in Excel (3 Easy Ways)

We will use the sample dataset below to illustrate how to convert numbers to Barcode in Excel. Method 1 - Converting Numbers to Barcode ...

How to Apply Alignment in Excel Conditional Formatting

To demonstrate alignment using conditional formatting, we have a sample data table like the image below. Method 1 - Apply Right and Left ...

How to Change Width of Column in Excel Chart (with Easy Steps)

Step 1 - Prepare Data Set with Additional Information We have the following sample dataset where we have the sales data of a general store for ...

How to Copy Chart Without Source Data and Retain Formatting in Excel: 2 Simple Methods

Method 1 - Using Paste Special Option Step 01: Create Chart for 1st Term Select the dataset and go to the Insert tab from Ribbon. Choose the ...

How to Change Default Comment Font Size in Excel

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. This article ...

How to Calculate Lead Time in Excel (2 Examples)

What Is Lead Time? Lead time refers to the duration between the start of a process and its completion. Specifically, it represents the time required ...

How to Create a Budget with Irregular Income in Excel

We may have irregular income, which means that your take-home pay fluctuates from one pay period to another pay period. Our income won't likely be as ...

How to Create a Comparison Column Chart in Excel

In this tutorial, I am going to show you step-by-step procedures to create a comparison column chart in Excel. You can use these steps even in large ...

[Fixed!] Excel Comment Only Showing Arrow

Have you ever faced a situation where only an arrow appears instead of the comment and you are not sure how to fix it? Then, this article can help ...

How to Calculate Current Age in Excel (2 Easy Ways)

Method 1 - Nesting YEARFRAC and TODAY Functions to Calculate Current Age In Microsoft Excel, you can get your current age by nesting the YEARFRAC ...

How to Calculate the ROI Percentage in Excel – 6 Methods

  The sample dataset contains two columns with Investment Details. Method 1 - Using a Generic Formula to Calculate the ROI ...

Compare Two Tables with the Power Query in Excel – 2 Examples

There's a dataset showcasing students' IDs and names, and another one containing the Passed Students' Records in Term 1 and Term 2. To ...

[Solved]: Filter by Color Not Working in Excel (7 Quick Fixes)

To demonstrate the solutions, we have a sample dataset of employee salaries. In the dataset, three cells with values below $3500 are filled yellow. ...

How to Calculate On-Time Delivery Performance in Excel: A 3-Step Procedure

Let’s say your dataset contains arrival times, both actual and estimated, for ten stores, and you would like to calculate your delivery performance. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo