Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Applied AI

/

Utilize AI

ChatGPT × Excel Practical Application: Easy Start to Work Automation for Everyone

Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

10 learners are taking this course

  • iexceller
AI 활용법
Excel
VBA
실습 중심
ChatGPT

What you will learn!

  • Beginner-to-intermediate user, somewhat familiar with Excel functions, but struggles with formulas.

  • Professionals using ChatGPT to create and utilize work-related macros and VBA code.

ChatGPT & Excel Advanced Skills Master

In this course, you will learn advanced techniques that can be applied directly to real-world situations, including Excel functions, formulas, and VBA automation, using ChatGPT .

  • Maximize efficiency in complex data processing, report creation, and automation of repetitive tasks.

  • It can be immediately applied in a variety of fields such as office work, data analysis, management support, accounting, and education.

Lecture Outline

ChatGPT meets Excel, changing the landscape of work!

This course is designed to help you master Excel functions, formulas, and even VBA automation at once by utilizing ChatGPT's generative AI technology . Beyond simply learning the fragmentary functions of Excel or ChatGPT, you can acquire practical skills to quickly and accurately solve complex tasks with ChatGPT.

  • You know a lot of Excel functions, but have you ever had trouble writing formulas that combine multiple functions?

  • Have you ever wanted to try VBA automation but don't have the courage to do so?

  • Have you ever wondered how you can use ChatGPT in your Excel work?

This one lecture is enough.

Learning Objectives

  • Develop the ability to create and edit Excel functions, formulas, and VBA codes needed for work using ChatGPT.

  • Learn practical skills to automate repetitive tasks to increase work speed and efficiency .

  • Take a leap forward as an Excel expert by practically incorporating AI into your work.

  • Develop AI-based problem-solving capabilities to solve and improve problems in functions/formulas/automation on your own.

5 Features of this Course

  1. Thoroughly practice-oriented! — Contains only examples that can be applied immediately in the workplace.

  2. Practical application of ChatGPT — Rather than just explanations or theories, we guide you through the actual prompts you enter into ChatGPT.

  3. Absolutely easy! — Nested functions, conditional calculations, advanced lookups, and more are easily solved with AI.

  4. Complete mastery of VBA automation Learn step-by-step from macros to practical examples to automate your work.

  5. A two-birds-with-one-stone lecture that will make you strong in both Excel and AI — a practical combination lecture of advanced Excel functions and ChatGPT.

5 Features of this Course

Section 1:

  • Summary of essential concepts you need to know when using generative AI

  • How to effectively ask ChatGPT for Excel formulas

  • How to create an Excel formula even if you don't know exactly what to do

Section 2:

  • Practical example of creating complex multi-conditional formulas with ChatGPT

  • How to write and improve advanced lookup functions

  • How Excel processes data and how to write reports

Section 3:

  • Understanding the basic structure and concepts of macros and VBA


  • How to request and modify VBA code from ChatGPT

  • Excel VBA Automation Examples That Can Be Applied Immediately to Your Work

Who created this course

  • CEO of iExceler.com, Microsoft Excel MVP, Excel programmer, author

  • He has served in various positions, including Amorepacific Group Strategy Team Leader, Innovation Team Leader, SKINFOOD CFO, and Korea National Open University Professor (lectured VBA for 4 years at Prime College Industrial Engineering Department).

  • I have been involved in various Excel & VBA related activities such as winning the Microsoft Excel Template Contest, Microsoft Community Star Awards, and being selected as Microsoft MVP.

  • I have been running "iExceler.com" for 25 years and also provide online lectures on the YouTube channel "ExcelerTV."

  • He has written about 10 books, including <ChatGPT + Excel Work Automation Essentials>, <Copilot + Excel Work Automation Essentials>, <Excel Essentials>, and <Excel VBA Power Coding Essentials>, and has contributed to various media outlets, including the computer magazine <Monthly PC Love>.

Do you have any questions?

Are you still hesitating to take the course? Read the following questions and answers to decide!

Q1. I'm a beginner in Excel. Will I be able to follow along?

Do you have a headache just hearing the function names? Don't worry! This lecture starts with 'How to ask ChatGPT smartly'. I will guide you step by step on how to work like a professional with the power of AI even if you don't know Excel well (of course, the more you know about Excel, the better you can use ChatGPT).

Q2. I have already taken many Excel lectures and am using them well. Should I take this lecture?

The more advanced you are, the faster you learn ('Oh, if I ask ChatGPT to do this, it'll take 10 seconds...'). If you want to save time, write cleaner formulas, and easily learn VBA automation, it's definitely worth listening to.

Q3. How far can I learn ChatGPT prompts?

Just give us a few simple prompt examples and that's it? No! We'll teach you how to "ask" and how to "use" them so that you can apply them to your actual work.

Q4. Can it be applied directly to practice?

Yes, this course is full of "paste-ready examples". It is designed to be a " learn-and-use " course that covers reporting automation, conditional calculations, advanced functions, and repetitive tasks.

Things to note before taking the class

Learning Materials

  • Examples that you can practice while watching the lecture are added to each video.

  • Some lectures may not have example files due to their nature.

Player Knowledge and Notes

  • This course is intended for beginner-intermediate Excel users who want to use ChatGPT to work efficiently.

  • The lecture will proceed on the assumption that you are a ChatGPT member. You can attend the lecture even if you are not a ChatGPT member, but it is more convenient to sign up for membership by referring to the Internet, etc.

  • The ChatGPT screen layout and format may change without notice depending on OpenAI's internal circumstances. You can follow along without difficulty by focusing on the prompt window and the response window.

  • Due to the generative nature of ChatGPT, results may vary each time even when similar or even identical prompts are used.

Recommended for
these people

Who is this course right for?

  • A person who wants to properly utilize ChatGPT in practical work

  • Someone who wants to build various work-related solutions with ChatGPT

Hello
This is

반갑습니다. 권현욱(엑셀러)입니다.

업무 효율화를 지향하는 모든 분들을 위한 솔루션 프로바이더가 되겠습니다.

 

  • 현재: 아이엑셀러 닷컴 대표

  • 현재: 엑셀 프로그래머 솔루션 프로바이더 작가

  • 현재: 유튜브 크리에이터 채널명: 엑셀러TV

  • 현재: Microsoft Excel MVP

  • 이전: 아모레퍼시픽 그룹전략팀장, 혁신팀장, 기획팀 부장

  • 이전: 스킨푸드 최고재무책임자(CFO, 상무), 경영지원 이사

  • 이전: 한국방송통신대 교수 | 프라임칼리지 산업공학과

  • 이전: 삼성SDS 멀티캠퍼스 튜터

  • 이전: 한국정보문화진흥원 '배움나라' 튜터, 검수위원

Curriculum

All

12 lectures ∙ (4hr 16min)

Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

$63.80

iexceller's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!