Latest Blog Posts

How to Create Projected Balance Sheet Format for 3 Years in Excel

What Is a Projected Balance Sheet? A projected balance sheet, also called a pro forma balance sheet, contains all the financial information (such as ...

How to Calculate Semi Variance in Excel – 3 Simple Methods

Semi Variance evaluates the variation among the observations in a sample. Semi-variance deals  with the observations that are below the average of ...

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

How to Copy Chart in Excel Without Linking Data (with Easy Steps)

We have a dataset of some students with marks of a specific subject and the probability distribution value according to the mark. After creating the ...

How to Compare 3 Sets of Data in an Excel Chart – 5 Examples

This is the sample dataset. Example 1 - Using a Clustered Column Chart Steps: Select B4:E13. Go to the Insert tab ➤ Insert Column ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo