Data Analysis with Excel

Data clean-up techniques in Excel: Extracting a filename from a URL

Sometimes you may have a list of URLs and you need to extract only the file name. In the following way, you can extract the file name from a URL. ...

Data Clean-up Techniques in Excel: Randomizing the Rows

Sometimes you may need to randomize the rows in a column. Say you are a teacher of a school, you have some naughty students who try to copy papers of ...

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

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

How to split text into multiple cells in Excel

When you import data from another source, it may happen that multiple values have been imported into a single column. The following image shows an ...

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

Importing Data in Excel

If you want to do anything with data, you must at first get that data into your worksheet. Excel can import data from a text file and can also ...

ExcelDemy
Logo