How to Create a Macro

In this article, we are going to learn how to create a Macro which will work after clicking on a command button. As we all know that Visual Basic Editor …

Visual Basic Editor

In this article, we are going to learn Visual Basic Editor. VBE is a separate application which works flawlessly in Excel. VBA procedure develops in the VBE. To see the …

LEN Function in Excel

The Excel LEN is an in-built function hence frequently used in day to day life. The function is really simple and easy to use. It belongs to Text family which …

COUNTBLANK Function in Excel

There are many features that makes Microsoft Excel so user friendly and robust. Some of them are its in-built functions that gives flexibility to users to play with spreadsheet. The …

COUNTA Function in Excel

There are several COUNT functions in Microsoft Excel to count the cells that contains specific type of data in the given range or list of arguments.The COUNTA function counts all …

COUNT Function in Excel

COUNT function counts the number of cells that contains numbers in a given range or within the list of arguments.UsesThere are many in-built functions in Microsoft Excel and COUNT is …

SUM Function in Excel

As the name suggests, SUM function in Excel is used to sum-up all the numbers supplied in the arguments or in the range of cells. It is one of the …