Data Analysis with Excel Archives - Page 3 of 4

How to Do Scenario Analysis in Excel (with Scenario Summary Report)

Sep 9, 2021 Data Analysis with Excel 10

How to do scenario analysis in Excel? How to generate/create a scenario summary report using the Excel scenario manager feature? You will learn all ...

How to Create a Two Variable Data Table in Excel

Sep 9, 2021 Data Analysis with Excel 2

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. In this article, we're going to create a ...

How to create a one variable data table in Excel

Sep 8, 2021 Data Analysis with Excel 2

In this article, I am going to explain how to create a one-variable data table in Excel. Data tables are important parts of the Excel What-If ...

Performing manual what-if analysis in Excel

Sep 7, 2021 Data Analysis with Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. A manual what-if analysis doesn’t require too much ...

Types of What-If analysis in Excel

Mar 31, 2021 Data Analysis with Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. Excel can handle much-sophisticated models than the ...

A What-If example in Excel

Jul 9, 2018 Data Analysis with Excel 6

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. You can create dynamic models in Excel. This is one of ...

How to Make a Frequency Distribution Table & Graph in Excel?

Sep 8, 2021 Data Analysis with Excel 2

You can make a histogram or frequency distribution table in Excel in a good number of ways. I have summarized total 7 methods in this article. In ...

Exporting Data in Excel

Sep 8, 2021 Advanced Excel

We shall discuss in this section about exporting data in Excel. You can convert your Excel workbook in different formats like CSV, txt, PRN, and many ...

Data clean-up techniques in Excel

Jun 7, 2021 Advanced Excel

Cleaning-up data in Excel covers many areas. We have covered almost every angle. Here are the links: Data clean-up techniques in Excel: Removing ...

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

Sep 8, 2021 Advanced Excel

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

Data clean-up techniques in Excel: Adding text to cells

Sep 8, 2021 Advanced Excel

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 on this topic, you have ...

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

Sep 8, 2021 Advanced Excel

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 in Excel: Filling blank cells

Sep 28, 2021 Advanced Excel

Sometimes you will end up with a worksheet that will look something like the one shown in the following Figure. Filling Blank Cells in Excel. ...

Data clean-up techniques in Excel: Changing vertical data to horizontal data

Sep 8, 2021 Advanced Excel

Sometimes after importing a file in your Excel file, the following type of data layout may generate. See the following image. Vertical data. We ...

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

Jun 7, 2021 Advanced Excel

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