MS Excel Toronto - Supercharge your formula authoring abilities with Excel Labs - Chris Gross
Session recorded live on May 15
The MS Excel Toronto Meetup group was founded in May 2019 and has had monthly sessions since then. Sessions are currently offered for free online, with a different topic presented by an Excel Expert each month. Members are from all over the world, totalling more than 4,000.
ATTEND THE MS EXCEL TORONTO MEETUP GROUP SESSIONS LIVE 👇
Register for free as a member of the group: https://www.meetup.com/MSExcelToronto
ACCESS THE EXERCISE FILES shared by the presenter are available to the group members on the Meetup website 👇
Access on the browser (not the mobile app) go to the main menu and select More - Message Boards.
The MS Excel Toronto Meetup group sessions are organized and run by
Celia Alves - / celiajordaoalves
Gráinne Dugan - / grainneduggan1
-----------------------
Keep up with the Excel News by subscribing to Celia’s newsletter: https://snapreportschamp.com/subscrib...
Learn how to automate your Excel reports:
https://snapreportschamp.com/course
-------------------------------------
About this session:
The EXCEL LABS add-in, a Microsoft Garage project, includes three features:
ADVANCED FORMULA ENVIRONMENT: an interface designed for authoring, editing, debugging, and reusing formulas. It is especially useful for more extended formulas where indenting is crucial for efficient formula reading and interpretation.
LABS.GENERATIVEAI FUNCTION: allows you to benefit from the power of generative AI directly from the Excel grid by connecting to your OpenAI account and inquire ChatGPT directly from within Excel.
PYTHON EDITOR: a notebook-like interface designed for authoring Python in Excel.
Chris Gross, Product Manager at the Microsoft Excel team, shows all these features and the improvements Microsoft has recently made to the Excel Labs add-in.
---------------------
About the Speaker: Chris Gross
Ask Chris about all things Data Types, Office.JS, and formulas.
--------------
Timestamps
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:11:55 - Celia Introduces and welcomes Chris Gross
00:15:00 - Chris introduces his presentation & Excel Labs add-in from Microsoft
00:20:25 - Advanced Formula Environment (AFE) overview; functions from sheets (Grid tab)
00:24:45 - AFE Names tab - create a LAMBDA using AFE
00:28:50 - Custom LAMBDA overview; Create a LAMBDA to calculate the hypotenuse of right- angle triangle; advantages of LAMBDA; Ranges and Formula sections of Names tab, IntelliSense and dropdown lists for built in Excel functions
00:37:40 - Modules overview; create PRODUCTIF function in a module;
00:50:00 - Rock-Paper-Scissors LAMBDA, Use GitHub page for Excel Labs to import module from URL or copy and paste the code; Copy Lisp functions into AFE module; menu options for right click - Go to Symbol, Peek to get more information
00:55:00 - Formula Debugger to debug Excel formula and rename symbol (parameters)
01:09:05 - Labs.GenerativeAI overview and how to get your API key, use OpenAI and Labs.Generative AI to get the top 10 tourist attractions in a city. Create a Lambda from the results
01:18:00 - Python editor in Excel Labs overview
01:22:00 - Questions
01:25:00 - Khashayar Asgari demonstrates what R can do in Excel
01:28:00 - Wrap up