To calculate the average without using AVAERAGE function, we can sum all numeric values and divides by the count of numeric values. We can use… Read More

# Category Archives: Excel

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

Excel is a great tool to use in data collection and entry and nowadays it is widely used worldwide. To make the tasks of data… Read More