MS Excel Toronto Meetup - Python in Excel - Ndeyanta Jallow, Chris Gross and Keyur Patel
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
---------------------------------------------------------------------------------------------------------
Session recorded live on 2023-09-13
To attend the MS Excel Toronto meetup group sessions live, please register for free as a member of the group:
https://www.meetup.com/MSExcelToronto
The MS Excel Toronto Meetup group is organized by
Celia Alves - / celiajordaoalves
Vivek Patel - / insight2action
Dick Moffat - / dick-moffat-65721
_________________________________
About the Session
Python is one of the most popular programming languages today, loved by business and students alike – used for data analysis, visualization, machine learning and more. Python in Excel makes it possible to natively combine Python and Excel analytics in the same workbook – with no setup required.
With Python in Excel, you can type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations.
Python in Excel leverages Anaconda Distribution for Python running in Azure, which includes the most popular Python libraries such as pandas, statsmodels, Matplotlib and seaborn.
---------------------
About the Speakers:
Ndeyanta Jallow - Product Manager
Ndeyanta Jallow is a Product Manager on the Excel team who is passionate about empowering the world to make data-driven decisions. Prior to joining Excel, she worked in financial services and strategic consulting.
Chris Gross - Product Manager
Chris Gross is a Product Manager on Excel who is passionate about combining the principles of programming with the world of Excel. Some highlights include LET, LAMBDAs, Data Types, Excel Labs, and now Python in Excel.
Keyur Patel- Technical Program Manager
Keyur Patel is a Program Manager at Microsoft and he loves Python and Excel. He's spent his whole career wearing different hats and roles, all centered around making data and logic more accessible to everyone through the magical canvas that is Excel. He's super excited to see what the community will build, now that we have Python in Excel!
---------------------
Find more about their work and connect with them:
Website: aka.ms/python-in-excel
Blog: Announcing Python in Excel (microsoft.com)
---------------------
VIDEO CHAPTERS:
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:07:07 - Excel Reports Course
00:07:45 - Celia Introduces Presenters
00:09:54 - Presenter Ndeyanta Jallow begins presentation
00:10:38 - Agenda for the day
00:12:04 - Why Python in Excel
00:13:32 - What is Python?
00:17:49 - Chris Gross presents Demos
00:39:35- Weather Forecast Demo
00:48:31- Extract Format and Dates Demo
00:51:57 - Keyur Patel talks about Data Security and Python in Excel
00:58:14 - Ndeyanta Jallow explains How to test it out
00:59:19 - Resources
01:01:18 - Q & A