Prompt Flow Engineering with ChatGPT in Excel

Focused View

Mitja Martini

4:16:01

30 View

1. Introduction

1. Introduction.mp4

07:30

2. Getting Started

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

01:28

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

06:05

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

09:23

4. A framework for Thinking About ChatGPTs Capabilities.mp4

04:55

5. Wrapping Up Getting Started with ChatGPT in Excel.mp4

01:16

6. Getting Started.html

Files.zip

3. Creating Prompts with Excel Formulas

1. Introduction to Creating Prompts with Excel Formulas.mp4

03:57

2. Concatenating Text with the Ampersand (&) Operator.mp4

04:02

3. Converting Numbers to Text.mp4

02:55

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

02:49

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

06:10

6. LAB Create a Text Topic Verification Tool.mp4

02:30

7. LAB Solution Walkthrough Text Topic Verification Tool.mp4

02:44

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.mp4

02:17

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

04:26

3. Letting ChatGPT Generate Numbers for Excel Formulas.mp4

05:03

4. Letting ChatGPT Generate Dates for Excel Formulas.mp4

02:54

5. Letting ChatGPT Generate Times for Excel Formulas.mp4

02:41

6. Letting ChatGPT Return Comma Separated Values for Excel Formulas.mp4

04:34

7. Letting ChatGPT Generate Tabular Data.mp4

02:52

8. LAB Create a Date Transformation Tool.mp4

01:25

9. LAB Solution Walkthrough Date Transformation Tool.mp4

04:39

10. Wrapping Up Basic Prompt Engineering Techniques for Excel.mp4

01:52

11. Basic Prompt Engineering Techniques for Excel.html

Files.zip

5. Prompt Flow Logic in Excel

1. Introduction to Prompt Flow Logic in Excel.mp4

05:23

2. Letting the User Decide, what to Do Next.mp4

06:11

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

07:09

4. Letting ChatGPT Decide what to do Next.mp4

05:31

5. Looking up the Next Prompt from a Lookup Table.mp4

10:18

6. Creating Parallel Prompt Flows.mp4

08:49

7. Creating Sequential Prompt Flows.mp4

13:37

8. Creating Loops.mp4

12:16

9. Using LAMBDA Functions to Encapsulate Logic.mp4

14:23

10. LAB Create a Slogan Generator.mp4

03:57

11. LAB Solution Walkthrough Slogan Generator.mp4

07:58

12. Wrapping Up Prompt Flow Logic in Excel.mp4

01:59

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.mp4

04:26

2. Few Shot Prompting.mp4

11:14

3. Chain-of-Thought Prompting (COT).mp4

06:56

4. Introduction to Retrieval Augmented Generation (RAG).mp4

05:27

5. Implementing Retrieval Augmented Generation (RAG) in Excel.mp4

09:16

6. Acting.mp4

07:25

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

03:16

8. LAB Solution Walkthrough FLASH Function.mp4

09:38

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

04:09

10. Advanced Prompt Engineering Techniques for Excel.html

Files.zip

7. Responsible AI and Wrapping up the Course

1. Responsible AI.mp4

04:37

2. Responsible AI.html

3. Congratulations.mp4

03:39

Description

Learn to create AI-infused Excel workbooks.

What You'll Learn?

Getting started with ChatGPT in Excel.
Prompting ChatGPT in Excel formulas.
Prompting ChatGPT for results you can use in Excel formulas.
Adding logic to prompt flows in Excel.
Building complete tools with ChatGPT and Excel.
Using advanced prompt engineering techniques in Excel.

Who is this for?

Excel users who want to "AI infuse" their workbooks.

ChatGPT users interested in automating their prompt flows.

Employees, and students who want to gain in-demand AI Engineering skills.

What You Need to Know?

Basic Excel skills. You know how to write formulas.

An up-to-date version of Excel for Windows or Excel for Mac, or the free Excel for the Web.

An OpenAI Platform account (I'll show you how to get one in the course).

More details

Description
This course is designed for Excel users looking to integrate Generative AI into their workflows.
You might be an employee, manager, or exec who wants to level up and gain AI Engineering skills or someone who has recently said one of the following:
"I'm tired of copying and pasting data between ChatGPT and Excel."
"I want to generate/extract/analyze my data more intelligently with ChatGPT.â€
"I have prompts I use on a regular basis and would like to automate their use."
"I have valuable calculations and data in spreadsheets, that IÂ feel can be enriched with Large Language Models like GPT-3.5 and GPT-4.â€
Donâ€™t you have many Excel workbooks that can be improved with Generative AI?
Now imagine how it would feel if you:
Were able to create AI-infused Excel workbooks as quickly and confidently as you create normal workbooks.
Can help your colleagues, peers, and managers ai-infuse their workbooks, too.
Can talk about your portfolio of AI solutions during a job interview or a pay raise negotiation.
Know you can leverage GPT-3.5 or GPT-4 when dealing with a challenging task in Excel.
In this course, I distilled all the strategies, techniques and skills that I acquired over the last months of using ChatGPTÂ in ExcelÂ into an easy-to-follow, step-by-step course.
In this course, you will:
Learn techniques required to integrate ChatGPT with your Excel workbooks.
Solve lab exercises and play with examples to gain hands-on experience.
Learn how ChatGPTâ€™s capabilities can be used in Excel (hint: Itâ€™s not only about content generation).
Implement simple techniques and combine them to create more complex solutions.
Learn basic and advanced prompt engineering techniques for Excel.
LearnÂ about some advanced Excel techniques like LAMBDA along the way.
In short: You will do AI Engineering right within Excel.
Most videos, articles, and courses about Excel and ChatGPT cover how you can use ChatGPT to generate Excel formulas, or extract data from Excel sheets. This course is different:
**You'll learn how to build solutions with ChatGPT in Excel.
The lectures in this course are complemented by examples and exercises, since learning by doing is the best and most fun way to learn.
In addition, you can use the example workbooks as building blocks for your own solutions. The examples include a Chat Sheet for chatting with ChatGPT in your excel workbooks, an AI driven example data generator, and a flash fill function powered by ChatGPT.
Enrol today to level up your Excel skills and become an "Excel AI Engineer"!
For additional information including information about refunds and complaints, please refer to the Udemy Terms of Use**, which is linked from the footer of this page.
Who this course is for:
Excel users who want to "AI infuse" their workbooks.
ChatGPT users interested in automating their prompt flows.
Employees, and students who want to gain in-demand AI Engineering skills.

User Reviews

Rating

average 0

Total votes0

Focused display

I am a Cloud Services Solution Designer at T-Systems International GmbH with many years experience in creating IT solutions for large enterprises. I started with SAP consulting and IT outsourcing and now focus on cloud computing, Kubernetes, and Generative AI. I am passionate about software development and created many software solutions over the years, mostly with Python but sometimes, a good spreadsheet is all it takes. I studied Communication and Marketing at the University of Arts, Berlin and worked at Schering AG, Hoechst Schering AgrEvo GmbH and Debis Systemhaus GmbH.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.