# Using functions in Sheets 2022

• 9 videos | 32m 13s
• Includes Assessment
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

• 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.
• 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.
• 3.  Working with the LAMBDA function in Sheets 2022
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.
• 4.  Using the MAP & REDUCE functions in Sheets 2022
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.
• 5.  Using the BYROW & BYCOL functions in Sheets 2022
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.
• 6.  Using the SCAN function in Sheets 2022
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.
• 7.  Using the MAKEARRAY function in Sheets 2022
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.
• 8.  Using the XLOOKUP function in Sheets 2022
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.
• 9.  Using the XMATCH function in Sheets 2022
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.

## 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 (37)
Rating 4.9 of 11 users (11)
Rating 4.5 of 15 users (15)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

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