Advanced ChatGPT - Including OpenAI API Masterclass

Navigate to ChatGPT openai.com, sign up, verify your email, provide your full name and birthday, then upgrade to plus by paying to activate GPT-4.

Install Python from python.org on Windows, add to path, install Visual Studio Code and Python extension, run scripts in the terminal, save before run, and use input for names.

Navigate to the platform and log in with your ChatGPT account, then open API keys, verify your phone, create a new secret key, copy it, and ensure credits in billing.

Download postman, install it on windows 64 bit, and sign in to unlock new features. Create a collection, add a get request for a Swapi endpoint, and review the response.

learn how to make your first OpenAI API call by creating an API key, setting up Postman, and sending a post request with proper headers and a json body.

Learn to add real-time text streaming to a chatbot using Python and the OpenAI API, handling streamed chunks with delta, content checks, and end parameter.

Create and structure data for a chatbot by organizing an API folder with assistance and data subfolders. Add a document containing information about my company for the bot to know.

Learn to create a personal assistant that uses uploaded files, enable file search, set strict instructions, and test responses based on your own data for code-ready integration.

Create an assistant in Python by adding assistant.py in VSCode, import constants for the API key, set the assistant ID, and run a test conversation to query the assistant.

Reuse assets from the API lesson to enable function calling: copy constants.py, create a functions folder, open it in VS Code, and add a new functions.py file.

Use functions in the code to insert an id into the database via a ChatGPT prompt, manage function calls with GPT-4 mini, and handle JSON responses.

Master advanced Excel formulas by building dynamic lookups from a products table using index and match, explore vlookup alternatives, and practice debugging with screenshots, unique counts, and ChatGPT prompts.

Explore data analysis with pivot tables in Excel, drag fields like product type, units sold, and sales prices to rows and values, and generate native Excel charts.

Use VBA with ChatGPT to automate a billing Excel sheet, reading names and amounts and sending Outlook emails via a macro and a run button.

Navigate to the description url, run the dotnet six installer, open the file, accept the agreement, click next, and install the office ribbon x editor.

Create a custom Excel add-in using the ChatGPT API and VBA, with a chat button and custom UI, to call the API and sum a column’s values.

Enable the chatgpt add-in across all Excel instances by saving it as an Excel add-in on a shared drive and loading it via file options, add-ins, and browse to test.

Learn to use the OpenAI API for image extraction from receipts, encoding images to base64, and extracting date, shop name, and total amount in a structured response.

Learn to automate email sending with ChatGPT generated text using Power Automate Desktop, looping through an invalid receipts data table, composing emails in Outlook, and saving results to Excel.

Automate saving ChatGPT extractions to Excel by creating a new worksheet, writing headers and data from the results, and saving the file to the desktop.

Copy the flow code into a new flow, paste it, and customize your API key, download location, and Outlook email account settings to replicate the solution.

Explore ChatGPT vision to analyze and recognize images, upload an image to include in prompts, and describe scenes with context, including office environment, coworkers, and events like a coffee spill.

Transform handwritten pseudocode into a working application by using ChatGPT to generate Python code, run it to register and display customers, then rewrite to C sharp with object-oriented design.

Describe flowcharts and figures with vision to generate clear process descriptions and professional documentation while analyzing images to identify weak links in the order flow and payment confirmation.

Upload handwritten database structures and let ChatGPT translate them into SQL. Create bank DB with customer, account, and address tables and add dummy data in SQL Server Management Studio.

Upload handwritten meeting notes, convert them into a professional summary, and draft humorous emails for Charlotte, Tim, Michael and Pam, plus a concise action-item agenda.

Install Python by locating the download on Google, downloading the executable, running the installer with admin privileges, and adding Python to the path before clicking install and closing.

Download and install Visual Studio Code using the Windows Installer to set up a free lightweight tool for editing code.

Set up your GitHub account by signing up and entering the emailed verification code. Create a private repository named demo with a readme to demonstrate codecs.

Learn to set up a lightweight developer swimlane task board in VS Code, run a Python page, and push updates to GitHub using basic git commands.

Navigate Codex by connecting GitHub, create and configure an environment, select the correct repository Demo, and manage settings to enable code execution and file uploads.

Explore how Codex answers questions about a code base and compares two versions. Includes static HTML, CSS, JavaScript, a lightweight Python script, and browser local storage.

Develop and integrate a kanban dashboard feature by adding dashboard.html to summarize cards per assignee with counts by status and linkable board views.

Learn how codex fixes bugs by describing the problem, generating code changes, merging pull requests on GitHub, updating local code, and validating that dark mode works across the app.

Install the codex extension for Visual Studio Code and sign in with your ChatGPT account. Use prompts to modify the about page and switch between local and cloud modes.