Not, Correl, Transpose And Array Function In Excel - Class 27
на канале: Knowledge Bits
In this video, you'll understand the NOT function is an Excel Logical function. this function helps check if one value is not equal to another. If we give TRUE, it will return FALSE and when given FALSE, it will return TRUE. So, basically, it will always return a reverse logical value.
The TRANSPOSE function uses when sometimes you need to switch or rotate cells. You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type a formula instead using the TRANSPOSE function.
The CORREL function returns the correlation coefficient of two cell ranges. Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location's average temperature and the use of air conditioners.
In Excel, an Array Formula allows you to do powerful calculations on one or more value sets. The result may fit in a single cell or it may be an array. An array is just a list or range of values, but an Array Formula is a special type of formula that must be entered by pressing Ctrl+Shift+Enter.
Introduction OF Advanced Excel # • Introduction Of Advanced Excel - Class 1
Upper Lower And Proper Function In Excel # • Upper Lower And Proper Function In Excel -...
Concatenate Function In Excel # • Concatenate Function In Excel - Class 3
10 Basic Function In Excel # • 10 Basic Functions In Excel - Class 4
IF Function In Excel # • IF function In Excel - Class 5
Date Function In Excel # • Date Function In Excel - Class 6
Time Function In Excel # • Time Function In Excel - Class 7
EDATE and EOMONTH In Excel # • Edate And Eomonth In Excel - Class 8
12 Basic Function In Excel # • 12 Basic Function In Excel - Class 9
AND And OR Function In Excel # • AND and OR Function In Excel - Class 10
7 Basic Function In Excel # • 7 Basic Function In Excel - Class 11
IS Functions In Excel # • IS Functions In Excel - Class 12
11 Basic Function In Excel # • 11 Basic Function In Excel - Class 13
Workdays Function In Excel # • Workdays Functions In Excel - Class 14
Vlookup Function In Excel # • VLOOKUP Function In Excel - Class 15
Vlookup Part-2 & Lookup Function In Excel # • Vlookup Part 2 & Lookup Function In Excel ...
Types of Error In Excel # • Types of Error In Excel - Class 17
Error Functions In Excel # • Error Functions In Excel - Class 18
Rank And Choose Functions In Excel # • Rank And Choose Functions In Excel - Class 19
Large Small And DB Function In Excel # • Large Small And DB Function In Excel - Cla...
DCOUNT and 5 Other Important Functions In Excel # • DCOUNT and 5 Other Important Functions In ...
Sum Using Named Ranges concept in Excel # • Sum Using Named Ranges concept in Excel- C...
LEFT, RIGHT, TRIM, LEN, MID And FIND Function In Excel # • LEFT, RIGHT, TRIM, LEN, MID And FIND Funct...
Replace And Substitute Function In Excel # • Replace And Substitute Function In Excel -...
Datedif Function In Excel # • Datedif Function In Excel - Class 25
Datevalue Timevalue And Median Function In Excel # • Datevalue Timevalue And Median Function In...