Excel Formulas

How to Calculate Sales Growth over 3 Years in Excel (2 Methods)

Sales growth over various periods is one of the key performance indicators for most companies. In this article, we will demonstrate how to calculate ...

How to Calculate Range for Grouped Data in Excel (3 Effective Methods)

While working with Microsoft Excel, sometimes we make a range of grouped data. In actual life, the majority of the data we deal with is organized ...

Excel Formula to Count Specific Words in a Cell (3 Examples)

A word can be present in a cell multiple times. There are multiple options to find and count that specific word from a cell in Excel including the ...

How to Use Nested IF Function in Excel: 7 Methods

Method 1 - Use Nested IF Function to Find Multiple Results Based on Criteria If a student gets 70 or higher, then he will pass. If he gets ...

How to Calculate Log Base 2 in Excel (2 Methods)

  Method 1 - Use Excel LOG Function The LOG function computes the logarithm of a number to a particular base. In order to use the LOG ...

Excel Match Wildcard in Lookup Array (with 3 Formulas)

This article illustrates how to use Excel formulas to match a wildcard in a lookup array. The three wildcards used in Excel are the question mark ...

How to Remove Asterisk in Excel (5 Simple Methods)

Suppose we have a dataset of a fruit shop containing columns for Product, Product Code, & Total Sales. We will remove the asterisk sign from the ...

How to Calculate Discount Rate for NPV in Excel (3 Useful Methods)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. In ...

How to Find T Critical Value in Excel?

While working with Microsoft Excel, sometimes, we have to calculate the T critical value. Calculating the T critical value in Excel is an easy task. ...

How to Calculate Bonus Percentage in Excel: 4 Methods

Method 1 - Applying Direct Arithmetic Formula to Find Ratio Apply an arithmetic formula to calculate the Bonus Percentage. Find out the Ratio in ...

How to Calculate Production Cost in Excel (3 Effective Ways)

The production cost is the total cost of manufacturing items or providing services, including all intended and unintended expenses. It can be ...

Bonus Calculation as per Bonus Act in Excel (3 Suitable Examples)

In this article we will demonstrate several methods to calculate employee Bonuses in accordance with the USA's Bonus Act in Excel. Overview of ...

How to Calculate Cut and Fill Volume in Excel (3 Steps)

Step 1 - Formatting Data in Excel to Calculate Cut and Fill Volume To make the data more understandable, we’ll format it appropriately. ...

How to Filter Last 30 Days of Date in Excel (5 Easy Ways)

Suppose we have the following dataset containing dates along with other entries, and we want to filter the dataset to only show entries from the last ...

Nested Formula with AVERAGE and ROUND Functions in Excel

To perform multiple tasks at once, we often use a nested formula in Excel. The nested formula saves time and cells in Excel. In this article, we’ll ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo