Other functions in Excel

Introduction to Excel

Jess Ahmet

Curriculum Manager, DataCamp

Function categories

Inside Scope

  • Text
  • Date & Time
  • Maths & Trig
  • Statistical

Outside Scope

  • Financial
  • Logical
  • Lookup References
  • Engineering
  • Cube
  • Information
  • Web
  • Compatibility
Introduction to Excel

Text

LEFT()

  • Syntax: LEFT(text, [num_chars])
  • Description: returns the first character(s) in a string based on the specified number of characters
  • Example: LEFT("DataCamp", 4) > Data

RIGHT()

  • Syntax: RIGHT(text, [num_chars])
  • Description: returns the last character(s) in a string based on the specified number of characters
  • Example: RIGHT("DataCamp", 4) > Camp
Introduction to Excel

Text

UPPER()

  • Syntax: UPPER(text)
  • Description: converts string to uppercase
  • Example: UPPER("DataCamp") > DATACAMP

LOWER()

  • Syntax: LOWER(text)
  • Description: converts string to lowercase
  • Example: LOWER("DataCamp") > datacamp
Introduction to Excel

Date & Time

DATE()

  • Syntax: DATE(year,month,day)
  • Description: returns a sequential serial number that represents a particular date

Visual representation of how date functions work

  • Example: DATE(2020,10,31) = 2020/10/31
Introduction to Excel

Date & Time

  • DAY()
    • Syntax: DAY(<serial_number>).
    • Example: DAY(<serial_number>).
    • Description: returns the day of a corresponding date as integer
  • YEAR()
    • Syntax: YEAR(serial_number)
    • Description: returns the year to a corresponding date as an integer
Introduction to Excel

Maths & Trig

  • ROUND()

    • Syntax: ROUND(number, num_digits)
    • Description: returns a number rounded to a specified number of digits
    • Example: =ROUND(-1.475, 2) = -1.48
  • ABS()

    • Syntax: ABS(number)

    • Description: returns the absolute value of a number without it's sign

    • Example: ABS(-2) = 2
  • SUM()
Introduction to Excel

Statistical

  • AVERAGE()
  • COUNT()
  • MIN()
  • MAX()
Introduction to Excel

Let's practice!

Introduction to Excel

Preparing Video For Download...