Excel Formulas

How to Calculate Area in Excel Sheet (Area under Curve & More)

It is a very common need for us to calculate the area of objects of different shapes. Besides, sometimes we need to calculate the area under graphs ...

How to Calculate Sales Commission Formula in Excel (3 Easy Ways)

Method 1 - Calculate the Sales Commission with a Simple Formula in Excel We will use a dataset that contains information about the sales amount of ...

How to Calculate Average Sales per Month in Excel (2 Easy Methods)

This article illustrates how to calculate average sales per month in Excel. You can easily calculate the average sales per month by dividing the ...

Create a Bell Curve with Mean and Standard Deviation in Excel

If you are looking for some special tricks to create a bell curve with mean and standard deviation in Excel, you've come to the right place. There is ...

How to Calculate Projected Cost in Excel (4 Effective Ways)

In our daily life, we need to project the expense and profit of any month or year for our company or living. Microsoft Excel has several functions ...

How to Calculate Discount Price in Excel (4 Quick Methods)

While calculating discount prices, the benefit of using Excel is- we can use it as a calculator too and it saves huge time for a large dataset if you ...

How to Calculate Z Score in Excel (2 Easy Methods)

In Statistics, the term Z-score is very popular. The Z-score denotes how far the data value is from the mean. As an Excel user, you will be glad to ...

How to Calculate Multiple Discounts in Excel (4 Easy Methods)

We can easily calculate a single discount for a product. However, things get really complicated when we try to find product prices after more than ...

How to Calculate Tiered Commission in Excel (3 Easy Methods)

While working with Microsoft Excel, sometimes we need to calculate tiered commissions. The tiered commission is given to the sales representatives so ...

How to Calculate Price Increase Percentage in Excel (3 Ways)

Many companies or business sectors keep their important information in an Excel workbook. They have to perform numerous operations according to their ...

How to Calculate Selling Price from Cost and Margin in Excel

This tutorial shows how to calculate selling price from cost and margin in Excel. A good selling price is very important to create a successful ...

How to Create a Data Log in Excel (2 Suitable Ways)

One of the common uses of Microsoft Excel is for data logs or entries for most of the root-level users. As Excel has limitless cells, the users don't ...

How to Calculate Total Sales in Excel (With Easy Steps)

In every business, calculating total sales is very common. It is very important to calculate total sales to calculate total revenue in business. Some ...

How to Calculate Age in Excel in Years and Months (5 Easy Ways)

Looking for ways to know how to calculate age in Excel in years and months? Then, this is the right place for you. Sometimes, calculate age from a ...

How to Use Ageing Formula in Excel Excluding Weekends

In Excel, we often need to calculate the age or duration of different products. We also need to know the time period excluding the weekends. If you ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo