Data Analysis with Excel

### How to Import Data into PowerPivot & Create Pivot Table/Pivot Chart

Pivot table is useful when we want to analyze or slice data to gain important insights. It is the main way to analyze data. But it also has ...

### Sparklines in Excel (Insert, Change, & Modify to Show Data Trends)!

It is well known that we can draw a chart easily in Excel. But is it possible to graphically summarize data in a single cell? The answer is ...

### Multiple Regression Analysis with Excel

Simple regression analysis is commonly used to estimate the relationship between two variables, for example, the relationship between crop yields and ...

### How to use Goal Seek in Excel 2016 [Solve 3 Problems]

If you know the result of a formula, but you are not sure which input value the formula needs to get that result, you can use the Goal Seek Command. ...

### How to Use Scenario Manager in Excel [with Examples]

I have introduced you to how to do sensitivity analysis using a data table in one of my previous posts – Sensitivity Analysis In Excel Using One or ...

### One and Two Ways (Variables) Sensitivity Analysis in Excel!

Sensitivity analysis studies how different sources of uncertainty can affect the final output in a mathematical model. Recently one of my friends ...

### Stock return analysis using histograms & 4 skewness of histograms

A histogram is a widely used way to summarize a large data set. Creating a histogram using Data Analysis ToolPak is very easy. This blog is aimed to ...

### Running Average: How to Calculate Using Excel’s Average(…) Function

In this post, you will learn how to calculate the running average of a data set using Excel's Average(...) function. A business generates a huge ...

### Use Scatter Chart in Excel to Find Relationships between Two Data Series

In this post, you will learn how to find out the relationships between two or more data series using Scatter Chart in Excel. You know, business ...

### How to Make a Histogram in Excel Using Data Analysis ToolPak

This is a step by step guide on how to make a histogram in Excel using Data Analysis ToolPak. Charts and graphs help you to summarize your data ...

### Data Analysis in Excel – Learn 10 Common Statistical Terms

Want to analyze business or any data in Excel? You have to master some common statistical ways. Excel is just a tool, how sharply you can use ...

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