Latest Blog Posts

How to Calculate the Discount Price in Excel – 4 Methods

This is the sample dataset. Method 1- Using a Mathematical Formula to Calculate the Discount Price Steps: Select E5. Enter the ...

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

Method 1 - Calculate Z Score Using Conventional Formula Step 1: Calculate Mean of Dataset Select cell G4. Enter the following formula ...

2 Quick Ways to Convert Inches to Meters in Excel

When working on project plans, it is often necessary to convert measurements of length between different unit systems. Fortunately, Microsoft Excel ...

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

We'll use a dataset consisting of 4 columns: Product, Listed Price, Discount 1, and Discount 2. We will change this dataset throughout our methods. ...

How to Calculate Tiered Commission in Excel (3 Methods)

Introduction to Tiered Commission Sales representatives are motivated by commission rate tiers in a tiered commission system. Unlike flat ...

How to Calculate the Price Increase in Percentage in Excel – 3 Methods

  The sample dataset showcases 4 products, their old and new prices. To determine the percentage increase: Method 1 - Calculate ...

How to Calculate Selling Price from Cost and Margin in Excel

Let's consider a simple example where we have the cost of obtaining some products and want to calculate the selling price based on the required ...

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

  Watch Video – Create a Data Log in Excel What Is a Data Log in Excel? The Data Log is a form for gathering data ...

How to Calculate Discount Factor in Excel (6 Common Ways)

For economics and business purposes, it is very frequently needed to calculate the time value of money. The discount factor is one of the most ...

How to Calculate Total Sales in Excel – 3 Easy Steps

Step 1- Create a List of Products in Excel Create a new worksheet and enter the product list, the product code and its price. Select ...

How to Create a Skewed Bell Curve in Excel (With Easy Steps)

For illustration, we will use the following dataset to create a bell curve to compare the results. Step 1 - Generate a Summary Statistics ...

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

We have the following dataset containing some workers' names and dates of Birth (DOB). We will show some step-by-step methods to calculate their age ...

How to Use Ageing Formula in Excel Excluding Weekends (4 Methods)

Dataset Overview In Microsoft Excel, we often need to determine the age or duration of various items. Additionally, there are cases where we want to ...

How to Calculate Price Per Pound in Excel (3 Easy Ways)

We have the amounts of some products, their prices, and their amounts in lbs. We will calculate the price per pound (lb). Method 1 - ...

How to Refresh Excel Sheet Automatically (3 Suitable Methods)

Method 1 - Apply a Keyboard Shortcut to Refresh a Sheet Automatically We have a dataset of some random numbers in a workbook. We have applied ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo