# Author: Taryn N

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

## The Difference between Average, Median and Mode and How to Calculate Each in Excel

The average of a set of numbers is referred to as the arithmetic mean and it is calculated by adding all the numbers in the data set and then dividing by the count of...

## Detecting Duplication and Finding Unique Values in Excel – Pro Tips

Duplication of values in Excel, can occur in a single column or across multiple columns and rows in Excel. It is often necessary to eliminate duplication, for correct data analysis and data integration purposes....

## How to use Goal Seek to find an input value & produce a desired result

Goal seek is part of the What-If Analysis set of data analysis tools, in Excel. A user can evaluate the input value needed, to produce the desired output value using Goal Seek. What do...

## How to Find Correlation between Two Variables in Excel

Correlation is a statistical measure that indicates, whether there is a relationship between two variables. Correlation measures the strength of the relationship between two variables, as well as whether or not there is a...

## How to Use Excel Objects to Create an Art Portfolio?

Inserting Objects Inserting objects in Excel means that Excel actually stores these objects (PDF files, Word documents, or images in bitmap format in the actual spreadsheet itself). This can be useful, if you want...

## The Main Differences between a Bar Graph and a Histogram

This is a question that is often asked. What is the difference between a column chart and a histogram and when should one use a histogram versus a column chart. Both the column chart...

## How to Use Solver in Excel [Explained with a Real Life Example]

The solver tool is used to find an optimum value (either a maximum or minimum depending on the example) for a formula in one cell, by changing decision variables. In order to deliver a...

## How to Create Pivot Tables that Provide Meaningful Data Analysis & Insights

Pivot Tables allow you to summarize and organize data quickly and efficiently, in order to identify patterns, trends, and other key insights. One can quickly structure and re-structure the Pivot Table, by dragging and...

## How to Insert, Edit & Delete Calculated Fields From Excel Pivot Table!

When you are using Pivot Tables, you can use calculated fields as a way of making your own custom calculations. Pivot Table Reports already provide a set of summary calculations and function options, but...

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