Data Analysis with Excel

What If Analysis in Excel – A Step by Step Complete Guide

I am the president of my apartment (don't think my age is huge (I'm mid-age) or I am over talented :) ). A little apartment of total of 14 flats. If ...

Goal Seek in Excel 2013 – How to Use Guide

In this tutorial, you will learn single-cell goal seek in Excel 2013. I have used a "mortgage loan" example to demonstrate the whole process. Goal ...

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

ExcelDemy
Logo