Introduction to Excel
Jess Ahmet
Curriculum Manager, DataCamp
Inside Scope
Outside Scope
LEFT()
LEFT(text, [num_chars])
LEFT("DataCamp", 4)
> DataRIGHT()
RIGHT(text, [num_chars])
RIGHT("DataCamp", 4)
> CampUPPER()
UPPER(text)
UPPER("DataCamp")
> DATACAMPLOWER()
LOWER(text)
LOWER("DataCamp")
> datacampDATE()
DATE(year,month,day)
DATE(2020,10,31)
= 2020/10/31DAY()
DAY(<serial_number>)
.DAY(<serial_number>)
.YEAR()
YEAR(serial_number)
ROUND()
ROUND(number, num_digits)
=ROUND(-1.475, 2)
= -1.48ABS()
Syntax: ABS(number)
Description: returns the absolute value of a number without it's sign
ABS(-2)
= 2SUM()
AVERAGE()
COUNT()
MIN()
MAX()
Introduction to Excel