Chat GPT로 엑셀함수와 매크로(VBA코드) 활용하기
은희쌤
Excel 작업이 복잡하고 시간이 많이 소요되시나요? 사무업무에 필수인 엑셀 [VOD] Chat GPT를 활용한 엑셀 함수와 매크로(VBA 코드)을 만나보세요. 여러분의 엑셀 작업에 든든한 비서가 되어줄 것입니다.
Basic
Excel, functions, ChatGPT
[Pass ITQ Excel A in One Go] in 3 days
Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.
What you will learn!
You can understand the overall functions of Excel by solving various problems by type.
It is easy to acquire ITQ Excel because it provides detailed solutions to past exam questions by type.
Career Enhancement Project Part 1,
Let's complete ITQ with Excel! 💡
ITQ Excel, that's what I want to know.
ITQ Excel
It is a nationally recognized qualification certificate administered by the Productivity Headquarters.
A certificate that certifies Excel skills essential for office work.
It is easier to obtain than other certifications because it is presented in the form of practical work-based questions without a written exam and the passing criteria are set, and you pass with a grade of A (400 points or more) , B (300 points or more), or C (200 points or more).
👩💻
Excel program features
I want to understand and utilize it
student or working person
🙋
ITQ Excel A grade
Obtained and worked as an office worker
Job seekers who want to get a job
📝 If you follow my lectures step by step, you will soon be able to
Your skills will have improved to the point where you can obtain the ITQ Excel certification.
Invest for just 3 days !!!
One day, listen to lectures and study ITQ Excel.
2 days of listening to lectures and solving function calculation problems
3 days of repeatedly solving past exam questions
After learning ITQ Excel
The resulting work 🎨
1. Create a table format and calculate values
2. Find Goal Value, Advanced Filter, Table Format
3. Sorting, subtotals, and pivot tables
4. Graph
👉 If you can do these four tasks in ITQ Excel, you can handle the entire functionality of Excel .
Since the types of questions rarely change, you can easily acquire the knowledge by solving past exam questions about 5 times .
Frequently Asked Questions 🤔
Q. Is this a course that non-majors can also take?
Yes, Excel is a program that is widely used in all types of work, so it would be useful for anyone, regardless of major or non-major, to know it.
Q. Why should I learn ITQ Excel?
By earning the ITQ Excel certification through this course, you can gain confidence in Excel and demonstrate your Excel skills when applying for a job or changing careers.
Q. Are there any notes regarding course registration?
Please prepare MS Office Excel 2016 or higher.
Introducing the Knowledge Sharer ✒️
Hello, I'm Eunhee. I hope that my knowledge of office administration, which I enjoy and excel at, can be of help to others in need. I currently teach practical office administration (Excel, PowerPoint) and office-related certifications (Computer Skills Level 1/2, ITQ) at a vocational training institute.
- Information Processing Industry Engineer
- 2nd grade vocational training instructor (general affairs, general affairs)
- Computer Proficiency Level 1 and 2
- ITQ (Korean, Excel, PowerPoint) expert instructor
Recommended for
these people
Who is this course right for?
Anyone who needs an easy-to-obtain Excel certification
Those who want to understand and utilize Excel functions
371
Learners
27
Reviews
5.0
Rating
10
Courses
취업을 준비하는 학생들에게 자기계발에 도움을 주는 사무자격증을 강의하고 있습니다
그리고 직무 역량을 향상시키기 위해 직장인 대상 실무엑셀 강의를 합니다
은희쌤 클래스 대표
■ 전문 자격
직업훈련교사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 엑셀 특강
Curriculum
All
16 lectures ∙ (6hr 5min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
2 reviews
$17.60
dmsgml1030's other courses
Check out other courses by the instructor!
![빠르게 취득하는 [5일만에 합격하는 컴퓨터활용능력 2급 실기]Course Thumbnail](https://cdn.inflearn.com/public/courses/330613/cover/820dc36f-c51d-4917-9eab-2fa9d5a291e5/330613-eng.png?f=avif&w=420)
![딱 2일만에 끝내는 [ITQ 파워포인트 A 한방에 합격하기]Course Thumbnail](https://cdn.inflearn.com/public/courses/330108/cover/a0a7ac8c-cbd6-4acf-9cad-494ee28e1faf/파워포인트)
![딱 2일만!! [ITQ 한글 A 한방에 합격하기]Course Thumbnail](https://cdn.inflearn.com/public/courses/330083/cover/776d0ef6-1cf9-40c6-bb01-969283a0ee5e/ITQ한글썸네일(인프런).jpg?f=avif&w=420)
![상사에게 인정받는 [알아두면 쓸모 있는 엑셀 팁(1)]Course Thumbnail](https://cdn.inflearn.com/public/courses/329430/cover/2672867b-3832-4d62-b4e9-9904c723e7d0/엑셀팁(인프런).jpg?f=avif&w=420)
![업무 자동화 [엑셀 분석작업의 모든것]Course Thumbnail](https://cdn.inflearn.com/public/courses/329293/cover/dffc3baf-1c4d-4130-867b-628a4fd7b042/데이터분석(인프런).jpg?f=avif&w=420)
![칼퇴하고 싶나요? 그렇다면 [쏙쏙 뽑아쓰는 엑셀 함수 사전] 강의를 들어야 합니다Course Thumbnail](https://cdn.inflearn.com/public/courses/328591/cover/e6c500ab-3346-48df-84a8-b7c0876eea16/함수사전(인프런).jpg?f=avif&w=420)
Similar courses
Explore other courses in the same field!
![[한글NEO] 한번에 끝내는 문서작성 & ITQ 한글 자격증 취득Course Thumbnail](https://cdn.inflearn.com/public/courses/327670/cover/7ba4422b-6ffe-4224-b281-536e363bba71/327670-eng.png?f=avif&w=420)
![[기초]코딩 무경험자도 가능! 90분에 뽀개는 구글 시트 업무 자동화Course Thumbnail](https://cdn.inflearn.com/public/courses/331717/cover/a395d468-0688-4908-88c2-4d087f24d7b7/thumbnail.jpg?f=avif&w=420)
![[에피소드] 엑셀+파이썬(기초)Course Thumbnail](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?f=avif&w=420)
