Data Analysis with Excel

19 Practical Data Cleaning Techniques in Excel

With data entry and organization, Microsoft Excel can also perform beginner to intermediate-level data analysis easily nowadays. For our everyday ...

Data clean-up techniques in Excel: Fixing trailing minus signs

Sometimes it may happen that your imported data will show as the following screenshot: Some data have minus signs at the end, trailing minus ...

How to Add Text to Cell in Excel (6 Easy Methods)

Sometimes you may need to add text to a cell, one solution is to use a new column and use formulas. To gain a clear grasp of this topic, you have to ...

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

Data Clean-Up Techniques: Fill Blank Cells in Excel (4 Ways)

Sometimes we keep some blank cells to understand that they will be the first filled ones, have a look at our dataset to understand it. But sometimes ...

How to Change Vertical Column to Horizontal in Excel

In this article, we will learn to change a vertical column to a horizontal row in Excel. Microsoft Excel is a powerful tool and it helps users to ...

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 (6 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, 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 (4 Easy Ways)

It is very important to import text files to Excel when you deal with a lot of data. There are various procedures to import text files to Excel. In ...

Importing Data into Excel (3 Suitable Ways)

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

ExcelDemy
Logo