Latest Blog Posts

Salary Deduction Formula in Excel for Late Coming – 5 Steps

  Step 1 - Create a Dataset and a Layout Template Create 3 columns to input dates, joining time, and leaving time. Add two columns to ...

How to Add Arrow in Excel Graph (with Easy Steps)

You might discover that, whether your worksheet includes a column chart or a line chart, you need to include arrows in the column chart to ...

How to Change the Chart Color Based on a Value in Excel – 2 Methods

This is an overview of the sample dataset. Method 1 - Using the Vary Colors by Point Option in Excel Steps: Select the range in the ...

How to Calculate Billable Hours in Excel (4 Effective Ways)

In this tutorial, we will demonstrate 4 effective ways to calculate billable hours in Excel. We'll use the following dataset to explain the steps. ...

How to Calculate Derivative from Data Points in Excel

A derivative is a common tool to calculate any rate of change of any value. You can calculate derivatives by using Excel. In this article, I will ...

How to Create an Injection Molding Cycle Time Calculator in Excel: 5 Methods

Method 1 - Input the Required Values Click on cells as shown below and insert the required value from your production particulars at the Sample ...

How to Calculate Absenteeism Percentage in Excel: 2 Easy Methods

Method 1 - Calculating Individual Person-Based Absenteeism Percentage Steps: Insert the following absenteeism formula into Cell F5- =E5/C5 ...

How to Find the Variance of a Probability Distribution in Excel

The index of a dataset's variability, known as variance, shows how far apart the various values are from one another. In this article, we are going ...

How to Change the Chart Style to Style 8 (2 Easy Methods)

Microsoft Excel is a great tool to create charts as it offers many predefined layouts and styles. We can even create our own customized style. In ...

Poisson Probability Distribution in Excel (4 Practical Examples)

The Poisson probability distribution is one of the most essential key factors in statistics to measure and visualize the probability of a particular ...

How to Use Continuous Probability Distribution in Excel

Suppose the car tires of a certain company lasted for a mean of 40,000 km and had a standard deviation of 2,500 km. If you buy one tire from this ...

How to Use Excel Formula to Choose Between Two Values

  Method 1 - Select Between Two Values Using Formula with the CHOOSE Function We will use the dataset below that contains the Participants ...

How to create a Petty Cash Payment Voucher Format in Excel – 5 Steps

  This is an overview.   Step 1- Create Headers with the Company Name Merge & Center B2:F2 to create a header ...

How to Create Real Estate Balance Sheet in Excel (2 Easy Ways)

In this article, we will learn to create a real estate balance sheet in Excel. A real estate balance sheet is a financial report that reflects the ...

How to Calculate Hours from Date and Time in Excel (6 Easy Methods)

Method 1 - Subtract One Time from Another to Calculate Hours in Excel Select the cell range B5:C7. Go to Number Format of the Home tab ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo