Excel Formulas

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

### Top 20 Advanced Essential Excel Skills You Need to Know

Whether you’re just starting out on your Excel journey or have been using it for a while, there are a few skills that you should know about Excel: ...

If you want to be a power user of MS Excel, you must master the most useful Excel formulas of Excel. To be frank, it is not an easy task for all as ...

### Excel Conditional Formatting Formula

In this tutorial Excel Conditional Formatting Formulas, you will learn how to use Excel formulas to format cells conditionally. In this tutorial, ...

### LARGE function in Excel

LARGE Function: Overview The LARGE function in Microsoft Excel returns the nth largest value from a data range. LARGE function: Syntax  LARGE ...

### AND Function in MS Excel

AND Function: Overview The Microsoft Excel AND function returns TRUE if all logic is TRUE. It returns FALSE if any of the logic is FALSE. AND ...

### SUMPRODUCT() function in Excel

SUMPRODUCT function: Syntax  SUMPRODUCT (array1, , , ...) SUMPRODUCT function: Example Example: =SUMPRODUCT(A2:B4, C2:D4). This example says ...

### How to Reference PivotTable Data in Excel Formulas with GETPIVOTDATA?

In this article, I have shown you how you can reference PivotTable Cell Data in Excel formulas using GETPIVOTDATA function. If you feel uneasy with ... 