## How to Find and Handle Circular Reference in Excel

Beauty is Chaos So I know it is not just me. I mean it cannot simply be only me making that mistake so often. Frankly, it is even too complex a mistake to make....

## Sensitivity Analysis in Excel Using One or Two Variables Data Table

Sensitivity analysis studies how different sources of uncertainty can affect the final output in a mathematical model. Recently one of my friends borrowed money from a bank to buy a house. And I was...

## 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 introduction on dollar sign (\$) in Excel formula....

## Control charts in Excel: How you can make one using VBA

Control charts are widely used to monitor process stability and control. The process data are always plotted in order with three lines added: A central line for the average, An upper line for the...

## 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 article is how you can create Excel charts...

## How different is VBA from other programming languages?

THE EXCEL CONTRAPTION A beginners journey into the world of Excel is always filled with many “OMG it can do that too ?!? Amazing!”. For what all it can do , it never brags;...

## 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 business are not well structured and in ready-to-use format to make pivot...

## Index Function Excel [Examples, Make Dynamic Range, INDEX MATCH]

Do you know INDEX function is one of the top used 10 Excel functions? In this tutorial, you will get a complete idea how INDEX function works in Excel individually and with other Excel functions....

## 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 keywords a website was ranking in Google. Domain authority, website...

## 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), Luis, one of the students in the course,...

## 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. My this blog is aimed to show you how you can use...

## How to Insert an Equation in Excel Using Equation Editor

[Abstract: In this article, you will learn how to insert equations in Excel using Equation Editor with two examples.] If you do mathematics related report or assignment with Excel, you have to know how...

## 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 common scenario that you are worried...

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

In this post, you will learn how to calculate running average of a data set using Excel’s Average(…) function. A business generates huge amount of data every year. Most of the data are related...

## 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 data analysis has so many goals. One of...