엑셀 매크로와 VBA 기초부터 실무활용까지 완전 정복
엑셀여신
복잡한 업무 단숨에 자동화! 엑셀 매크로와 VBA 기본부터 실무까지 완벽하게!
중급이상
업무 생산성, Excel, VBA
BEST
Excel Basics: Only the core practical skills are selected and finished in 3 hours
This training course selects only the essential Excel functions that you need to know when working with Excel, so that you can learn them easily and quickly.
Reviews from Early Learners
What you will learn!
How to input and manage data types in Excel without errors
How to format tables to fit your report using cell formatting
Practical learning with examples used in real workplaces
How to reference cells to enter formulas without errors
Ability to quickly process and convert external data
Sort, filter, and subtotal required for data management
Integration and pivot tables required for summarizing and aggregating disjointed data
Learn only the key points 📌
Real practical Excel!
3 Steps to Practical Excel 🎢
Excel has so many features! It's difficult to master them all, and it's even harder to figure out which ones are truly useful. This course focuses on the essential Excel features you need to know for your work, so you can quickly and easily master them. If you want to learn only the essential features in a short period of time, this is the perfect opportunity to get started!
This course's unique features ✨
- Rich content composition
- We've organized the content based on the most frequently asked questions from basic Excel users!
- Systematic basic concepts
- We'll lay the foundation for you to be able to solve problems you encounter while working with Excel on your own!
- Learning examples for practice
- We help you learn how to apply the basic skills you've learned in real-world work situations!
Recommended for these people! 🙋♀️
You will be able to think and solve problems on your own to get things done faster and more efficiently.
Exrin
Excel beginners who want to learn Excel from the basics
I'm writing it now
Office workers who want to learn Excel properly by using it in their work.
Save time
Those who want to learn only the functions that are frequently used in practice in a short period of time
awe
People who are afraid of working with Excel because they don't know how to solve Excel problems
Learn things like this 📚
Step 1. Basic preparation
It consists of creating tables to make them look nice and entering formulas to perform calculations . 
Step 2. Deeper Learning Through Examples
Building on what you learned in Step 1 , you'll delve deeper into practical examples used in real-world work . Even if you know Excel's functions, you won't be able to apply them if you don't know how to use them in real-world work . This step addresses that issue .
Step 3. Data Management
Learning will focus on sorting required for data management , filters to extract only the necessary data , subtotals that can aggregate by group , consolidation , and pivot tables .
A word from a knowledge sharer ☝️
Hello. This is Kim Kyung-ja.
This course was created for those who want to learn Excel but are too busy to invest the time. Simply mastering the content in this course will allow you to work with Excel without any difficulties.
Recommended for
these people
Who is this course right for?
For those who are new to Excel
Those who have not systematically studied Excel
For those who want to learn accurately, focusing on the core Excel functions required for practical work
Anyone who wants to learn how to create Excel documents efficiently
6,336
Learners
622
Reviews
156
Answers
4.9
Rating
6
Courses
김경자 / 컴피플 대표, 연성대학교 겸임교수, 엑셀여신(http://blog.naver.com/onwings)
LG전자 LearningCenter에 근무하면서 IT교육과 인연을 맺어 현재는 삼성그룹, 기아그룹, 유데미, 금융감독원, 김앤장, 국가공무원인재개발원 등에서 강의하고 있습니다. IT/정보화 교육 전문회사인 컴피플 대표이며 연성대학교 겸임교수로 재직중입니다.
<저서>
- 회사에서 통하는 엑셀 데이터 활용 분석(한빛미디어, 2025)
- 회사에서 엑셀로 살아남기 (한빛미디어, 2023)
- 엑셀 실무 함수 + 수식 (한빛미디어, 2021)
- 엑셀 실무 매크로와 VBA (한빛미디어, 2020)
- 엑셀 실무 데이터 활용+분석 (한빛미디어, 2019)
- 엑셀 2016 기본+실무완성 (북스홀릭, 2018)
- 실무통 엑셀 함수 실무 강의 (한빛미디어, 2017)
- 회사 실무에 힘을 주는 엑셀 2016 매크로와 VBA (정보문화사, 2016)
- 회사에서 바로 통하는 엑셀 데이터 활용+분석 (한빛미디어, 2016)
- 엑셀 2013 기본 실무완성 (북스홀릭, 2014)
- 키노트 & 넘버스 무작정 따라하기 (길벗, 2014)
- 엑셀 2010 매크로와 VBA (영진닷컴, 2012)
- 엑셀 2010 기본 실무완성 (북스홀릭, 2011)
- 엑셀 2007 매크로 & VBA 기본+실무 (성안당, 2009)
- 엑셀 2007 기본 + 실무 (성안당, 2007)
- 실무에 강한 엑셀 매크로와 VBA (사이버출판사, 2005)
Curriculum
All
16 lectures ∙ (3hr 18min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
71 reviews
4.9
71 reviews
de33904Reviews 1
∙
Average Rating 5.0
- 최보정
Reviews 1
∙
Average Rating 5.0
- hattman
Reviews 6
∙
Average Rating 4.5
- sawd123
Reviews 1
∙
Average Rating 5.0
- jhchoi7410
Reviews 2
∙
Average Rating 5.0
$22.00
onwings's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
![[입문자를 위한] Power BI로 시작하는 데이터 시각화강의 썸네일](https://cdn.inflearn.com/public/courses/327055/cover/455b54c1-3e63-439b-9b60-5d12e12bc303/PowerBI-001)
![[무료 MS RPA를 활용한 업무 자동화] Power Automate Desktop Essentials강의 썸네일](https://cdn.inflearn.com/public/courses/329655/cover/8364da63-535b-4613-9b02-3dcdfc21791d/329655-eng.png?f=avif&w=420)
