Prompt Flow Engineering with ChatGPT in Excel

سرفصل های دوره

Learn to create AI-infused Excel workbooks.

1. Introduction

1. Introduction

2. Getting Started

1. Overview on How to Get Started with ChatGPT in Excel

2. Checking your Excel Version or Accessing the Free Excel for the Web

3. Creating an OpenAI Platform Account and an OpenAI API Key

4. A framework for Thinking About ChatGPTs Capabilities

5. Wrapping Up Getting Started with ChatGPT in Excel

6. Getting Started.html

Files.zip

3. Creating Prompts with Excel Formulas

1. Introduction to Creating Prompts with Excel Formulas

2. Concatenating Text with the Ampersand (&) Operator

3. Converting Numbers to Text

4. Converting List-like Cell Ranges to Strings of Text for Prompting

5. Converting Tabular Cell Ranges to Strings of Text for Prompting

6. LAB Create a Text Topic Verification Tool

7. LAB Solution Walkthrough Text Topic Verification Tool

8. Creating Prompts with Excel Formulas.html

Files.zip

4. Basic Prompt Engineering Techniques for Excel

1. Introduction to Basic Prompt Engineering Techniques for Excel

2. Quiescing or Letting ChatGPT Return Only the Output that You Need

3. Letting ChatGPT Generate Numbers for Excel Formulas

4. Letting ChatGPT Generate Dates for Excel Formulas

5. Letting ChatGPT Generate Times for Excel Formulas

6. Letting ChatGPT Return Comma Separated Values for Excel Formulas

7. Letting ChatGPT Generate Tabular Data

8. LAB Create a Date Transformation Tool

9. LAB Solution Walkthrough Date Transformation Tool

10. Wrapping Up Basic Prompt Engineering Techniques for Excel

11. Basic Prompt Engineering Techniques for Excel.html

Files.zip

5. Prompt Flow Logic in Excel

1. Introduction to Prompt Flow Logic in Excel

2. Letting the User Decide, what to Do Next

3. Letting Excel decide, what to do Next, and Excel Logic Functions and Operators

4. Letting ChatGPT Decide what to do Next

5. Looking up the Next Prompt from a Lookup Table

6. Creating Parallel Prompt Flows

7. Creating Sequential Prompt Flows

8. Creating Loops

9. Using LAMBDA Functions to Encapsulate Logic

10. LAB Create a Slogan Generator

11. LAB Solution Walkthrough Slogan Generator

12. Wrapping Up Prompt Flow Logic in Excel

13. Prompt Flow Logic in Excel.html

Files.zip

6. Advanced Prompt Engineering Techniques for Excel

1. Introduction to Advanced Prompt Engineering Techniques for Excel

2. Few Shot Prompting

3. Chain-of-Thought Prompting (COT)

4. Introduction to Retrieval Augmented Generation (RAG)

5. Implementing Retrieval Augmented Generation (RAG) in Excel

6. Acting

7. LAB Create the FLASH LAMBDA Function, a Flash Fill powered by ChatGPT

8. LAB Solution Walkthrough FLASH Function

9. Wrapping Up (Advanced Prompt Engineering Techniques for Excel)

10. Advanced Prompt Engineering Techniques for Excel.html

Files.zip

7. Responsible AI and Wrapping up the Course

1. Responsible AI

2. Responsible AI.html

3. Congratulations

54,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy