This video shows how to use Chat GPT in Excel to generate sample data sets, summaries, and other tasks based on user input. The video demonstrates how to use Office Scripts in Excel to call the OpenAI GPT models via both the OpenAI API and the Azure OpenAI service, and how to write the data to Excel sheets and tables using TypeScript code.
Highlights:
[00:00:00] Introduction and overview
Explains the purpose and benefits of generating sample data sets with Chat GPT
Shows an example of a sample data set based on 10 use cases for Power Automate
[00:01:06] How to use Office Scripts in Excel
Shows the Automate tab and the scripts menu
Explains how to run a script and provide parameters, such as the api key and the prompt
Shows the output of the script and the tokens consumed
[00:04:08] How to use Azure OpenAI service
Shows the Azure OpenAI studio and the code for the script
Explains the difference between the OpenAI API and the Azure OpenAI service
Shows another example of a sample data set based on the top 20 films of 2020
[00:06:46] How to generate summaries with Chat GPT
Shows a third script that takes the selected cell text and sends it to Chat GPT
Shows examples of summaries for different texts, such as cat, dog, and German Shepherd
[00:08:59] How to follow instructions with Chat GPT
Shows a modified script that follows the instructions provided by the user
Shows examples of instructions, such as what is 9 + 4, tell me a joke about chickens, and generate an email reply to a complaint letter
Explains the advantages and limitations of using Chat GPT in Excel
[00:10:52] Conclusion and resources
Summarizes the main points and features of the video
Provides the links to download the sample scripts and to sign up for the OpenAI API or the Azure OpenAI service
Export to Excel via Graph API or Office Scripts: • Create Excel File and ...
Office Script Playlist: • Office Scripts
External API Calls in Excel via Office Scripts: learn.microsoft.com/en-us/off...
Sample Files: damobird365.gumroad.com/l/Ope...
Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕