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

102 Useful Excel Formulas Cheat Sheet PDF (Free Download Sheet)

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

ExcelDemy
Logo