Data Analysis with Excel Archives - Page 2 of 4

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

Apr 7, 2021 Advanced Excel

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

Apr 7, 2021 Data Analysis with Excel

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)!

Jun 7, 2021 Data Analysis with Excel

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

Sep 12, 2021 Data Analysis with Excel 2

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]

Apr 6, 2021 Data Analysis with Excel

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]

Sep 9, 2021 Data Analysis with Excel 3

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!

Apr 6, 2021 Data Analysis with 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

Jun 7, 2021 Data Analysis with Excel 1

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

Sep 7, 2021 Advanced Excel

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

Sep 9, 2021 Data Analysis with Excel 1

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

Sep 7, 2021 Data Analysis with Excel

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

Sep 7, 2021 Data Analysis with Excel

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

Sep 7, 2021 Data Analysis with Excel 4

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

Sep 9, 2021 Data Analysis with Excel 1

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

Sep 9, 2021 Data Analysis with Excel

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