These functions count the number of cells in a range that contains numerical values, or any values or if its equal to a some criteria

These functions count the number of cells in a range that contains numerical values, or any values or if its equal to a some criteria

These functions will convert a decimal number into an integer or another decimal number with desired decimal point

These two functions will return the a random number in Excel, RAND function will return a decimal random number between 0 to 1 and RANDBETWEEN will return an integer random number between two defined values

SUMIF and SUMIFS in Excel

These two functions will return the summation of values in the cells based on the one or more criteria

Here we talk about all different type of sum functions in Excel

WEEKDAY, WEEKNUM in Excel These functions will return the week number from the start of year and the day name of the week at specific date

These functions will return the number of days between two dates

Defining and declaring variables in VBA

Here we explain how we can get a data from Excel cell by using VBA

These functions will extract a hour , minute or second value from a time serial number in Excel as integer number