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…

Excel Shortcut: Ctrl + Enter in Excel | Excel Shortcut keys

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…

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 : https://www.facebook.com/ManzilInstit...…

How to check error in excel | how to evaluate formula in excel | Excel Tips | Excel Formulas

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…

How to insert header and footer in Excel | Excel Tips | Chaudhary Computers Rajpura

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…

How to insert objects in Excel | Excel Tips | Chaudhary Computers Rajpura

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…

How to Make Excel File Password Protected | How to protect excel file | Excel Tips

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…