## 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. This article will show you those functions and ...

## 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 Microsoft Excel is no doubt one the most important tools ...

## 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 have demonstrated what are arrays in Excel and how ...

## 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 several articles online already on this topic. ...

## 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 going to talk about how the OFFSET function can be ...

## 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. Beauty in chaos kind of. I'd understand someone ...

## 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), Luis, one of the students in the course, asked me ...

## 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 functions: OFFSET(), MAX() and MIN()! If you know ...