https:\/\/excelisfun.net\/files\/EMT1749.xlsx<\/a>
\nLearn how to use the 7 helper functions for the LAMBDA function. Learn how to use LAMBDA to create a re-usable function, and then how to use LAMBDA as a function value in the LAMBDA helper functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY.
\nAlso see the Old School worksheet formula methods we used to use when we did not have these new functions.
\n1. (00:00) Introduction
\n2. (00:15) Function values are now in the Excel worksheet
\n3. (00:54) LAMBDA to make a reusable function.
\n4. (02:43) ISOMITTED Function to add message for missing arguments.
\n5. (03:39) How BYROW, BYCOL and MAP are related.
\n6. (04:32) How SCABN and REDUCE are related
\n7. (04:49) What is MAKEARRAY
\n8. (04:56) BYROW Function to create spilled row totals.
\n9. (06:56) BYCOL Function to create spilled column totals.
\n10. (07:41) MAP Function: three examples.
\n11. (08:53) How MAPS and BYROW are related.
\n12. (09:19) MAP function to spill results from the scalar AND Logical function. This MAP example uses a LAMBDA function that works across two columns.
\n13. (10:44) BYROWS to help calculate standard deviation of finance portfolio of stocks
\n14. (12:26) SCAN Function to create array of running total counts. This example uses SCAN to add and accumulate.
\n15. (13:27) REDUCE Function to add a set of numbers after they accumulate.
\n16. (14:10) SCAN Function multiply and accumulate.
\n17. (14:25) SCAN Function to join and accumulate.
\n18. (14:49) MAKEARRAY Function to create an array of random values.
\n19. (15:25) MAKEARRAY that uses row and column variable in LAMBDA.
\n20. (15:54) Summary and concluding video links<\/p>\n","protected":false},"excerpt":{"rendered":"Download Excel File: https:\/\/excelisfun.net\/files\/EMT1749.xlsx Learn how to use the 7 helper functions for the LAMBDA function. Learn how to use LAMBDA to create a re-usable function, and then how to use LAMBDA as a function value in the<\/p>\n","protected":false},"author":3,"featured_media":2700,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/08\/Eb5sXiLhUd4.jpg?fit=480%2C360&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-Hx","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2699"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=2699"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/2699\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/2700"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=2699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=2699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=2699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}