Latest Blog Posts

Convert Formula to Value Without Paste Special in Excel (5 Easy Methods)

Excel has an inbuilt data display orientation to indicate entries such as Numbers or Text. On occasions, we need to convert formulas to values ...

How to Calculate a Distance in Excel Using Google Maps

  Method 1 – Using a User-Defined Function Here, we’ll find the distance between the cities of Las Vegas and Philadelphia using Google Maps. ...

How to Calculate Coordinates from Bearing and Distance in Excel

What Are Coordinates (Northing and Easting)? The geographic Cartesian Coordinates of a point on earth are referred to as Easting (the x value), and ...

Types of Data Entry in Excel (A Quick Overview)

Microsoft Excel is one of the leading data organizing and analyzing programs. But to analyze data in Excel, you need to input data first. Data can be ...

How to Calculate Coupon Rate in Excel (3 Ideal Examples)

What Is a Coupon Rate? The coupon rate is the rate of interest that is paid on the bond’s face value by the issuer. The coupon rate is calculated by ...

How to Create a Map in Excel (2 Easy Methods)

    Method 1 - Utilizing a Filled Map Chart to Create a Map in Excel Example 1 - Creating a Map of Countries Here's a dataset of ...

How to Calculate Distance Between Two Addresses in Excel (3 Ways)

Here is an overview of how the distance between two addresses can be found in Excel. How to Calculate the Distance Between Two Addresses ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo