Excel Formulas

How to Replace Text between Two Characters in Excel (3 Easy Ways)

In this article, we will learn to replace text between two characters in Excel. Sometimes, we import datasets from other sources. Those datasets can ...

How to Calculate Weighted Average in Excel (3 Easy Methods)

This tutorial illustrates three easy methods to calculate the weighted average in Excel. While evaluating a simple average of a group of numbers, we ...

How to Calculate Significant Difference Between Two Means in Excel

The following picture highlights calculating the difference between means. What Is the Significant Difference and T-Test? Significant ...

Split Date and Time Column in Excel (7 Easy Methods)

Method 1 - Use the INT Function to Split Date and Time Steps: Add two new columns for date and time. Go to cell C4 and put the ...

Separate First and Last Name with Space Using Excel Formula (3 Ways)

We have a dataset of some full employee names. We will separate their first and last names in different columns. Method 1 - Combine LEN, ...

How to Replace Text with Carriage Return in Excel (4 Smooth Approaches)

For the fabrication of information, We can use Carriage Return. It means to return the beginning of the next line in the same cell. Here, We are ...

[Fixed!] Excel Rows Not Showing but Not Hidden (3 Reasons & Solutions)

Reason 1 - Unhidden Rows Are Not Visible Due to Insufficient Row Height in Excel Let’s assume we have a dataset containing several fruits and their ...

Assigning Weights to Variables in Excel (3 Useful Examples)

In many cases, the exams in a school, or products in a company carry equal weight or significance. In that case, the average is very easy to ...

How to Calculate Cross Correlation in Excel: 2 Suitable Ways

Method 1 - Calculate Cross Correlation Without Time Lag i. Using Excel CORREL Function The CORREL function returns the correlation coefficient ...

How to Split Text in Excel by Character: 5 Quick Methods

Method 1 - Split Text in Excel by Character with the Convert Text to Columns Wizard Select your data. Go to Data ➤ Data Tools ➤ Text to ...

Excel Calculates Difference Between Two Dates in Days: 7 Ways

Method 1 - Using DATEDIF Function to Find Difference Between Two Dates in Days Use the DATEDIF function to calculate the difference between two ...

How to Calculate Autocorrelation in Excel (2 Ways)

Here, we have the following dataset containing a company's sales records over different months. We will try to determine the autocorrelation for ...

Separate Decimal Numbers from Text in Excel (6 Quick Ways)

This article will show how to separate decimal numbers from text in Excel, like in the following image.   Method 1 - Using Text to ...

How to Calculate Time Difference in Numbers?

Sometimes we are in need to calculate time difference(s) in numbers for various purposes. In this article, we are going to discuss some easy ways of ...

How to Split Column in Excel by Comma (8 Quick Methods)

Method 1 - Split a Column in Excel by Commas with the Convert Text to Columns Wizard Select your data. Go to Data, then to Data Tools, and ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo