Using functions in Sheets 2022
Google Sheets 2022
| Intermediate
- 9 videos | 32m 13s
- Includes Assessment
- Earns a Badge
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
-
52sThis 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 22sIf 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
-
3. Working with the LAMBDA function in Sheets 20222m 54sThe 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
-
4. Using the MAP & REDUCE functions in Sheets 20224m 30sIn 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
-
5. Using the BYROW & BYCOL functions in Sheets 20223m 22sThe 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
-
6. Using the SCAN function in Sheets 20223m 17sIf 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
-
7. Using the MAKEARRAY function in Sheets 20224m 21sThe 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
-
8. Using the XLOOKUP function in Sheets 20224m 47sAs 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
-
9. Using the XMATCH function in Sheets 20222m 48sInstead 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.
