Latest Blog Posts

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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo