Скачать или смотреть 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