ChatGPT × Excel: Function & Macro Master Challenge 5th Batch

“Do I have to do this by hand every time?”

“Is there a way to handle this automatically?”

When processing tasks with Excel, thoughts like these are bound to cross your mind at least once.

However, while you might know a bit about functions, macros are difficult, and even when you search, it's not easy to find an answer that perfectly fits your specific task.

▣ Why apply ChatGPT to Excel tasks?

Excel is an essential tool for practitioners in institutions and corporations. Most people likely only have a partial understanding of the
Excel functions required for their specific tasks. However, as work becomes increasingly complex and demanding, you may begin to feel that your current Excel knowledge is insufficient.

In times like these, how do you solve the problem?

Most people will search the internet, look through YouTube, or check Excel books

However, this method does not solve my problem immediately

It takes time to search, and even if you find something, it is not easy to find an answer that perfectly fits your specific task.

What are some ways to get immediate help whenever it's needed?

What if I apply ChatGPT to Excel?

So, I explained the tasks I needed to do to ChatGPT and asked about the Excel functions I required, and

ChatGPT provides more accurate answers than expected and even kindly explains how to use them.

Among various Excel features, I received a lot of help especially with using functions and macro tasks (VBA code).

What was created as a result is [VOD] Excel Functions and Macros (VBA Code) Using ChatGPT .

This challenge is an automation challenge designed to immediately apply Excel functions and macros to practical work using ChatGPT.

The focus is not on 'how to use Excel better,' but on how to make you do less Excel work.

▣ 'ChatGPT × Excel: Function & Macro Master Challenge' The course consists of the following steps:

The lecture is not just for passive watching, but follows a structure of Mission → Practice → Completion → Feedback.

Starting with how to prompt ChatGPT, we will solve common functional problems encountered in practice,
and even go as far as creating macro codes together with ChatGPT.

It's okay if you don't know how to code.
What matters is how you explain your tasks and derive solutions.
Through this challenge, the barrier that "macros are only for experts" will disappear.

▣ How to perform the mission

Missions are prepared below the basic functions and macro lectures.
Read the mission description, download the mission attachment, solve it according to the instructions, and submit it.

▣ Receive professional feedback from Teacher Eunhee

By receiving feedback, you can identify shortcomings or habits that are difficult to notice on your own, and find faster solutions through someone else's perspective rather than struggling alone.
Furthermore, positive feedback builds confidence, while advice on areas needing improvement provides motivation for growth.
In other words, you can experience a sense of accomplishment by reinforcing your strengths and supplementing your weaknesses.
Through Teacher Eunhee's meticulous feedback on your submitted missions, you can fill in your own gaps.

The photo below is an actual example of feedback from a macro mission during the challenge missions

▣ Then please tell me specifically in which cases ChatGPT is helpful

1. If you used to search the internet or ask colleagues about Excel functions or features you didn't know while working, now ask ChatGPT.

ChatGPT provides detailed instructions on what to do, so you can simply follow along.

For example, when you are unsure which function to use, if you ask a question that fits your specific task, ChatGPT will suggest the appropriate function. Then, you can simply copy and paste the provided function.

Solve various problems you encounter in practice with ChatGPT. This will shorten your work hours and reduce the need to feel sorry to colleagues or acquaintances because of Excel.

[Example of Function Task]

Task Situation: A function is needed to calculate values based on multiple conditions.

ChatGPT Question:

"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 values in column J, and if it's 'Non-member', I want to sum the values in column K."

ChatGPT's Answer:

2. If there are repetitive tasks in Excel, ask ChatGPT to create a VBA code for you.

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

What if you have to perform simple but infinitely repetitive tasks on a large amount of data?

For example, what would you do if you had to insert blank rows throughout more than 1,000 pieces of data? Well... you'd probably have to give up on leaving work on time.

In such cases, VBA code is the answer. If you use VBA code to execute it, it will be finished in less than a minute.
But what if I don't know VBA code....

Don't worry~~

We have ChatGPT.

Even if you don't know VBA code, if you tell ChatGPT the task you want to do, it will whip up the VBA code for you in no time.

[VBA Code Task Example]

Task Situation: I need to change the background color to yellow for cells in column B where the value is greater than 100.

ChatGPT Question:
Please create a VBA code that changes the background color of cells in column B to yellow if their value is greater than 100.

ChatGPT's Answer:

▣ Is there anything I need to prepare to use ChatGPT?

1. Please prepare Excel 2016 or a later version.

2. Sign up for ChatGPT first and log in. (ChatGPT free version)

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

3. Please download the Excel Examples.ZIP file from the attachments and extract it to a suitable location.

4. It is recommended to download "Excel Functions and Macros (VBA Code) using ChatGPT.PDF" and either keep it open on your screen or print it out to use as a textbook.

▣ Reviews from those who have already used ChatGPT for Excel
     You can do it too

These are the reviews for the challenge.

▣ What changes after the challenge

Instead of feeling lost in front of Excel, you will start thinking, “I can just ask ChatGPT this way.”

Repetitive tasks are replaced with automation, and Excel is no longer a tool that eats up your time, but a tool that brings your clock-out time forward.

🎁 Course Benefits

• You can ask questions at any time during the course → The instructor will answer them personally

• When you write a course review, you will receive the “Excel Tips for Increasing Work Efficiency PDF (100 pages)” e-book along with practice exercises.

The ChatGPT I've used feels like a good friend.

It felt like a colleague and a friend who always tries their best to find answers, no matter when or how many times I ask.
And when I asked questions and applied them using actual work examples, the functions and macro problems I was stuck on began to be solved quickly. In particular, the sense of accomplishment I felt when completing automation tasks that I wouldn't have dared to try alone was truly great.
The biggest change wasn't just that I became better at Excel, but that the way I approach Excel work itself has changed.
Now, whenever I see a repetitive task, my first thought is, "I can automate this with ChatGPT."

Since Excel tasks vary for every user, please make sure to follow the instructions in the e-book and videos on how to prompt and apply ChatGPT effectively for your Excel work.

Stop struggling with Excel tasks on your own;
now, complete them from start to finish with ChatGPT.
This challenge will be the starting point for changing the way you work.