Excel, Sheets

Excel, Sheets
​https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/​
RANK
LEFT, RIGHT
LEN, SEARCH
WEEKDAY
​DATEDIF​
NOW
IF
IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))
OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)
​COUNTIF(range, criterion)​
​SUMIF(range, criterion, sum_range)​
​AVERAGEIF(range, criterion, average_range)​
​VLOOKUP(search_key, range, index, is_sorted)​
​HLOOKUP(search_key, range, index, is_sorted)​
​SUMPRODUCT(array1, [array2, ...])​
​https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/​
RANK
LEFT, RIGHT
LEN, SEARCH
WEEKDAY
​DATEDIF​
NOW
IF
IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))
OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)
​COUNTIF(range, criterion)​
​SUMIF(range, criterion, sum_range)​
​AVERAGEIF(range, criterion, average_range)​
​VLOOKUP(search_key, range, index, is_sorted)​
​HLOOKUP(search_key, range, index, is_sorted)​
​SUMPRODUCT(array1, [array2, ...])​
Excel, Sheets
​https://spreadsheets.datacamp.com/courses/data-analysis-with-spreadsheets/​
RANK
LEFT, RIGHT
LEN, SEARCH
WEEKDAY
​DATEDIF​
NOW
IF
IF(H14 <___, ___, IF(H14 < ___, "acceptable", ___))
OR(WEEKDAY(A1,3)=5, WEEKDAY(A1,3)=6)
​COUNTIF(range, criterion)​
​SUMIF(range, criterion, sum_range)​
​AVERAGEIF(range, criterion, average_range)​
​VLOOKUP(search_key, range, index, is_sorted)​
​HLOOKUP(search_key, range, index, is_sorted)​
​SUMPRODUCT(array1, [array2, ...])​
Compare two sheets
=IF(Sheet1!A1<> Sheet2!A1, Sheet1!A1&" | "&Sheet2!A1, "")
Last modified 4mo ago