Excel Formulas

Difference Between COUNT and COUNTA Functions in Excel

In Excel, we can use a huge number of formulas to calculate anything easily and properly. There are some common functions like SUM, AVERAGE, etc. ...

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

In this article we will investigate some reasons why Excel's Text to Columns feature might not be working as expected, and suggest appropriate ...

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

How to Calculate Variance of Stock Returns in Excel (2 Easy Ways)

In general, variance is one of the most useful topics in statistics and is widely used to calculate stock returns in the stock market. Moreover, it ...

Percentage is Showing as Thousand in Excel – Reason and Solution

Why Is Excel Showing Wrong Percentages? The dataset showcases percentage values. Change the format of those cells into percentages. ...

Convert Number to Percentage Without Multiplying by 100 in Excel

  We will consider a simple dataset which contains profits for each month in decimal form. We need to convert that into percentile. ...

How to Subtract Time and Convert to Number in Excel?

We have a dataset of some Employee Names, Entry Time, and Exit Time. We will subtract time and convert it to a number to determine the Total Working ...

How to Calculate Joint Probability in Excel (3 Ideal Examples)

In mathematics, probability is the measure of the likelihood that an event will occur. However, the probability is quantified as a number between 0 ...

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 Commas in Excel – 7 Methods

Method 1 - Remove Inverted Commas in Excel Using a Multiplication Steps: Enter 1 in any random cell in the worksheet and copy the cell by ...

How to Concatenate Decimal Places in Excel (5 Examples)

Example 1 - Concatenate with Two Decimal Places Steps: Enter the following formula in cell D5. =CONCATENATE("The Unit price of the ...

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

The following image is an overview.    Step 1 - Create a Driver Salary Receipt Format in Excel The best way to specify a ...

[Fixed] Excel COUNTA Function Not Working

Reason 1 - COUNTA Function Is Not Working for Blanks Returned by Formulas We have used the IF function in the range D5:D12 to extract numbers ...

How to Convert a Decimal to a Whole Number in Excel (10 Methods)

Dataset Overview We'll use a dataset containing the information on the top 10 T20 batsmen based on average.  The dataset has columns for Rank, ...

How to Concatenate If Cell Values Match in Excel (7 Easy Ways)

To demonstrate our methods we'll use the following dataset, containing columns for State and Sales Person. We'll concatenate the values in the Sales ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo