MS Excel Toronto Meetup Group - Excel and ChatGPT - Steve Kraynak
Learn how to automate your recurring Excel Reporting Procedures – FREE Masterclass here:
https://snapreportschamp.com/course
Ready-to-use Excel File with Dependent Dropdown Lists that you can adapt to your needs:
https://solveandexcel.ca/dynamic-depe... https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________
Session recorded live on 2023-11-08
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:
Do you want to know how ChatGPT can help you get work done in Excel? This session has you covered. Steve gave a brief overview of ChatGPT and showed a few of the common ways that you can get started with it. He also pointed out some aspects of ChatGPT that you need to be mindful of when using it. Then he showed and discussed some interesting ways that you might want use it in conjunction with Excel.
---------------------
About the Speaker: Steve Kraynak
Steve joined SumProduct after more than a decade as a Product Manager for the Excel team at Microsoft, where he made a name for himself in the Excel community as a customer advocate. He directly impacted many features in Excel, including new worksheet functions like IFS & TEXTJOIN, Data from Picture, Excel for Mac, user experience improvements like Smooth Scrolling, and many others.
--------------
Find more about Steve’s work and connect with him:
LinkedIn: / steve-kraynak
Website: https://www.sumproduct.com/
Blog: https://www.sumproduct.com/blog
https://insider.microsoft365.com/blog...
https://insider.microsoft365.com/en-u...
Chapters
00:00:00 - Celia Alves MS Excel Toronto introduction
00:06:05 - Celia Introduces Steve Kraynak
00:08:20 - Steve introduces himself and his presentation
00:11:50 - ChatGPT – What is it? What it is good at. What it is not good at. ChatGPT versions
00:16:30 - Words to the wise. Some caveats for use of ChatGPT. Getting started with ChatGPT
00:20:35 - Bing Chat vs Chat.OpenAI.com and Bing sidebar in Edge
00:25:40 - Tips for good “prompt engineering”. Providing examples to ChatGPT
00:29:20 - Top tasks to help with Excel. Sample prompts, finding a function in Excel, explain a formula, write a formula, get insights about the data
00:39:35 - Create sample data. Write an Excel macro (VBA). Clarify your prompts. Add comments to VBA code
00:49:35 - Changes to ChatGPT in early Nov. 2023. Default plugins and available plugins
00:57:15 - Advanced Data Analysis (Analysis) – with downloadable Excel file, Excel Labs add-in
01:04:00 - M365 Copilot for some Enterprise licenses
01:09:00 - Questions
01:15:20 - MS Excel Toronto news and upcoming events & Wrap up