Excel Formulas

How to Calculate Bonus in Excel (5 Handy Methods)

Here we’ve got a dataset of the Daily Sales List of Sales Reps and their Daily Sales. Also, have a Sales Hurdle of $15,000 and a Bonus Percentage of ...

Excel Formula to Add Margin to Cost (4 Suitable Examples)

If you are looking for some special tricks to add margin to cost using the Excel formula, you've come to the right place. There are numerous ways to ...

How to Calculate Distance Between Two GPS Coordinates in Excel

To showcase the methods, the sample will use a simple dataset that lists the Latitude and Longitude values of Prague, Czech Republic, and Salzburg, ...

Excel Formula to Calculate Sliding Scale Commission (5 Suitable Examples)

In this article, we are going to show you 5 quick methods to create an Excel formula to calculate sliding scale commission. What Is Sliding ...

How to Insert Static Date in Excel (4 Simple Methods)

People store their necessary information in Excel. Business sectors, multinational companies, and educational institutions tend to keep employees' ...

How to Calculate Contribution Margin in Excel (2 Suitable Examples)

The Contribution Margin is the difference between the revenue and total variable cost. Contribution Margin or CM is a significant feature to measure ...

How to Calculate Price Per Square Meter in Excel (3 Handy Methods)

Want to calculate price per square meter in Excel? Well, you have come to the right place. Here, we will walk you through 3 easy and handy methods to ...

How to Convert Lbs to Kg in Excel (3 Easy Methods)

Excel is used all over the world to organize data and perform financial analysis. It works better than a calculator and it's easy to use. While ...

How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel

Unit conversion is a common operation that we conduct daily. Most of the time, converting one dimension to another appears to be a challenging ...

How to Calculate Peak Area in Excel (2 Effective Methods)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

How to Calculate Range in Excel (5 Handy Methods)

Range in statistics is the difference between the highest value and lowest value of a set of data. We need to apply range in the real work fields a ...

How to Calculate Age in Excel from ID Number (4 Quick Methods)

Let’s consider the following dataset (in B4:C14) with people's Names and their ID Numbers. The first 6 digits in ID Numbers represent the date of ...

How to Calculate Selling Price in Excel (4 Easy Methods)

Arithmetic Formula to Calculate Selling Price Before calculating a selling price in Excel, it's important to know the appropriate formulas. If we ...

How to Calculate Portfolio Variance in Excel (3 Smart Approaches)

In terms of doing business, we face the necessity to measure all kinds of risks. It is also needed to take into consideration how the aggregate of ...

How to Use Ageing Formula for 30 60 90 Days in Excel (5 Effective Ways)

Looking for Excel ageing formula 30 60 90 days? Well, you have come to the right place. Here, we will demonstrate to you 5 methods for Excel ageing ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo