Category Archives: Excel

A waterfall chart is used to visualize data and understand the cumulative effect of sequentially introduced positive or negative values. For this article, we’ll see… Read More
To calculate the average without using AVERAGE function, we can sum all numeric values and divides by the count of numeric values. We can use… Read More
In this article, we will learn about the calculation of the variance(var) in Excel. First, let’s learn about Variance. In real-life scenarios, we have populations… Read More
COUNTIF function in excel is used to count the number of cells that match a single condition applied. It can include Dates, Numbers, and Texts.… Read More
In this article, we will learn about the calculation of the standard deviation(std) in Excel.  First, let’s learn about Standard Deviation. In real-life scenarios, we… Read More
GESTEP is a function in Microsoft Excel that is used to check whether the given number is greater than the given threshold value(given step value).… Read More
To run a macro automatically when the workbook opens one must enable the developer’s tools in Microsoft excel. Steps to enable the developer’s tool: Step… Read More
In this article, we’ll explore different ways of finding age in Excel, other than the usual way of finding age using DATEDIF function. For this… Read More
A Pie Chart is a circular statistical graphic, which is divided into slices to illustrate numerical proportion.In this article, we’ll see how we can create… Read More
A scatter plot is a mathematical diagram made using the Cartesian coordinates which are used to display typically 2D-data sets. These are also known as… Read More
Macros are a set or sequence of instructions that perform as and when required by the user. Initially, a macro is to be recorded. Then… Read More
A tolerance chart shows how a particular data item compares to the maximum and minimum permissible values. In this article, we’ll analyze the average results… Read More
When sharing your spreadsheet with other users, you don’t want them to modify some specific cells. These cells may contain key data, instructions, statistics, or… Read More
A Gantt diagram in Excel is used to represent projects or tasks in the form of cascading horizontal bar charts. It illustrates the project schedule… Read More
Definition: Related standard deviation is also known as the relative percentage standard deviation form, the deviation measurement which tells us how different numbers are dispersed… Read More