Data Analysis with Excel

Data clean-up techniques in Excel: Replacing or removing text in cells

Solution 1: Using Find and Replace Dialog box. Sometimes it is necessary to replace or remove some characters from a column of data. For example, ...

How to Do Automated Data Cleaning in Excel (10 Easy Tips)

Looking for ways for automated data cleaning in Excel? Then, this is the right place for you. Sometimes, the data we get is not clean and ready for ...

How to Get Filename from Path in Excel (7 Simple Methods)

While working in Microsoft Excel sometimes we need to extract filename from a given path to work more effectively. This might seem difficult as the ...

How to Randomize Rows in Excel (2 Easy Ways)

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

Splitting Text in Excel (8 Useful Applications)

Working on different types of text is very common in Excel. But sometimes we need to split them for the need of better understanding. In this ...

How to Import Text File to Excel (5 Easy Ways)

Importing text files into Excel can be a powerful way to bring data from external sources into your Excel workbooks. This can include data from ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo