Advanced Excel

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

ExcelDemy
Logo