Using functions in Sheets 2022

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.