Excel Formulas

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

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

Practice Excel Indirect Function with 3 Case Studies

Today I want to talk about one of the most important Excel functions - INDIRECT function. Before doing that, I need to give you a brief ...

Excel Advanced Filter [Multiple Columns & Criteria, Using Formula & with Wildcards]

I was performing keyword analysis for one of my new projects using SemRush.com, a competitive analysis tool. Actually, I was checking for how many ...

Separating Numbers from a Text – [A Formula Challenge for You]!

At Udemy, I run several courses on Excel and Data Analysis. In one of my free courses (Excel Formulas and Functions with Excel Formulas Cheat Sheet), ...

Running Average: How to Calculate Using Excel’s Average(…) Function

In this post, you will learn how to calculate the running average of a data set using Excel's Average(...) function. A business generates a huge ...

How to Make FOR LOOP in Excel Using Formulas?

Don't you want to use Excel VBA and want to make a FOR LOOP in Excel using Formulas? In this article, I've shown how you can make one using ...

ExcelDemy
Logo