Data Analysis with Excel

How DAX Works. DAX Data Types & Operator. Check & Handle Error.

Last time, I made an introduction on how to import data into PowerPivot, create PivotTable/PivotChart using PowerPivot. In that article, I also ...

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

Forecasting in Excel Using FORECAST Function & Auto Fill Handle Tool

This article is aimed to show you two forecasting methods that you can use to forecast in Excel. If you own or operate a business, this is a ...

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

ExcelDemy
Logo