Excel Formulas

Dynamic Ranges with OFFSET and COUNTA Functions in Excel

Looking for ways to create dynamic range by applying OFFSET and COUNTA functions in Excel? Don’t worry! You have landed in the right place. In this ...

How to Concatenate with VLOOKUP in Excel (4 Easy ways)

  Consider the following dataset. We have the records of several people and will look up a value from the dataset using VLOOKUP and other ...

How to Apply Excel COUNTIF with Pivot Table Calculated Field

You have come to the right place if you are looking for the answer or some unique tips to use the COUNTIF function with pivot table calculated field ...

How to Count Words Separated by Comma in Excel Cell

Excel has lots of functions to perform different tasks. But sometimes one single function is not capable of solving a problem. That time we need to ...

Excel Text to Columns Not Working (4 Reasons with Solutions)

Excel's Text to Columns feature is quite helpful. Data that is contained in a single column may often be divided into many columns using this ...

How to Create Automatic Salary Slip Generator Using Excel

  Overview of a Salary Sheet and the Automatic Salary Slip In the following picture, you can see the overview of a Salary Sheet. Using ...

Percentage Showing as Thousand in Excel (Reason and Solution)

The percentage is the ratio of one number compared with the total presented in terms of 100. The use of percentages is very common in today's life. ...

Convert Number to Percentage Without Multiplying by 100 in Excel

The percentage is the fraction of two numbers multiplied by 100. Mathematically, we need to multiply a number by 100 to convert that into a ...

How to Subtract Time and Convert to Number in Excel?

While working in Microsoft Excel sometimes we need to subtract time and convert it to a number so that we can calculate the time difference. But it ...

How to Use SUBTOTAL COUNTA Function in  Excel: 5 Suitable Examples

Keep all the cells in General format. For all the datasets, we have 2 unique columns which are Items and Sales (units). We may vary the number of ...

How to Remove Inverted Comma in Excel (7 Easy Methods)

When we import data in Excel, we may often encounter some Inverted Comma in data that creates problems while calculating data because it may change ...

How to Concatenate Decimal Places in Excel (5 Examples)

Concatenation is one of the most common ways to join texts and numbers in Excel. This process can make the whole process of joining multiple texts ...

Create a Driver Salary Slip Format in Excel – 2 Easy Steps

The following image is an overview of a driver's salary slip format. What Is a Salary Pay Slip? Every month, an employee receives a paper ...

[Fixed] Excel COUNTA Function Not Working

The Excel's COUNTA function finds the number of cells in a given range that are not empty. This is very useful when you need to count the number of ...

How to Convert Decimal to Whole Number in Excel (10 Easy Ways)

In terms of working with Microsoft Excel, we need to work with numbers all the time. It is a common phenomenon that we might need the numbers in the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo