Create Post-Judgment Interest Calculator in Excel (With 2 Cases)

It is said that time is equally valued as money. This saying is profoundly true in the case of lending money or borrowing it. Especially, things get ...

Border Not Showing in Excel – 6 Solutions

This is the sample dataset. Solution 1 - Changing Line Color In the following dataset some cells have no borders because the Borders line ...

How to Add Thick Box Border in Excel (3 Quick Ways)

The following image shows data on the left without a border and on the right with a thick box border, including student names and departments. ...

How to Align Right in Excel (5 Simple Methods)

Here are five different ways to align cells to the right in Excel: Method 1 - Using the Home Ribbon The most common way to right-align the ...

How to Change Comma to Dot in Excel (4 Methods)

Method 1 - Using Notepad to Replace Commas with Dots Sample Dataset Overview Imagine a dataset representing a company’s sales records. The ...

How to Calculate the SLA Percentage in Excel – 2 Quick Steps

What Is SLA and SLA Percentage? SLA stands for service level agreement. It expresses the level of service quality the customer expects from the ...

How to Calculate the Cumulative Probability in Excel – 4 Steps

Introduction to the Cumulative Probability The cumulative probability is the likelihood that the value of a random variable is within a specific ...

How to Calculate Median Age of Population in Excel (2 Ways)

  What Is the Median? The median is the middle value of a data array that is arranged in an ascending or descending order. For example, the ...

How to Create a Budget vs an Actual Chart in Excel – 2 Methods

 Budget vs Actual Chart A budget vs actual chart is used to determine the difference or variance between the forecast and actual value. The ...

How to Create a Cash Book in Excel (With Easy Steps)

Step 1 - Create Title for Cash Book Create a title for the cash book. In the following sample, we have used the Merge&Center command for ...

How to Calculate Percentage of Filled Cells in Excel (7 Easy Ways)

The sample dataset contains a Project Checklist with a list of Duties and a Status column. We will calculate the percentage of filled cells with the ...

How to Do Sum of Percentages in Excel (2 Easy Ways)

To demonstrate our methods, we'll use the following dataset: Method 1 - Using a Generic Formula We add a new row to calculate the total ...

How to Calculate Percentage for Multiple Rows in Excel

We will use the following sample data set. We have the marks of four subjects for the final exam of five random people. Method 1 - Use the ...

How to Create Bubble Chart for Categorical Data in Excel (6 Steps)

The article will demonstrate how to create an Excel Bubble Chart for categorical data. A Bubble Chart is useful when working with two or more ...

How to Put Negative Percentage Inside Brackets in Excel: 4 Effective Ways

Method 1 - Using 0 Symbols Steps: Select the cells from E6 to E8. Go to the Home tab and click on the arrow beside the Number section, as in ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo