Latest Blog Posts

How to Make Age Pyramid in Excel (2 Suitable Methods)

The age pyramid, an especially useful tool for population statistics, helps to analyze the population with respect to age. In Microsoft Excel, we can ...

How to Calculate Probability in Excel (3 Practical Examples)

Sometimes, you need to calculate probability with your database. You can calculate this probability using Excel. In this article, I will show how to ...

How to Calculate Lag Time in Excel (2 Methods)

What Is Lag Time? Lag Time or Time Lag is a delay between two successive tasks, whereas the later task should start as soon as the earlier task ...

How to Calculate the GPF Interest in Excel – Easy Steps

What Is GPF Interest? Government or non-government personnel can use the General Provident Fund (GPF) as an excellent savings tool. This is ...

How to Create Three Column Cash Book in Excel

What Is a Three-Column Cash Book? A three-column cash book is a table with Debit and Credit on each side and each side has three columns. The first ...

How to Find Marginal Probability in Excel (2 Simple Ways)

While working in Microsoft Excel, you may want to calculate the marginal probability distribution of a dataset. Manually performing these ...

How to Create Interim Payment Certificate Format in Excel

  Step 1 - Create the Basic Outline Steps: Give a suitable heading in the B2:G2 range. We’ve put Interim Payment Certificate. In the ...

How to Change International Number Format in Excel (4 Examples)

Example 1 - Converting European Number Format to US Number Format   Steps: Select the Cell C5 and enter the following formula. ...

How to Subtract 10 Percent in Excel (3 Easy Ways)

Subtracting percentages is a very common affair in our day-to-day life. Especially when we need to calculate any price without a discount, we need to ...

How to Perform Floating Rate Bond Valuation in Excel (2 Cases)

In this article, we will learn to perform floating rate bond valuation in Excel. The floating rate bond pays coupons that vary over their maturity. ...

How to Apply Weighted Probability in Excel: 3 Useful Methods

Method 1 - Combining MATCH and RAND Functions to Apply Weighted Probability in Excel Steps: Create a new Cumulative column. On cell ...

How to Add Border to a Chart in Excel (3 Useful Methods)

If you are looking for how to add border to a chart in Excel, then you are in the right place. We frequently have to create charts in Excel for ...

How to Apply Rows Per Sample ANOVA in Excel (2 Easy Methods)

ANOVA or Analysis of Variance, is an amalgamation of multiple statistical models to find the differences in means within or between groups. Users can ...

How to Format Double Column Cash Book in Excel

Looking for a way to format a double column cash book in Excel? Then, this is the right place for you. Here, you will find a step-by-step different ...

How to Create Training Attendance Sheet in Excel: 3 Methods

Method 1 - Prepare Outline To create a trainee attendance, we need to create a template or structure for the attendance. We created the below ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo