Share LAMBDA Functions across Workbooks (Excel LAMBDA Function Tutorial)

Learn how to share LAMBDA functions across workbooks in Excel. This video shows three different methods to share your custom LAMBDA functions.
📺 Related Videos
Learn Excel LAMBDA functions: kzbin.info/www/bejne/mKKbY4aBqZqZeZY
REDUCE function in Excel: kzbin.info/www/bejne/d4naXmpjnbeEbrM
TEXTBEFORE and TEXTAFTER functions: kzbin.info/www/bejne/q56zo5tvqqhrd9E
After you learn LAMBDA functions in Excel, the next question is often how to share LAMBDA functions. This video answers that question with three different methods, each with their own unique advantages.
📚 Resources from this Excel tutorial
Gist on GitHub: gist.github.com/
Learn about creating gists: docs.github.com/en/get-started/writing-on-github/editing-and-sharing-content-with-gists/creating-gists
Get Monkey Tools: excelguru.ca/monkey-tools/
⌚ Timestamps
00:00 - Introduction
00:52 - LAMBDA function in Excel
01:58 - Copy LAMBDA functions between workbooks
03:25 - Using gists on GitHub
03:54 - Import LAMBDA functions from GitHub
05:36 - Create gists in GitHub for custom LAMBDA functions
08:12 - Share LAMBDA functions with GitHub
09:20 - Use Monkey Tools to share LAMBDA functions
🔗 Connect with us!
LinkedIn ► www.linkedin.com/in/alanmurray-computergaga/
Instagram ► computergaga1
Twitter ► computergaga1
TikTok ► www.tiktok.com/@computergaga
#excel #lambdafunction

[@brighttriangle]

Thank you for this video. I appreciated the GitHub method you shared. Great work!

[@Computergaga]

Thank you very much.

[@user12345654]

Wonderful ! It was very helpful.

[@Computergaga]

Thank you 😊

[@malchicken]

Thank you very much for this. I’d also be interested to know how to share Power Query functions, imagining the following scenario: you are the only one who knows power query and need to try to drag and entire organization into more modern work practices; the users at first are only willing to press 1 button at most. Videos on this sort collaborative environment are much appreciated. Thank you.

[@Computergaga]

Thank you for your comments. The final example showcasing Monkey Tools can help with sharing Power Query functions, though collaboration with others in an organisation is more difficult with that approach. I feel your pain in bringing people into modern work practises.

[@leebecker8255]

I've been wanting to do this too!!

[@leebecker8255]

@@Computergaga Oooooohh!! Thanks Alan, I need to try this too :)

[@alex626ification]

This is really helpful. Curious why Microsoft doesn't have a native feature similar to the github / biblo monkey. It would be amazing to share my custom formlers automatically with all my excels and coworkers.

[@Computergaga]

Yes indeed. Thank you for your comment.

[@kadnfildnsflisfilsdn]

This is helpful, but I do have two questions re: Github sharing.... 1. Some of the lambdas I have written exceed name manager's character limit, so they only show up correctly in Excel Labs, so how do I put that into github since I cannot copy and paste directly from name manager? 2. Is there a way to export all lambdas in Excel Labs at once?

[@totallynotvcool9800]

bro only has 78 likes he really fell off