Name: Using Excel Functions and Macros (VBA Code) with Chat GPT
Price: 8250 KRW

Are you finding Excel work complicated and time-consuming?

Excel is essential for office work

[VOD] Excel functions and macros (VBA code) using Chat GPT

Meet me.

It will be a reliable assistant for your Excel work.

▣ Why did you apply Chat GPT to Excel work?

I teach Level 1 computer skills at a training institute and also lecture on practical Excel for employees of institutions and companies.

Excel is essential for students who are obtaining certifications, working in the workplace, or working in organizations and companies.

Most people will only have a partial understanding of the Excel functions they need for their work.

As my work becomes more complex and numerous, I begin to feel that my existing knowledge of Excel is insufficient.

How do you solve this situation?

Most people search the internet, look on YouTube, or even email me to inquire about it.

But this method doesn't solve my problem immediately.

It takes time to search and by the time I see the email late, it's usually past the time it should have been resolved.

I've always felt sorry about this part

What are some ways to provide immediate help when needed?

I usually use Chat GPT a lot. Wouldn't it be good to apply Chat GPT to Excel?

So I explained to Chat GPT what I needed to do and asked about the Excel functions I needed.

Chat GPT provides more accurate answers than you might think and even provides helpful instructions on how to use it.

Among the various Excel functions, I was especially helped with using functions and working with macros (VBA code).

If you're having trouble with Excel functions and macros, Chat GPT could be of great help.

This is how the Excel function and macro (VBA code) using [VOD] Chat GPT were created .

How about watching this video and following along to use Chat GPT in your Excel work?

▣ Then, please tell me specifically in which cases Chat GPT is helpful.

1. If you have ever searched the Internet or asked a colleague about a function or feature you are unfamiliar with while working on Excel, now is the time to ask Chat GPT.

Chat GPT will give you detailed instructions on how to do this, so just follow them.

For example, if you are unsure about which function to use, Chat GPT will tell you the appropriate function to use by asking a question that fits your work situation. Then, you can simply copy and paste the function that it tells you.

Solve the various problems you encounter in your work with Chat GPT. This will shorten your work time and reduce the number of times you feel sorry for your colleagues or acquaintances because of Excel.

[Example of function operation]

Task situation: I need a function that calculates a value based on several conditions.

Chat GPT Questions:

"How do I write a formula that returns different results based on conditions?
For example, if the value in column B is 'regular member', I want to sum the value in column J, and if it is 'non-member', I want to sum the value in column K."

Chat GPT's answer:

2. If there is something repetitive when working with Excel, ask Chat GPT to create VBA code for you.

Did you know that you can write VBA code in Excel?

What if you need to perform a simple, yet infinitely repetitive task on large amounts of data?

For example, what if you need to insert flights intermittently into over 1,000 data points? Well... you'll have to give up on leaving work on time.

In this case, VBA code is the answer. Writing and executing VBA code will complete the task in less than a minute.
But I don't know VBA code....

Don't worry~~

We have ChatGPT

Even if I don't know VBA code, I can tell Chat GPT what I want to do and it will quickly create VBA code for me.

[Example of VBA code operation]

Task situation: I need to change the background color of cells in column B with values greater than 100 to yellow.

Chat GPT Questions:
Please create a VBA code to change the background color of cells in column B with values greater than 100 to yellow.

Chat GPT's answer:

▣ So, how can we use Chat GPT effectively?

You need to be good at asking questions (prompting).

Generative AI like Chat GPT produces different results depending on the question, so it requires technology to ask appropriate questions.

Wait a minute!!!

I'm not sure how to ask the question?

Don't worry!!!

In this e-book, Eunhee will teach you how to ask effective questions in your Excel work to get the answers you want. By following the example questions in the e-book, you'll learn how to ask questions that will yield the answers you want.

[Example questions]

▣ Is there anything I need to prepare to use Chat GPT?

1. Please prepare Excel 2016 or higher version.

2. First, sign up for Chat GPT and log in. (Chat GPT 4o free version)

https://openai.com/index/chatgpt/

3. Download the attached Excel example.ZIP file and unzip it to a suitable location.

4. Excel functions and macros (VBA code) using Chat GPT. You can download the PDF and display it on your screen, or print it out and use it as a textbook.

▣ These are reviews from people who have used Chat GPT in Excel first.

▣ Can you provide an example of how to use Chat GPT for Excel work in the e-book PDF provided with VOD?

▶ Example of using Chat GPT with actual nested IF functions

▶ Example of using Chat GPT to add a break line when the value changes VBA code

▶ In addition to the situations illustrated above, the PDF e-book contains examples of functions and VBA codes that can be used in more work situations.

▣ How is VOD structured?

Lesson 1: Preparing for practical use of Chat Gpt in Excel and explaining how to ask good questions

Lesson 2 explains how to ask Chat Gpt questions about Excel functions and apply the answers to Excel.

When creating a macro for a repetitive Excel task in Lesson 3, Chat Gpt will create a VBA code for you. Then, you will learn how to create a macro button in Excel and run that code.

▣ Frequently Asked Questions Q&A

Q. Is this a course that non-majors can also take?

Yes. Excel is a widely used program for all types of work, so it would be useful for anyone, regardless of major or non-major, to learn it.

Q. Why should I learn Excel functions?

Learning functions in Excel will allow you to use them appropriately at work, increasing your work efficiency and helping you leave work on time.
In this video, you will learn how to apply functions using ChatGpt, so you can apply functions a little more easily.

Q. What is a macro?

When working with Excel, there will be repetitive tasks. If you create a macro for that repetitive task, you can quickly solve it when you run the macro later. At this time, the macro content is created as VBA code. We use ChatGpt for this VBA code.

Q. Does this lecture provide PDFs and practice examples that can be referenced by watching the video?

Yes, we also provide a PDF with detailed explanations and an Excel practice example.
If you watch the video and follow along, you will understand much faster.

Chat GPT, which I have used, feels like a good friend.

He was like a colleague and friend who would always try hard to find answers no matter how many times I asked him questions.

Because Excel work is different for each user, please be sure to follow the instructions in the e-book and video to learn how to ask questions and apply Chat GPT to effectively use Excel work.

Recommended for
these people

Who is this course right for?

Those unfamiliar with which Excel functions to use.
Assistant Managers and Managers needing advanced Excel features (analysis tasks, VBA code)
Those who draw a blank at the thought of using functions.
Need a friend good at Excel.

취업을 준비하는 학생들에게 자기계발에 도움을 주는 사무자격증을 강의하고 있습니다

그리고 직무 역량을 향상시키기 위해 직장인 대상 실무엑셀 강의를 합니다

은희쌤 클래스 대표

■ 전문 자격

직업훈련교사2급(일반총무사무) 고용노동부

직업훈련교사(정보기술운용관리)3급 고용노동부

직업훈련교사3급(일반총무사무) 고용노동부

컴퓨터활용능력 1급 대한상공회의소

ITQ정보기술전문강사(PTI) 한국생산성본부

ITQ 한글 A, 엑셀 A, 파워포인트 A, 인터넷 A 한국생산성본부

컴퓨터활용능력 2급 한국상공회의소

정보처리산업기사 한국산업인력관리공단

■ 저서

사전처럼 쏙쏙 뽑아쓰는 엑셀함수 85선 & 분석작업의 모든것(부크크 2020)

■ 강의 이력

강남구청에서 위탁한 GIT아카데미 소속으로 강남구 대치4동 정보화교실에서 OA, ITQ자격증 강의 2009.03

군포장애인복지관에서 장애인, 어르신 대상으로 OA, ITQ자격증 강의 2011.03

금천구청에서 위탁한 한빛전산 소속으로 금천구청 전산교육장에서 OA 강의 2012.03

서대문장애인복지관에서 장애인, 어르신 대상으로 OA, ITQ자격증 강의 2013.03

화성유앤아이센터(여성비젼센터)에서 컴퓨터활용능력2급, ITQ OA 마스터 과정을 직장인, 일반인 대상으로 강의 2015.01

경기직업교육센터에서 실업자 직업훈련과정으로 컴퓨터활용능력 2급, ITQ OA 마스터과정 강의 2015.03

그린컴퓨터아카데미에서 실업자 직업훈련과정으로 컴퓨터활용능력 1급, 2급, ITQ OA 마스터과정 강의 2016.04

사무행정부문 이수자 평가 "A" 취득 2018. 12

그린컴퓨터아카데미 스타 강사 수상 2020.10

인프런에서 실무엑셀, 자격증 강의 판매 2022.03

[은희쌤 클래스] 취업 자격증 전문 인강사이트 개설 2022.09

[마포청년나루] 청년 취업 역량 ITQ 엑셀 특강

Using Excel Functions and Macros (VBA Code) with Chat GPT

What you will learn!

Are you finding Excel work complicated and time-consuming?

Excel is essential for office work

[VOD] Excel functions and macros (VBA code) using Chat GPT

Meet me.

It will be a reliable assistant for your Excel work.

▣ Why did you apply Chat GPT to Excel work?

How do you solve this situation?

But this method doesn't solve my problem immediately.

What are some ways to provide immediate help when needed?

How about watching this video and following along to use Chat GPT in your Excel work?

▣ Then, please tell me specifically in which cases Chat GPT is helpful.

1. If you have ever searched the Internet or asked a colleague about a function or feature you are unfamiliar with while working on Excel, now is the time to ask Chat GPT.

2. If there is something repetitive when working with Excel, ask Chat GPT to create VBA code for you.

Don't worry~~

▣ So, how can we use Chat GPT effectively?

Wait a minute!!!

Don't worry!!!

▣ Is there anything I need to prepare to use Chat GPT?

▣ These are reviews from people who have used Chat GPT in Excel first.

▣ Can you provide an example of how to use Chat GPT for Excel work in the e-book PDF provided with VOD?

▣ How is VOD structured?

▣ Frequently Asked Questions Q&A

Q. Is this a course that non-majors can also take?

Q. Why should I learn Excel functions?

Q. What is a macro?

Q. Does this lecture provide PDFs and practice examples that can be referenced by watching the video?

Chat GPT, which I have used, feels like a good friend.

Recommended for
these people

Hello
This is

Curriculum

Reviews

dmsgml1030's other courses

Similar courses

Using Excel Functions and Macros (VBA Code) with Chat GPT

What you will learn!

Are you finding Excel work complicated and time-consuming?

Excel is essential for office work

[VOD] Excel functions and macros (VBA code) using Chat GPT

Meet me.

It will be a reliable assistant for your Excel work.

▣ Why did you apply Chat GPT to Excel work?

How do you solve this situation?

But this method doesn't solve my problem immediately.

What are some ways to provide immediate help when needed?

How about watching this video and following along to use Chat GPT in your Excel work?

▣ Then, please tell me specifically in which cases Chat GPT is helpful.

1. If you have ever searched the Internet or asked a colleague about a function or feature you are unfamiliar with while working on Excel, now is the time to ask Chat GPT.

2. If there is something repetitive when working with Excel, ask Chat GPT to create VBA code for you.

Don't worry~~

▣ So, how can we use Chat GPT effectively?

Wait a minute!!!

Don't worry!!!

▣ Is there anything I need to prepare to use Chat GPT?

▣ These are reviews from people who have used Chat GPT in Excel first.

▣ Can you provide an example of how to use Chat GPT for Excel work in the e-book PDF provided with VOD?

▣ How is VOD structured?

▣ Frequently Asked Questions Q&A

Q. Is this a course that non-majors can also take?

Q. Why should I learn Excel functions?

Q. What is a macro?

Q. Does this lecture provide PDFs and practice examples that can be referenced by watching the video?

Chat GPT, which I have used, feels like a good friend.

Recommended for these people

HelloThis is .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

Curriculum

Reviews

dmsgml1030's other courses

Similar courses

Recommended for
these people

Hello
This is