Dollar Formula | Dollar Function | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
https://youtu.be/TwqN4iS_eJs
https://youtu.be/TwqN4iS_eJs
YouTube
Dollar Formula | Dollar Function | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
What Does Doller Function Do?
This function converts a number into a piece of text formatted as currency.
Syntax
=DOLLAR(Number,DecimalPlaces)
Number : This is the number which needs to be converted.
DecimalPlaces…
This function converts a number into a piece of text formatted as currency.
Syntax
=DOLLAR(Number,DecimalPlaces)
Number : This is the number which needs to be converted.
DecimalPlaces…
Edate function | Edateformula | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
https://youtu.be/5UMYx85qPFo
https://youtu.be/5UMYx85qPFo
YouTube
Edate function | Edateformula | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
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…
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…
Find Formula | Find Function in Excel | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
https://youtu.be/EnCMggMnflQ
https://youtu.be/EnCMggMnflQ
YouTube
Find Formula | Find Function in Excel | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
What Does Find Function Do?
This function looks for a specified letter inside another piece of text.
When the letter is found the position is shown as a number.
If the text contains more than one reference to the letter, the first occurrence is used.
An additional…
This function looks for a specified letter inside another piece of text.
When the letter is found the position is shown as a number.
If the text contains more than one reference to the letter, the first occurrence is used.
An additional…
Fixed Formula in Excel | Fixed Function in Excel | Excel Tips | Excel Formulas | Chaudhary Computers
https://youtu.be/CTKGvqObt8k
https://youtu.be/CTKGvqObt8k
YouTube
Fixed Formula in Excel | Fixed Function in Excel | Excel Tips | Excel Formulas | Chaudhary Computers
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)…
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)…
Fixed Formula in Excel | Fixed Function in Excel | Excel Tips | Excel Formulas | Chaudhary Computers
https://youtu.be/CTKGvqObt8k
https://youtu.be/CTKGvqObt8k
YouTube
Fixed Formula in Excel | Fixed Function in Excel | Excel Tips | Excel Formulas | Chaudhary Computers
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)…
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)…
Floor Formula | Floor Function | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
https://youtu.be/SbWm0hjGPfY
https://youtu.be/SbWm0hjGPfY
YouTube
Floor Formula | Floor Function | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
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…
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…
Frequency Function | Frequency Formula | Excel Tips | Excel Formulas | Chaudhary Computers Rajpura
https://youtu.be/uCe0QjAZ6dU
https://youtu.be/uCe0QjAZ6dU
YouTube
Frequency Function | Frequency Formula | Excel Tips | Excel Formulas | Chaudhary Computers Rajpura
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…
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…
GCD function | GCD formula | Excel Tips | Excel Formula | Excel Tips | Excel Formula
https://youtu.be/x_tdsOqhyZk
https://youtu.be/x_tdsOqhyZk
YouTube
GCD function | GCD formula | Excel Tips | Excel Formula | Excel Tips | Excel Formula
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…
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…
GESTEP function | GESTEP formula | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
https://youtu.be/2FzhdIm3p50
https://youtu.be/2FzhdIm3p50
YouTube
GESTEP function | GESTEP formula | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
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)…
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)…
HLOOKUP function | HLOOKUP formula | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
https://youtu.be/o3WAPhRYGSU
https://youtu.be/o3WAPhRYGSU
YouTube
HLOOKUP function | HLOOKUP formula | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
What Does Hlookup function Do ?This function scans across the column headings at the top of a table to find a specified item.When the item is found, it then ...
How to use Autofill in Excel | Fill Series | Autofill series in Excel | Excel Tips
https://youtu.be/mp3OJS8wJfU
https://youtu.be/mp3OJS8wJfU
YouTube
How to use Autofill in Excel | Fill Series | Autofill series in Excel | Excel Tips
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 : …
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 : …
IF function | IF formula | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
https://youtu.be/X8sEO9gkpPs
https://youtu.be/X8sEO9gkpPs
YouTube
IF function | IF formula | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
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…
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…
Index Formula | Index Function | Excel Tips | Excel Formulas | Chaudhary Computers Rajpura
https://youtu.be/F7Mnl-K8A_s
https://youtu.be/F7Mnl-K8A_s
YouTube
Index Formula | Index Function | Excel Tips | Excel Formulas | Chaudhary Computers Rajpura
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…
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…
Indirect Formula | Indirect Function | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
https://youtu.be/B-xv-cXoh7w
https://youtu.be/B-xv-cXoh7w
YouTube
Indirect Formula | Indirect Function | Excel Tips | Excel Formula | Chaudhary Computers Rajpura
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…
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…