Latest Posts

How to copy formula in Excel

While you are working with Excel, you will have to copy formulas frequently from one cell to another cell. Here is how you will do this: Select ...

Data clean-up techniques in Excel: Matching text in a list

You may have some data and you want to check this data against another available list. Download this file to work with us in the following ...

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 use Flash Fill in Excel 2013

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

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

Finding out the number of duplicate rows using COUNTIF formula

Say you have a column with duplicate rows. You just want to find out which rows are duplicate and how many times they are duplicated. You can find ...

How to Find, Highlight & Remove Duplicates in Excel

Sometimes you may want that you will observe which rows are duplicates in the spreadsheet. Then you can manually delete those rows. It is easy to ...

How to Find & Remove Duplicate Rows in Excel

One very common use of Excel is: it is used as a tool to clean up data. Cleaning up data means: Getting raw data into a worksheet ...

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

Understanding contextual tabs in Excel Ribbon

When you will work with charts or shapes or these kinds of objects then special types of tabs will appear in Excel Ribbon Tab zone. These contextual ...

Creating and Copying formula using relative references in Excel

In our following example, we want to calculate Menu Cost(see the heading in the example) multiplying every menu's price and quantity. We shall not ...

ExcelDemy
Logo