# Category: Functions

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

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

## TEXT and FORMAT Functions in Excel [68 Examples]

Sometimes, we need to format or manipulate data the way what we want. Here is what we generally do. If you right click on the worksheet, the context menus will be prompted. By clicking...

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

## 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 introduction on dollar sign (\$) in Excel formula....

## Index Function Excel [Examples, Make Dynamic Range, INDEX MATCH]

Do you know INDEX function is one of the top used 10 Excel functions? In this tutorial, you will get a complete idea how INDEX function works in Excel individually and with other Excel functions....

## ASC Function(VBA) in Excel

ASC(VBA) Function: Overview The Microsoft Excel ASC(VBA) function returns the ASCII value of a character or the first character in a string passed as arguments. ASC(VBA) function: Syntax   Asc( string ) ASC(VBA) function:...

## MsgBox Function in Excel VBA

The MsgBox function The VBA MsgBox function is an easy way to display information and to take simple input (like Yes, No, Cancel) from the users. MsgBox function: Syntax A simplified version of the...