ChatGPT × Excel: Functions & Macros Master Challenge 4th Cohort

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

“Is there a way to process this automatically?”

When working with Excel, you've probably had this thought at least once.

However, while you might know a bit about functions, macros are difficult, and it’s not easy to find answers that perfectly fit your specific tasks even when you search for them.

▣ Why apply ChatGPT to Excel tasks?

Excel is an essential tool for professionals in organizations and corporations. Most people likely only know the
Excel functions required for their specific tasks. However, as work becomes increasingly complex and demanding, you will begin to feel the limitations of your current Excel knowledge.

How do you solve it in times like this?

Most of you will probably search the internet, look on YouTube, or even look through Excel books.

However, this method doesn't solve my problem immediately

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

What are some ways to get immediate help when needed?

Couldn't I apply ChatGPT to Excel?

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

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 this way is [VOD] Excel Functions and Macros (VBA Code) Using ChatGPT .

This challenge is an automation challenge that applies Excel functions and macros directly to practical work using ChatGPT
automation challenge.

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

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

The course is not just for passive viewing; it is structured as Mission → Practice → Completing the Output → Feedback.

Starting with how to prompt ChatGPT, we will solve frequently used practical function problems and
even create macro codes together with ChatGPT.

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

▣ How to complete the mission

A mission is prepared below the Basic Functions and Macros lecture.
Read the mission description, download the attachment, complete it according to the instructions, and submit it.

▣ Get professional feedback from Teacher Eun-hee

Receiving feedback allows you to identify shortcomings or habits that you might not notice on your own, and you can find solutions faster through someone else's perspective than by struggling alone.
Furthermore, positive feedback builds confidence, while advice on areas needing improvement provides motivation for growth.
In other words, you can feel a sense of accomplishment by further strengthening your strengths and supplementing your weaknesses.
You can fill in your gaps through Teacher Eunhee's meticulous feedback on the missions you submit.

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

▣ Then, please tell me specifically in what cases ChatGPT is helpful

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

ChatGPT provides detailed instructions on what to do, so you can just follow them.

For example, when you're 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.

Try solving the various problems you encounter in the workplace with ChatGPT. It will save you work time and reduce the instances where you have to feel sorry to colleagues or acquaintances because of Excel.

[Function Task Examples]

Work Situation: I need a function that calculates 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 response:

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

Did you know 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 rows of data? Hmm... you'd probably have to give up on leaving work on time.

In this case, VBA code is the answer. If you run it using VBA code, it will be finished in less than a minute
But I don't know VBA code...

Don't worry~~

We have ChatGPT

Even if you don't know VBA code, just tell ChatGPT what you want to do, and it will generate the VBA code for you in an instant.

[VBA Code Work Example]

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

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

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 and log in to ChatGPT first. (ChatGPT free version)

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

3. Please download Excel Examples.ZIP from the attached files and unzip it in a suitable location.

4. Excel Functions and Macros (VBA Code) using ChatGPT.PDF: It is recommended to download this file and use it like a textbook by either viewing it on your screen or printing it out.

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

Challenge course reviews

▣ What changes after the challenge

Instead of feeling lost in front of Excel, you will start to think, “I can just ask ChatGPT about this like this.”

Replace repetitive tasks with automation, and Excel will no longer be a time-consuming tool, but a tool that helps you leave work earlier.

🎁 Course Benefits

• Ask questions anytime during the course → The instructor will answer directly.

• When you write a course review, you will receive the “Excel Tips to Increase Work Efficiency PDF (100 pages)” e-book and 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 pester them with questions.
And after asking questions and applying them to real work examples, the formulas and macro problems I was stuck on began to resolve quickly. I felt a huge sense of accomplishment, especially when I completed automation tasks that I wouldn't have even dared to try on my own.
Rather than just becoming better at Excel, the biggest change was that the way I approach Excel work itself has fundamentally 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 to use it effectively for your Excel work.

Excel tasks you used to struggle with alone,
now complete them from start to finish with ChatGPT.
This challenge will be the starting point for transforming the way you work.