ExcelDemy.com Blog

2

VLOOKUP Function in Excel: Learn with Examples

VLOOKUP Function: Overview VLOOKUP function is used to search in a list/ database with a value reference. See the following image. VLOOKUP Function: Syntax VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) VLOOKUP Function: Example In above...

0

Data clean-up techniques in Excel: Classifying values

This article requires that you know Data clean-up techniques in Excel: Transforming Data with Formulas Sometimes it may be necessary that you will classify the values into a group. For example, if you have...

0

Data clean-up techniques in Excel: Converting values

This article requires that you know Data clean-up techniques in Excel: Transforming Data with Formulas Sometimes you may need to convert values from one metric system to another metric system. For example, you may...

0

Splitting Text in Excel Using Flash Fill

The Text to Columns Wizard works very well for many types of data. But some data can’t be split by this wizard. For example, you can’t split data if it is not fixed width...

0

How to use Flash Fill in Excel 2013

Flash Fill is one of most important features newly added in Excel 2013. Flash Fill technique can recognize pattern in a text and you can separate part of a text in a new column...

0

Using Text to Columns to split text in Excel

The Text to Columns command can split the text into their component parts. Download Working Files At first download the working file that I have used to create this Excel tutorial. If you click...

0

How to split text into multiple cells in Excel

When you import data from another sources, it may happen that multiple values has been imported into a single column. Following image shows an example of this type of import incident. Tip: Your default...