ExcelDemy.com Blog

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

0

COUNTIF formula in Excel

COUNTIF formula syntax: COUNTIF (range, criteria) Range is the range of cells from where you want to find your values. Criteria can be expressed in many ways. It can be number, expression, cell reference,...

0

Importing a text file in Microsoft Excel

Sometimes you may want that you will place a text file into a specific range of your worksheet. You will at first think that you have to import the text file in a new...

0

Supported file formats by Excel

Excel 2013 is backward compatible. Backward compatible means that when a new version of Excel comes in the market, this new version is compatible with the old version Excel files. Excel 2013 supports XLSX,...