Excel Formulas

### How to Use the Excel DAYS Function with a Practical Example

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?

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

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

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

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, …)

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)

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]

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?

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

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

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)

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

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?

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]

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