Using functions in Sheets 2022

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.