What Does Edate Formula Do?
This function is used to calculate a date which is a specific number of months in the past or in the future.

Syntax
=EDATE(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can be formatted…

What Does EOMONTH function Do?
This function will show the last day of the month which is a specified number of months before or after a given date.

Syntax
=EOMONTH(StartDate,Months)

Formatting
The result will normally be expressed as a number, this can…

What Does Exact function Do?
This function compares two items of text and determine whether they are exactly the same.
The case of the characters is taken into account, only words which are spelt the same and which have upper and lower case characters in…

What Does Fact Function Do ?
This function calculates the factorial of a number.
The factorial is calculated as 1*2*3*4..etc.
The factorial of 5 is calculated as 1*2*3*4*5, which results in 120.
Decimal fractions of the number are ignored.

Syntax
=FACT(Number)…

What Does fixed function Do ?
This function converts a numeric value to text.
During the conversion the value can be rounded to a specific number of decimal places, and commas can be inserted at the 1,000's.

Syntax
=FIXED(NumberToConvert,DecimalPlaces,Commas)…

What Does fixed function Do ?
This function converts a numeric value to text.
During the conversion the value can be rounded to a specific number of decimal places, and commas can be inserted at the 1,000's.

Syntax
=FIXED(NumberToConvert,DecimalPlaces,Commas)…

What Does floor function Do ?
This function rounds a value down to the nearest multiple specified by the user.

Syntax
=FLOOR(NumberToRound,SignificantValue)

Formatting
No special formatting is needed.

Support our work by doing the following :
1. Like…

What Does forecast function Do ?
This function uses two sets of values to predict a single value.
The predicted value is based on the relationship between the two original sets of values.
If the values are sales figures for months 1 to 6, (Jan to Jun), you…

What Frequency function It Do ?
This function compares a range of data against a list of intervals.
The result shows how many items in the range of data fall between the intervals.
The function is entered in the cells as an array, that is why it is enclosed…

What Does GCD function Do ?
This function calculates the largest number which can be used to divided all the values specified.
The result is always a whole number.
Where there is no common divisor the value of 1 is used.
Decimal fractions are ignored.

Syntax…

What Does GCD function Do ?
This function calculates the largest number which can be used to divided all the values specified.
The result is always a whole number.
Where there is no common divisor the value of 1 is used.
Decimal fractions are ignored.

Syntax…

What Does GESTEP function Do ?
This function test a number to see if it is greater than or equal to another number.
If the number is greater than or equal, the result of 1 will be shown, otherwise 0 is shown.

Syntax
=GESTEP(NumberToTest,NumberToTestAgainst)…

What Does Hour Function Do?
The function will show the hour of the day based upon a time or a number.

Syntax
=HOUR(Number)

Formatting
The result will be shown as a normal number between 0 and 23.

Support our work by doing the following :
1. Like the…

How to use Autofill in Excel

Support our work by doing the following :
1. Like the videos.
2. Comment on the videos giving suggestions for other videos.
3. Share the Videos Uploaded on this YouTube Channel with your friends and Family.
4. Facebook : …

What Does IF function Do?
This function tests a condition.
If the condition is met it is considered to be TRUE.
If the condition is not met it is considered as FALSE.
Depending upon the result, one of two actions will be carried out.

Syntax
=IF(Condition…

What Does Index Formula Do ?
This function picks a value from a range of data by looking down a specified number of rows and then across a specified number of columns.
It can be used with a single block of data, or non-continuous blocks.

Syntax
There are…

What Does Indirect Function Do ?
This function converts a plain piece of text which looks like a cell address into a usable cell reference.
The address can be either on the same worksheet or on a different worksheet.

Syntax
=INDIRECT(Text)

Formatting
No…

In this tutorial, we will learn How to Multiple sheets into One sheet in Excel

Support our work by doing the following :
1. Like the videos.
2. Comment on the videos giving suggestions for other videos.
3. Share the Videos Uploaded on this YouTube Channel…

In this tutorial, we will learn How to Multiple sheets into One sheet in Excel

Support our work by doing the following :
1. Like the videos.
2. Comment on the videos giving suggestions for other videos.
3. Share the Videos Uploaded on this YouTube Channel…

Excel Formula Tab in Hindi - How To Use Name Manager And Define Name in EXCEL | In Hindi

Support our work by doing the following :
1. Like the videos.
2. Comment on the videos giving suggestions for other videos.
3. Share the Videos Uploaded on this YouTube…