Excel Formulas

How to Convert Date to Julian Date in Excel (3 Easy Ways)

Usually, users have to perform many tasks in Excel, which includes mentioning dates. These dates can be days, months, or years of a particular time. ...

How to Calculate Percentage of Percentage in Excel (2 Examples)

To analyze statistical data in Excel, many times we have to calculate a percentage of a percentage to get our intended information from bulk data. In ...

How to Calculate Population Proportion in Excel (with Easy Steps)

In this article, we will see how to calculate the population proportion in Excel. To calculate population proportion, we firstly require sample ...

How to Concatenate Arrays in Excel (With 2 Conditions)

While working in Excel, we sometimes need to combine texts located in several rows and columns. In this case, the processes to concatenate these ...

CONCATENATE vs CONCAT in Excel (2 Ideal Examples)

While working with Excel, you need to use various functions depending on your purpose or criteria. Two such functions are the CONCATENATE function ...

Man Hours Calculation in Excel (6 Useful Methods)

Method 1 - Using Subtraction If we know the starting time and the finishing time, we can calculate hours by using subtraction. Case 1.1. Time ...

Linear Regression Confidence Interval in Excel (Calculation and Interpretation)

Linear Regression is a prevalent statistical method for regression analysis. Statisticians use it to create a linear relationship between a dependent ...

TDS Deduction on Salary Calculation in Excel Format

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this ...

How to Concatenate Names in Excel (10 Practical Examples)

In this article, I am going to show you 10 practical examples of how to concatenate names in Excel. You can quickly use these methods even in large ...

How to Use SUMIFS Function with Multiple Sheets in Excel

The SUMIFS function of Excel is widely used when we want to sum data if criteria are matched. We may want to sum the data from multiple sheets also. ...

Consolidation of Financial Statements in Excel (2 Easy Examples)

In this article, you will learn about two quick examples of how to prepare a consolidation of financial statements in Excel. We will be using the ...

How to Concatenate Cells but Keep Text Formatting in Excel (3 Effective Ways)

In Excel, you can join the texts by using the CONCATENATE function. But, the problem arises when you need to keep the same text format after using ...

How to Concatenate and Keep Number Format in Excel

The CONCATENATE is a function that usually joins the values of multiple cells and shows that in a single cell. But, when we apply this function, all ...

How to Calculate Probability Density Function in Excel

The Probability Density Function is a well-known statistical parameter. It shows the probability of a continuous random variable having a value in a ...

How to Calculate Attendance Percentage in Excel (with Steps)

A fundamental duty in data calculation is computing percentages. We must understand what percentage of the work has been completed. For instance, to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo