Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

## 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 14 flats. If you never maintained a building, you don't know how ...

## 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 Seek feature is one way to do Reverse What If ...

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

How to do scenario analysis in Excel? How to generate scenario summary report using Excel scenario manager feature? You will learn all these crucial data analysis topics in this article. So, let's ...

## 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 Excel What-If Analysis feature to perform the sensitivity analysis of a ...

## 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 explanation. In fact, the example we have used in the ...

## 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 preceding example. To perform a what-if analysis ...

## 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 the most appealing aspects of Excel. A dynamic ...

## 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 addition, I have created an Excel Template to ...

## 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 more. Converting Excel workbook to text format ...

## 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 duplicate rows How to Find, Highlight & ...

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

Sometimes it may happen that your imported data will show like the following screenshot: Some data have minus signs at the end, trailing minus signs. Excel does not convert these values ...

## 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 to know about these three functions: LEFT, RIGHT, ...