Download pdf notes: https:\/\/excelisfun.net\/files\/10-M365ExcelClassStart.xlsx<\/a>
\nDownload Excel file: https:\/\/excelisfun.net\/files\/10-M365ExcelClassFinished.xlsx<\/a>
\nThis is a 1 hour 45 min. video about everything that the Excel LAMBDA function can do. This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports.
\nCourse taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
\nTopics in video:
\n1. (00:00) Introduction
\n2. (00:52) Overview
\n3. (02:42) Defined Names
\n4. (12:24) First look at LAMBDA to create a re-usable function
\n5. (19:00) Advanced Formula Environment
\n6. (23:40) Summary of LAMBDA
\n7. (25:20) Rate Of Change Re-usable LAMBDA function
\n8. (28:06) COGS Re-usable LAMBDA function created in Advanced Formula Environment
\n9. (30:22) Save LAMBDA to default file
\n10. (32:15) Show Formula Re-usable LAMBDA function
\n11. (36:06) LAMBDA Helper Functions
\n12. (36:32) BYROW and BYCOL functions
\n13. (41:10) MAP function
\n14. (49:16) SCAN function
\n15. (54:03) REDUCE function, initial look
\n16. (55:23) Recursion with LAMBDA
\n17. (01:04:13) REDUCE function, introduction and three examples
\n18. (01:15:00) MAKEARRAY function
\n19. (01:17:04) LET function
\n20. (01:18:16) Single Cell Formula Reports
\n21. (01:19:50) Single Cell End Of Month Report
\n22. (01:29:45) Conditional Formatting For Dynamic Reports
\n23. (01:31:39) Single Cell Cross Tabulated Report
\n24. (01:335:01) Single Cell Report that can create four different reports
\n25. (01:39:00) ISOMITTED function
\n26. (01:44:07) Summary and Conclusions
\n27. (01:44:43) Closing and Video Links<\/p>\n

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https:\/\/creativecommons.org\/licenses\/by\/4.0\/<\/a> . Artist: http:\/\/audionautix.com\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Download pdf notes: https:\/\/excelisfun.net\/files\/10-M365ExcelClassStart.xlsx Download Excel file: https:\/\/excelisfun.net\/files\/10-M365ExcelClassFinished.xlsx This is a 1 hour 45 min. video about everything that the Excel LAMBDA function can do. This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports. Course taught by Excel MVP and Highline College Professor, Mike Girvin. […]<\/p>\n","protected":false},"author":3,"featured_media":4867,"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\/2022\/12\/45v5NhPhopc.jpg?fit=480%2C360&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1gu","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4866"}],"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=4866"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/4866\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/4867"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=4866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=4866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=4866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}