# Category: Formulas

## Creating Email Addresses from a Single Column with Flash Fill, TEXT Formulas & Commentator’s Text Formula Suggestions

Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. We are going to see how to...

## How to Use the Database Functions in Excel

The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve database functions available in Excel namely: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX,...

## VLOOKUP versus INDEX and MATCH versus DGET

Microsoft Excel provides efficient functions that allow one to search for and lookup data. Of the lookup functions – VLOOKUP, INDEX and MATCH and the database function DGET are the most useful and most...

## 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, not to be confused with the DAY function, returns the...

## How to Use Wildcards in Excel?

Wildcard characters such as the asterisk “*”, question mark “?” and the tilde “~” can greatly extend searching, counting, and addition functionality in Excel.  Excel wildcards can be used with functions such as AVERAGEIF,...

## How to Use the IF & AND Functions to Test Multiple Conditions!

We have already seen, how to use the IF and AND functions separately in basic Excel formulas. Using the IF and AND functions together, in a complex formula, allows you to test multiple conditions...

## 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 text will make Dynamic Named Ranges closer to you. In the further lines, hints and...

## 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 17 operators that you can use them to build complex Excel formulas. Here...

## Separate, Split & Remove Substring & Number from Text with Excel Functions & VBA

[Editor’s Note: This is a guide on how to separate, split & remove substring & numbers from text using Excel Functions and VBA. Examples of substring functions are CHAR, FIND, LEFT, LOWER,  MID, PROPER, REPLACE, RIGHT,...

## Best Online Excel Training for Basic & Advanced Users with Certification

“Note: Are you a basic Excel user? Or an advanced level user? And searching for the best online Excel courses? And don’t want to spend the top dollars on the training? You’re at the...

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

## Breakdown of an Array Formula – Array Formula Basic Part 2

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

## What is an Array in Excel & how to work with it? Array Formulas Basic

Today, I will talk about the basics of 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. Then...

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

## How to Find and Handle Circular Reference in Excel

Beauty is Chaos 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....