Excel Formulas Archives - Page 122 of 124

How to Use the Excel DAYS Function with a Practical Example

Jun 22, 2022 Excel Formulas 2

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, ...

How to Use Wildcards in Excel?

Jul 3, 2022 Advanced Excel

In this article, we shall see how to use wildcards in Excel. Wildcard characters such as the asterisk "*", question mark "?" and the tilde "~" can ...

How to calculate Average, Median, & Mode in Excel

Jun 16, 2022 Data Analysis with Excel

The average of a set of numbers is referred to as the arithmetic mean and it is calculated by adding all the numbers in the data set and then ...

How to Find Unique Values in Excel & Detect Duplicates

Jun 5, 2021 Advanced Excel

In this article, we are going to analyze how to find unique values in Excel. Duplication of values in Excel can occur in a single column or across ...

How to Find Correlation between Two Variables in Excel

May 25, 2022 Data Analysis with Excel

Correlation is a statistical measure that indicates, whether there is a relationship between two variables. Correlation measures the strength of the ...

Text to Columns in Excel (Split Column, Text, Date, …)

Jun 7, 2021 Advanced Excel

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you some useful uses of Text to Columns in ...

Excel If Function with Multiple Conditions (Nested IF)

Jun 5, 2022 Excel Formulas 8

We have already seen, how to use the IF function in basic Excel formulas. Using the IF with other functions together, in a complex formula, allows ...

Excel Dynamic Named Range [4 Ways]

Jun 5, 2022 Advanced Excel

Excel Dynamic Named Range is one of the Excel features that not so many Excel users know about. This article will make Dynamic Named Ranges closer to ...

What is the Order & Precedence of Operations in Excel?

Mar 3, 2022 Excel Basics 3

Understanding the order and precedence of operations in mathematical formulas or in an Excel Formula is very important. Excel has total of 17 ...

Separate, Split & Remove Substring & Number from Text with Excel Functions & VBA

Jun 7, 2021 Excel Formulas 2

Excel provides many functions that can be used to manipulate strings. These functions are very useful especially when you have to clean data. ...

Top Excel Functions and Features for Management Consultants

Jul 26, 2022 Advanced Excel 1

Microsoft products are truly amazing tools for management consultants who need to do data analysis and make a presentation before clients. And ...

Using FORMAT & TEXT Functions in Excel (68 Easy Examples)

Jun 29, 2022 Excel Formulas 7

In this article, you will learn how to use the Excel format function and text function with 68 examples. These examples will clear your idea about ...

Excel Array Formula Basic 2 – Breakdown of Array Formula

Jun 7, 2021 Excel Formulas 9

If you’re a regular follower of my blog, you know that I have started writing a series of articles on Excel Array Formula. In the first article, I ...

Excel Array Formula Basic – What is an Array in Excel?

Mar 3, 2022 Excel Formulas

Today, I will talk about the basics of Excel Array Formulas. Most Excel users find it one of the hardest topics to understand in Excel. There are ...

Use of Offset Function in Excel [Offset – Match Combo, Dynamic Range]

Apr 6, 2021 Advanced Excel

Today I’d like to introduce you to Excel's OFFSET Function with 3 real-life examples. At first, I will describe the formula syntax and then I'm ...