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 (4 Easy Methods)

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 Find Mean, Median, and Mode on Excel (4 Easy Ways)

Finding a means to determine the "typical" value is something you might frequently do while evaluating numerical data. You can use the so-called ...

How to Get Unique Values in Excel (5 Easy Ways)

If you are looking for how to get unique values in Excel, then you are in the right place. Duplication of values in Excel can occur in a single ...

Find Correlation Between Two Variables in Excel (3 Easy Ways)

Correlation and the correlation coefficient are often discussed in many financial sectors such as the stock market and investment portfolio analysis. ...

How to Convert Text to Columns in Excel (3 Cases)

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you how to convert text to columns in Excel. ...

How to Use IF Function with Multiple Conditions in Excel

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

What Is the Order of Operations in Excel (An Ultimate Guide)

Everything in this world run in order. In terms of working with Microsoft Excel, you also need to maintain the order of operations. Understanding the ...

How to Use Substring Functions in Excel (Types and Examples)

Usually, we need to work with substring functions in Excel. This is a guide that will let you how to separate, split, and remove substrings and ...

Top Excel Functions and Features for Management Consultants

For management consultants who must conduct data analysis and give presentations to clients, Microsoft products are truly incredible resources. And ...

How to Use Format Function in Excel (with Suitable Examples)

In Microsoft Excel, we need to format the values of any cells to get proper readability and a good outlook. Besides using the available built-in ...

5 Examples of Using Array Formula in Excel

If you are a regular user of Excel, you most likely know about the array formula in Excel. Also, you could be aware of this, array formulas lessen ...

What Is an Array in Excel? (5 Ideal Uses)

Today, I will talk about the basics of Excel Array Formulas. Most Excel users find it one of Excel's most challenging topics to understand. 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 ...

How to Find and Handle Circular Reference in Excel

So I know it is not just me. I mean it cannot simply be only me making that mistake so often. Frankly, it is even too complex a mistake to make. ...

Advanced Excel Exercises with Solutions PDF