Using functions in Sheets 2022

Google Sheets 2022    |    Intermediate
  • 9 videos | 32m 13s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 9 users Rating 4.4 of 9 users (9)
Explore the many functions that are offered in Google Sheets 2022. In this course, learn how to create and save a named function. Next, discover how to work with the LAMBDA function as well as use LAMBDA helper functions. The LAMBDA helper functions help you perform more advanced array operations. These LAMBDA helper functions include MAP, REDUCE, BYROW, BYCOL, SCAN, and MAKEARRAY. Lastly, as alternatives to previous functions, you can now use XLOOKUP and XMATCH to for more powerful and flexible formulas.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the using functions in sheets 2022 course
    Create and save a named function
    Create a lambda function
    Use the map & reduce functions
    Use the byrow & bycol functions
  • Work with the scan function
    Use the makearray function
    Lookup data using the xlookup function
    Use the xmatch function

IN THIS COURSE

  • 52s
    This video outlines the key content covered in Using functions in Sheets 2022 course including creating a named function, using the SCAN function, and using the XLOOKUP function. FREE ACCESS
  • 5m 22s
    If you repeat a function often, Google Sheets allows you to save and name your own custom formulas. You can then reuse the named function again by importing it from another sheet into the current one. FREE ACCESS
  • Locked
    3.  Working with the LAMBDA function in Sheets 2022
    2m 54s
    The LAMBDA function creates a custom function with placeholder inputs that can be reused. The main use for the LAMBDA function is to work with lambda helper functions, such as MAP and REDUCE. FREE ACCESS
  • Locked
    4.  Using the MAP & REDUCE functions in Sheets 2022
    4m 30s
    In Google Sheets, there are several LAMBDA helper functions. You can use the MAP function to create an array of data from an input to a new value based on a LAMBDA function. You can also use the REDUCE function to turn an array input into a single value. FREE ACCESS
  • Locked
    5.  Using the BYROW & BYCOL functions in Sheets 2022
    3m 22s
    The BYROW function takes an array or range and returns a new column array. Similarly, the BYCOL function groups an array or range and produces a new row array. For example, if you want to calculate the sum of the tables in a row, then the BYROW function is very useful. FREE ACCESS
  • Locked
    6.  Using the SCAN function in Sheets 2022
    3m 17s
    If you want to scan an array row by row to produce values, then you can use the SCAN function in Google Sheets. For example, if you would like to calculate the running total of sales, this function can be very useful. FREE ACCESS
  • Locked
    7.  Using the MAKEARRAY function in Sheets 2022
    4m 21s
    The MAKEARRAY function generates an array of a specified size and allows for each value to be calculated by a custom LAMBDA function. For example, you can quickly create a table with a specific number of rows and columns. FREE ACCESS
  • Locked
    8.  Using the XLOOKUP function in Sheets 2022
    4m 47s
    As an alternative to the VLOOKUP or HLOOKUP functions, you can use the XLOOKUP function. This function matches a search key in a lookup range and returns the value from a result range from that same position. FREE ACCESS
  • Locked
    9.  Using the XMATCH function in Sheets 2022
    2m 48s
    Instead of using the MATCH function, you can use the XMATCH function as a more powerful and flexible formula. XMATCH returns the relative position of an item in an array or range that matches a specific value. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.4 of 37 users Rating 4.4 of 37 users (37)
Rating 4.9 of 11 users Rating 4.9 of 11 users (11)
Rating 4.5 of 15 users Rating 4.5 of 15 users (15)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
Rating 4.4 of 161 users Rating 4.4 of 161 users (161)