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 ...

Excel VBA: Wait Until a Process Completes

VBA provides us with a built-in method called Wait. We’ll use this method to wait until the process completes. The problem is the method Wait takes a ...

Automatically Update a Pivot Table When Source Data Changes in Excel

We've included a data set with information on sales details in various regions in the image below. We need an automated process to update data in a ...

How to Insert Sign in Excel Formula (Arithmetic, Logical and Misc.)

Excel keeps track of data and calculates to manipulate this data. In calculations, Excel uses various formulas and these formulas include different ...

How to Count Words in Excel Column (5 Useful Ways)

Let’s consider a dataset with 2 columns, where the first column shows the Product ID and the second column shows a list of Best Seller Books. We’ll ...

How to Calculate Cost per Unit in Excel (With Easy Steps)

What Is Cost per Unit? The cost per unit includes all costs associated with production, delivery, marketing, sales, warehousing, management, etc. ...

How to Use IF Formula for Aging Buckets in Excel (3 Suitable Examples)

  Method 1 - Aging Buckets for Overdue Days We are going to use the following dataset. It consists of different reports with the dates issued ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo