This is a challenge course where you can learn frequently used Excel functions and macros that reduce repetitive tasks all at once. Using ChatGPT, you'll learn SUM, SUMIF, SUMIFS, IF, and VLOOKUP functions to master essential calculation methods for practical work, such as sum calculations, conditional sums, and data lookups. Then, you'll create VBA code using ChatGPT to automate repetitive tasks in your work. By learning how to speed up calculations with functions and automate repetitive tasks with macros, you'll acquire practical skills that can significantly reduce work time and increase efficiency. Anyone who can use Excel at a basic level can take on this challenge, and after completing the course, you'll be able to work smarter by freely utilizing functions and macros.
7개 수업 학습
3회 미션 수행
라이브 1 회
472
Learners
55
Reviews
1
Answers
4.9
Rating
20
Courses
I am teaching office certification courses to help students preparing for employment with their self-development.
And I teach practical Excel classes for office workers to help them improve their job competencies
CEO of Eunhee-ssam Class
■ Professional Qualifications
Vocational Training Teacher Level 2 (General Administration & Office Work) Ministry of Employment and Labor
Vocational Training Instructor (Information Technology Operation & Management) Level 3 Ministry of Employment and Labor
Vocational Training Teacher Level 3 (General Administrative Affairs) Ministry of Employment and Labor
Computer Literacy Level 1 Korea Chamber of Commerce and Industry
ITQ Professional Training Instructor (PTI) Korea Productivity Center
ITQ Hangul A, Excel A, PowerPoint A, Internet A Korea Productivity Center
Computer Utilization Ability Level 2 Korea Chamber of Commerce and Industry
Industrial Engineer Information Processing Human Resources Development Service of Korea
■ Publications
85 Excel Functions to Pick and Use Like a Dictionary & Everything About Analysis Tasks (Bookk 2020)
■ Teaching Experience
Taught OA and ITQ certification courses at the Daechi 4-dong Information Education Center in Gangnam-gu as a member of GIT Academy, commissioned by Gangnam-gu Office 2009.03
Lectured on OA and ITQ certifications for people with disabilities and seniors at Gunpo Welfare Center for the Disabled, March 2011
Conducted OA lectures at the Geumcheon-gu Office Computer Training Center as part of Hanbit Computing, entrusted by Geumcheon-gu Office, 2012.03
Taught OA and ITQ certification courses for people with disabilities and seniors at Seodaemun Welfare Center for the Disabled 2013.03
Taught Computer Literacy Level 2 and ITQ OA Master courses for office workers and the general public at the Hwaseong U&I Center (Women's Vision Center) 2015.01
Taught Computer Literacy Level 2 and ITQ OA Master courses as part of the vocational training program for the unemployed at the Gyeonggi Vocational Education Center, 2015.03
Lectured Computer Literacy Level 1 and 2, and ITQ OA Master courses as vocational training programs for the unemployed at Green Computer Academy 2016.04
Obtained "A" grade in Office Administration Trainee Evaluation, Dec 2018
Awarded Star Instructor at Green Computer Academy 2020.10
Selling practical Excel and certification courses on Inflearn 2022.03
[Teacher Eunhee's Class] Launch of an online lecture site specializing in employment certifications, September 2022
[Mapo Youth Naru] Youth Employment Competency ITQ Excel Special Lecture
I teach Computer Specialist Level 1 at a vocational training institution and provide practical Excel training for institutional and corporate employees
Excel is something that students inevitably encounter when they obtain certifications and work at companies, or if they are practitioners at institutions and businesses
Most people only know parts of the Excel features they need for their work
As work becomes increasingly complex and demanding, you may find that your current Excel knowledge isn't quite enough
Most people search the internet, look on YouTube, or if they're students who learned from me, they contact me via email
It takes time to search, and if I check my email late, most of the time the deadline for resolution has already passed
I've always felt sorry about this part
I usually make good use of Chat GPT. What if I could apply this Chat GPT to Excel?
So I explained the tasks I needed to Chat GPT and asked about the necessary Excel functions
Chat GPT provides surprisingly accurate answers and even kindly explains how to use it
Among the various Excel features, I found the use of functions and macro work (VBA code) particularly helpful
If you have concerns about Excel functions and macros, Chat GPT can be very helpful
What was created this way is [VOD] Excel Functions and Macros (VBA Code) Using Chat GPT
This course is not just a lecture you listen to and finish, but is designed so you can make it 'your own' by following along with practice examples after watching the lectures and solving the given missions. It's structured as a challenge course where you can fill in your gaps through professional feedback from Teacher Eunhee
The 'ChatGPT Excel Functions and Macros Master' challenge course consists of the following stages
I learned how to apply ChatGPT to functions and create macros while taking online classes
I will perform and submit the mission on functions and macros
You'll learn how to use functions and macros in ChatGPT while receiving professional feedback
A mission is prepared below the Basic Functions and Macros lecture
Read the mission description, download the mission attachment file, solve it according to the instructions, and submit it
You can ask questions anytime during the course → The instructor will answer directly
When submitting missions 2 or more times or writing a course review, we will provide you with the "Excel Tips PDF for Improving Work Efficiency (100 pages)" e-book along with practice examples
Chat GPT provides detailed instructions on how to do it, so you can just follow along.
For example, when you're unsure which function to use, if you ask a question that fits your work situation, ChatGPT will tell you the appropriate function to use. Then you can simply copy and paste the function it suggests.
Solve various problems you encounter in your work together with ChatGPT, and you'll reduce your work time and have fewer occasions to feel sorry to colleagues or acquaintances because of Excel.
[Function Work Examples]
Task situation: We need a function that calculates values based on multiple conditions.
Chat GPT Question:
"How do I write a formula that returns different results based on conditions?
For example, I want to sum the values in column J if the value in column B is 'Regular Member', and sum the values in column K if it's 'Non-member'."
Chat GPT's Response:
Did you know that you can write VBA code in Excel?
When you need to perform simple but infinitely repetitive tasks on large amounts of data?
For example, if you need to insert flights in the middle of more than 1000 data entries, what should you do? Well..... you'll have to give up on leaving work on time.
In this case, VBA code is the answer. If you write and run VBA code, it will be done in less than a minute
But I don't know VBA code....
We have ChatGPT
Even if I don't know VBA code, if I tell Chat GPT what task I want to accomplish, it will quickly create the VBA code for me.
[VBA Code Work Example]
Task Status: Need to change the background color to yellow for cells in column B where the value is greater than 100
Chat GPT Question:
Please create a VBA code that changes the background color to yellow for cells in column B where the value is greater than 100.
Chat GPT's response:
You need to ask good questions (prompts).
Generative AI like ChatGPT produces different results depending on the question, so skills for asking appropriate questions are necessary.
I don't really know how to ask questions, you know?
Teacher Eunhee shows you how to ask questions in the e-book to get the answers you want for the Excel work you're doing. By following the example questions in the e-book, you'll learn how to ask questions to get the answers you want.
[Example Question]
1. Please prepare Excel 2016 or later version.
2. First, sign up for Chat GPT and log in. (Chat GPT 4o free version)
https://openai.com/index/chatgpt/
3. Among the attached files, download "Excel Example.ZIP" and extract it to an appropriate location.
4. You can download the "Using ChatGPT for Excel Functions and Macros (VBA Code).PDF" file and display it on your screen or print it out to use as a textbook.
▶Example of Using Chat GPT for Actual Nested IF Functions
▶Example of using ChatGPT to create VBA code that adds separator rows when values change
▶ The PDF e-book contains examples of functions and VBA code that can be used in your work, covering many more situations beyond those illustrated above.
Lesson 1: Explains how to prepare for practice and ask good questions to use ChatGPT with Excel
Lesson 2 Explains how to ask ChatGPT about Excel functions and how to apply the answers in Excel
Lesson 3 When creating macros for repetitive Excel tasks using VBA code, this explains how to have ChatGPT generate the code, then create and execute it as a macro button in Excel
Yes. Excel is a program widely used in all types of work, so regardless of your major, it will be useful for anyone to know.
Learning functions in Excel will enable you to use them in the right places for your work, increasing work efficiency and allowing you to leave work on time.
In this video, you'll learn how to apply functions using ChatGPT, making it a bit easier and more convenient to apply functions.
When working with Excel, you'll encounter repetitive tasks. If you create a macro for these repetitive tasks, you can quickly solve them later by running the macro. The macro content is created as VBA code. We use ChatGPT to help with this VBA code.
Yes, we provide detailed PDF explanations and Excel practice examples together
You can follow along while watching the videos, which will help you understand much faster
They were like a colleague and friend who always tried hard to find answers, no matter when I asked or how much I bothered them with questions.
Since Excel tasks vary for each user, I strongly recommend that you follow along with the instructions provided in the e-book and videos on how to ask questions and apply Chat GPT to Excel work
9월
14일
챌린지 시작일
2025년 9월 14일 PM 03:00
챌린지 종료일
2025년 9월 30일 PM 02:59
All
11 lectures ∙ (2hr 27min)
Course Materials:
You can learn how to ask ChatGPT questions effectively
I can apply the appropriate functions that ChatGPT suggests for the tasks I need to do to my work
ChatGPT can help you apply macro VBA code to your work
Who is this course right for?
Office workers who want to increase their Excel work speed
A workplace where you want to learn functions and macros together
Excel Users Who Want to Integrate ChatGPT into Their Work
Looking for someone who needs a friend who knows Excel well
Need to know before starting?
It would be helpful to know how to select cells, enter/edit data, and move, add, or delete sheets.
Having experience with simple functions like SUM and AVERAGE will make this even more beneficial
All
4 reviews
4.8
4 reviews
Reviews 1
∙
Average Rating 5.0
5
It was great that you taught us how to identify the tasks that need to be done first in each situation and ask AI step-by-step questions systematically. I was curious about VBA code but felt burdened about learning it from scratch, so I took this course. Thanks to the course, I'm now reviewing my personal materials and asking ChatGPT all sorts of questions to organize them!
Thank you so much for leaving such a precious review! 😊 I'm sure VBA and the new parts felt overwhelming at first, but it's truly rewarding to see that you're organizing everything step by step through the lectures and applying it directly. Especially since you're reviewing and organizing your personal materials with ChatGPT, your learning effectiveness will be doubled. I will continue to prepare examples that can be applied directly in practical work and methods to use Excel more efficiently with AI.
Reviews 2
∙
Average Rating 5.0
5
The detailed explanations through examples are very helpful for easy understanding.
Thank you so much for leaving such a warm review. 🙏 Excel functions and macro VBA can feel quite complex when you first encounter them, but I'm truly rewarded to hear that you understood them easily through the examples. Please feel free to ask anytime if you have any questions or want to learn more about any particular aspect. Once again, thank you for leaving such a valuable review, and I sincerely hope that Excel will make your work much easier. ✨
Reviews 1
∙
Average Rating 5.0
5
It was an easy-to-understand and easy-to-follow lecture! The ChatGPT tips seem like they'll be very useful in practical work :)
I feel truly rewarded to hear that you found the lecture easy to understand and convenient to follow along with. I'm especially delighted that you mentioned the ChatGPT usage tips will be helpful in your actual work. 💡 Please feel free to reach out anytime if you have any questions or want to learn more about anything while using it. I'll be cheering for your work to become much easier! ✨
Reviews 1
∙
Average Rating 4.0
4
The topic of Excel functions and macro VBA code using CHATGPT may initially seem somewhat complex, but thank you for trusting and staying with me until the end, and I will repay you with even more satisfying lectures in the future ✨
이 강의의 지난 수강평
취소 및 환불 규정
챌린지는 지식공유자가 설정한 수업 최소 정원이 충족되지 않을 경우, 폐강 안내가 고지되며 결제 내역이 자동취소됩니다.
Check out other courses by the instructor!
$13.20
![[Pass the Level 2 Computer Utilization Skills Practical Test in 5 Days]Course Thumbnail](https://cdn.inflearn.com/public/courses/330613/cover/820dc36f-c51d-4917-9eab-2fa9d5a291e5/330613-eng.png?w=420)
![[Pass ITQ PowerPoint A in One Go] in just 2 daysCourse Thumbnail](https://cdn.inflearn.com/public/courses/330108/cover/a0a7ac8c-cbd6-4acf-9cad-494ee28e1faf/파워포인트 썸네일(인프런).jpg?w=420)
![Just 2 days!! [Pass ITQ Korean A in one go]Course Thumbnail](https://cdn.inflearn.com/public/courses/330083/cover/776d0ef6-1cf9-40c6-bb01-969283a0ee5e/ITQ한글썸네일(인프런).jpg?w=420)
![[Pass ITQ Excel A in One Go] in 3 daysCourse Thumbnail](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?w=420)
![[Useful Excel Tips to Know (1)] that will get you recognized by your bossCourse Thumbnail](https://cdn.inflearn.com/public/courses/329430/cover/2672867b-3832-4d62-b4e9-9904c723e7d0/엑셀팁(인프런).jpg?w=420)
![Work Automation [Everything About Excel Analysis]Course Thumbnail](https://cdn.inflearn.com/public/courses/329293/cover/dffc3baf-1c4d-4130-867b-628a4fd7b042/데이터분석(인프런).jpg?w=420)
![Do you want to quit your job? If so, you should take the [Excel Function Dictionary] course.Course Thumbnail](https://cdn.inflearn.com/public/courses/328591/cover/e6c500ab-3346-48df-84a8-b7c0876eea16/함수사전(인프런).jpg?w=420)