Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced ChatGPT – Including OpenAI API Masterclass
Introduction
Welcome
Important: Video setting (0:36)
Coding with ChatGPT
Create a ChatGPT Plus account (2:02)
How to install Visual Studio Code and Python (12:13)
ChatGPT as your junior developer (24:42)
Using the OpenAI/ChatGPT APIs
Get an OpenAI API key (1:31)
How to install Postman (2:41)
Your first OpenAI API call (7:12)
Create an OpenAI API call through code (Python) (3:28)
Create a "real" OpenAI chatbot (3:06)
Add real-time text streaming to the chatbot (2:17)
Assistants 1: Intro
Assistants 2: Create and structure data (1:34)
Assistants 3: Add your own data (3:16)
Assistants 4: Create a constant file (2:19)
Assistants 5: Use the assistant in the code (3:45)
Functions 1: Intro
Functions 2: Create a folder and reuse the constant file (1:04)
Functions 3: Definitions (0:32)
Functions 4: Use Functions in the code (2:45)
ChatGPT for Excel and VBA
ChatGPT helps with simple formulas (3:58)
Advanced formulas and debugging with ChatGPT (5:03)
Data Analysis (5:37)
VBA with ChatGPT (5:58)
How to install the Office RibbonX Editor (0:23)
Create an OpenAI Excel add-in (4:46)
(Optional) Enable the add-in for all Excel instances (1:36)
Document processing with the OpenAI API and Microsoft Power Automate Desktop
How to install Power Automate Desktop (1:10)
(Optional) How to change language in Power Automate Desktop (1:51)
Create a new Power Automate Desktop flow (0:41)
Automatically download the first item (9:38)
Expanding the solution to all items (8:17)
Image extraction with the OpenAI API (14:35)
JSON parsing and saving the results (15:13)
Send emails with ChatGPT generated text (4:04)
Save ChatGPT extractions to Excel (5:33)
(Optional) Importing my solution (0:40)
Vision
Vision intro (2:35)
From pseudocode to an application (4:49)
Flowcharts and figures (4:42)
How to install SQL and SSMS (2:42)
Sketch SQL and ChatGPT builds it (6:03)
Handwritten meeting notes (1:23)
Now what?
AI and Automation Black Belt
(Optional) Enable the add-in for all Excel instances
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock