Data Analysis with Excel

Types of What-If analysis in Excel

Excel can handle much-sophisticated models than the preceding example. To perform a what-if analysis using Excel, you have three basic options: ...

How to Make a Frequency Distribution Table in Excel (6 Ways)

While working in Excel, we often need to make a distribution table. You can make a frequency distribution table in Excel in a good number of ways. ...

How to Export Data in Excel (2 Easy Ways)

Many times, while working in Microsoft Excel, users need to move data from an Excel file to another arrangement. That’s when the users need to know ...

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

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo