Latest Posts

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

Practice Excel Indirect Function with 3 Case Studies

Today I want to talk about one of the most important Excel functions - INDIRECT function. Before doing that, I need to give you a brief ...

How to Make a Control Chart with Excel VBA!

In this article, I will show you How to Make a Control Chart with Excel VBA. Control charts are widely used to monitor process stability and control. ...

Excel Charts with Dynamic Title and Legend Labels

Dynamism is everywhere! Then why not with Excel? Creating dynamic charts in Excel is possible in many ways. What I am going to cover in this ...

How different is VBA from other programming languages?

THE EXCEL CONTRAPTION A beginner's journey into the world of Excel is always filled with many “OMG it can do that too ?!? Amazing!”. For what all ...

Reverse Pivot Tables – Unpivot Summary Data

Excel pivot tables are beautiful! Then why do you need to reverse your pivot tables or pivoted data? Because data generated by businesses are ...

How to Use INDEX Function in Excel (8 Examples)

The INDEX Function is one of the top used 10 Excel functions. In this tutorial, you will get a complete idea of how the INDEX function works in Excel ...

Excel Advanced Filter [Multiple Columns & Criteria, Using Formula & with Wildcards]

I was performing keyword analysis for one of my new projects using SemRush.com, a competitive analysis tool. Actually, I was checking for how many ...

Separating Numbers from a Text – [A Formula Challenge for You]!

At Udemy, I run several courses on Excel and Data Analysis. In one of my free courses (Excel Formulas and Functions with Excel Formulas Cheat Sheet), ...

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

How to insert Equation in Excel using Equation Editor (Easy Guide)

If you do mathematics related report or assignment with Excel, you have to know how to use the Equation Editor. In this tutorial, we shall ...

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

ExcelDemy
Logo