loader image
Skip to main content
  • Google Sheets: Formulas and Functions
    0%
  • Previous
  • Course data
    General
    Announcements
    Course Overview - Introduction
    Course Overview - Introduction
    Accessing the Data Files
    Accessing the Data Files - Video Tutorial
    Accessing the Data Files - Video Tutorial
    Chapter 1: Working with Sheets and Spreadsheets
    Working with Sheets and Spreadsheets - Introduction
    Viewing, Renaming, and Color-coding Spreadsheets
    Manipulating Spreadsheets
    Creating Linked Formulas between Sheets
    Using Snap to View Multiple Spreadsheets
    Using IMPORTRANGE
    Chapter 2: Understanding Functions
    Understanding Functions - Introduction
    Using Absolute Cell References
    Creating and Using Named Ranges
    Working with Functions
    Working with the Google Sheets Functions List
    Chapter 3: Working with Additional Functions
    Working with Additional Functions - Introduction
    Using Statistical Functions
    Using Math Functions (Part 1 of 2)
    Using Math Functions (Part 2 of 2)
    Using Financial Functions
    Using Date Functions
    Using Filter Functions
    Using Text Functions
    Chapter 4: Working with Logical Functions
    Working with Logical Functions - Introduction
    Using the IF Function
    Using Nested Functions
    Using Multiple Conditions with the IF Function
    Using the IFS Function
    Using the SWITCH Function
    Using the IFERROR Function
    Chapter 5: Working with Lookup Functions
    Working with Lookup Functions - Introduction
    Using HLOOKUP and VLOOKUP Functions (Part 1 of 3)
    Using HLOOKUP and VLOOKUP Functions (Part 2 of 3)
    Using HLOOKUP and VLOOKUP Functions (Part 3 of 3)
    Using the MATCH Function
    Using the INDEX Function
    Nesting the INDEX and MATCH Functions
    Using INDEX MATCH MATCH
    Using INDEX MATCH & MATCH
  • Next
  • Categories
    • All categories
    • Course Demonstrations
    • Free Mini Courses
    • AI Learning Hub
    • Office
    • Webinars
    • Power BI
    • Programming
    • WordPress
    • Microsoft Official
    • Accounting
    • CompTIA
    • Google
    • Upskilling Series
  • Home
Log in
Forgot your password?
Categories Collapse Expand
  • All categories
  • Course Demonstrations
  • Free Mini Courses
  • AI Learning Hub
  • Office
  • Webinars
  • Power BI
  • Programming
  • WordPress
  • Microsoft Official
  • Accounting
  • CompTIA
  • Google
  • Upskilling Series
Home

    Course info

    Google Sheets: Formulas and Functions

    Skill Level: Beginner

    Help & Support
    You are not logged in. (Log in)
    Data retention summary
    Get the mobile app
    Powered by Moodle

    Privacy Policy Terms & Conditions

    Copyrights Content