Data Analysis with Excel

### One and Two Variables Sensitivity Analysis in Excel (2 Examples)

The article shows how to perform one and two-variable sensitivity analysis in Excel. Sensitivity analysis studies how different sources of ...

### Stock Return Frequency Distributions and Histograms in Excel

Creating Histogram Using Stock Returns Data The following sample dataset will be used for illustration. Stock Return Frequency ...

### How to Do Forecasting on Excel (4 Easy Ways)

This article aims to show you four methods you can use to forecast in Excel. If you own or operate a business, this is a common scenario where you ...

### How to Calculate Running Average in Excel (3 Ideal Examples)

In this post, you will learn how to calculate the running average of a data set. A business generates a considerable amount of data every year. Most ...

### How to Make Histogram Using Analysis ToolPak (with Easy Steps)

In this article, we will demonstrate how to make a histogram using the Analysis Toolpak. What is a Histogram in Excel? A histogram is a ...

### How to Use the Goal Seek Analysis in Excel (Examples, Advantages, and Disadvantages)

What Is Goal Seek in Excel? Goal Seek is a built-in tool in Excel that performs What-If Analysis. It helps you find the specific input value needed ...

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

Before analyzing how to use scenario manager in Excel to do scenario analysis, it's important to understand the limitations of one and two variable ...

### How to Create a Two Variable Data Table in Excel – 3 Examples

The following image showcases a setup of a two-variable data table. The setup of a two-variable data table.     Example 1 - ...

### How to Create One Variable Data Table in Excel (2 Examples)

What Is a One Way/Variable Data Table? In a one-variable data table, a single cell is the input in the data table. The following figure shows the ...

### 19 Practical Data Cleaning Techniques in Excel

Method 1 - Remove Duplicate Rows Here's a sample dataset that contains duplicate rows. Let’s replicate the column and remove the ...

### 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: 7 Simple Methods

Method 1 - Use Find and Replace Feature to Get Filename from Path Steps: Select cells (B5:B11) from the worksheet with paths. Selecting ...

### How to Randomize Rows in Excel (2 Easy Ways)

Method 1 - Randomizing Rows in Excel with Multiple Columns We have a dataset of some sales representatives of an organization, their net sales, ...

### How to Import a Text File into Excel (5 Methods)

Differences Between Text File and Excel File File Format: Excel files are binary files with a structured format, while text files are ...

Advanced Excel Exercises with Solutions PDF