Latest Blog Posts

How to Edit Cell in Excel with Keyboard (4 Handy Methods)

There are thousands of cells in an Excel sheet. Every time we need to edit those cells because there is data, values, formulas, and so on in a cell ...

How to Calculate Area in Excel Sheet: 2 Methods

Method 1 - Calculate the Area under a Scatter Plot in an Excel Sheet 1.1 Using Trapezoidal Rule Steps: Insert a scatter plot for the dataset. ...

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)

Method 1 - Calculate the Average Sales per Month with the AVERAGE Function The sample dataset contains the monthly sales for the last 3 years. We'll ...

How to Calculate Bond Price in Excel (4 Simple Ways)

The chart below shows basic bond particulars. We will look at how to calculate the bond price. Method 1 – Using Coupon Bond Price Formula ...

How to Create a Bell Curve with Mean and Standard Deviation in Excel

What Is a Bell Curve? The bell curve, also known as the normal distribution curve, illustrates the typical spread of a variable. It's a common ...

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

Method 1 - Using Conventional Formula We mentioned the cost of 6 months of 2021 in the range of cells D5:D10. We considered a projection of a 20% ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo