Latest Blog Posts

How to Return Value of Cell and Not of Formula in Excel (3 Methods)

Dataset Overview: We have a dataset with 5 columns: Product, Pound, Kilogram, Unit, and Total. The data is given in pounds, and we want ...

How to Calculate Commission in Excel Using VLOOKUP

A commission is money earned from a sale. Companies often pay out a proportion of total sales income. It’s actually a payment made to an agent or ...

How to Find Z Critical Value in Excel?

in this article, we’ll demonstrate 3 different examples of finding the Z Critical Value in Excel. The Z Critical Value plays a significant role in a ...

How to Enable Iterative Calculation in Excel (with Easy Steps)

If you want to enable iterative calculation in Excel, you have come to the right place. Here, we will walk you through 2 easy and quick steps to do ...

How to Calculate the Retirement Age in Excel – 4 Quick Methods

The dataset showcases Names, Date of Birth, and Date of Retirement. Method 1 - Using the DATEDIF Function to Calculate the Retirement Age ...

How to Find Chi-Square Critical Value in Excel?

This tutorial will illustrate how to find Chi-Square critical values in Excel. Suppose we will perform a Chi-Square test. As a result, we will get a ...

How to Calculate Time Range in Excel (4 Methods)

Below is an Employee Time Sheet dataset containing the "In Time" and "Out Time" of 10 employees for a certain day. Method 1 - Calculating ...

How to Count Specific Names in Excel (3 Useful Methods)

Let’s say we have a dataset that depicts the employee ID, the Year, and the Sales Person of the Year. We’ll use the dataset (in B4:D14 cells) shown ...

How to Calculate P Value from Z Score in Excel: 4 Methods

Method 1 - Calculate Mean of Dataset Select cell C13. Insert the following formula into the cell. =AVERAGE(C5:C11) Press ...

How to Remove Scroll Bar in Excel (3 Easy Ways)

Microsoft Excel, by default, displays a horizontal and vertical scroll bar. It allows us to go through the spreadsheet and scroll over the ...

How to Calculate Accuracy and Precision in Excel

The proximity of experimental values to the true value is known as accuracy. Suppose we have a PRODUCT dataset (B4:E9) with forecasted demand in ...

How to Group Age Range in Excel with VLOOKUP (with Quick Steps)

Suppose you have a dataset of 9 persons of different ages and want to put them inside particular age groups. Step 1 - Create a List of Age Ranges ...

How to Calculate Hours and Minutes in Excel (7 Handy Ways)

We have a dataset of an employee’s entry time and exit time to the office throughout the week. We need to calculate how much time they worked each ...

How to Add Individual Error Bars in Excel – 3 Steps

What Are Error Bars in Excel? Error bars in charts can help you see the ranges of errors and standard deviations. In two-dimensional area, ...

How to Convert Inches to Cm in Excel (2 Quick Ways)

We have a dataset of measurements of a box in 3 dimensions. We will convert them from inches to centimeters. Method 1 - Multiply by the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo