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, "")