
Complete mastery of Excel macros and VBA from basics to practical use
onwings
Automate complex tasks in a snap! Excel macros and VBA, from basics to practical use!
중급이상
Business Productivity, Excel, VBA
Learn Excel most efficiently in a short period of time by creating an Excel report used at work in a project format.
Processing downloaded data to create a production management report for each product
Create a report analyzing the status of consumer claims received
Create a monthly inventory report to check inventory at a glance
Create business meeting minutes that automatically fill in the format just by entering data
Create a shipment status table by supplier by extracting only unique data
Create a bid summary report by editing merged cells
Create a report analyzing the results of a customer satisfaction survey
Create a dashboard report that analyzes production status by process
With 8 practical projects
Survival Excel for Office Workers Who Leave Work Early! 📈
This course is designed to help you learn essential Excel functions in a short and efficient manner, while directly working with Excel reports used in the workplace. It includes eight practical documents and 15 practical tips from the instructor .
This course focuses on the essentials for those who hold Excel certification but struggle to understand how Excel is used in the workplace or what essential Excel features are essential. By mastering all the content covered in this course, you can confidently claim to be proficient in Excel at work.
The instructor's practical know-how goes beyond learning the functions and presents a perspective on how to use Excel properly, easily, and quickly, incorporating the instructor's 20 years of practical and teaching know-how.
💡 Lecture Point
I have an Excel certificate, but
Job seekers who don't know the practical aspects
I know the basics of Excel, but
Office workers who are having difficulties with their work
As an experienced person, I have Excel around me.
Office workers who are embarrassed to ask
Excel skills
Office workers who want to upgrade
"It's a hassle to enter data and format it every time."
"I want to write a differentiated and sophisticated report."
"I want to extract only the unique data and calculate the total by group."
✏️ I'll show you how to automatically format data when entering it, create dashboard reports, and use dynamic functions!
By quickly processing raw data with Power Query and creating pivot tables, you can avoid repetitive tasks even when data is updated daily.
The list of claims received can be analyzed from various angles through Excel reports, which are aggregated using functions and visualized in charts and display formats.
Create reports that allow you to manage inventory by business location and item at a glance using daily updated incoming and outgoing data.
Create a list by extracting unique data using just one UNIQUE dynamic array function, and create a table that aggregates shipment quantities using the SUMIFS function and conditional formatting.
Create dynamic reports that analyze performance by branch for two years using aggregated customer satisfaction survey data stored across multiple sheets.
Create dynamic dashboard reports that allow you to see the production status of each product at a glance, by line and process.
Q. I have an Excel certification. Do I need to learn company practical skills separately?
The Excel skills you learn in an Excel certification program are vastly different from the Excel skills you use in your actual work. Furthermore, no one teaches you Excel once you join the company. You have to learn it on the job.
Q. Will taking this course help me use Excel effectively at work?
This course will give you a firsthand experience of the Excel skills you'll learn while working in a company and facing real-world challenges. Therefore, once you master the content of this course, you'll be able to immediately begin working at your company without fear.
Q. What types of work examples are available?
We have prepared a variety of reports that are frequently used in general office work, marketing, purchasing/production, and customer service.
Q. I want to create my own report that is more unique than the Excel report format that the company always uses.
How about dashboard reports? Using pivots, slicers, and pivot charts, you can create dynamic dashboard reports.
👤 Notes before taking the course
Who is this course right for?
New employees who need to learn practical Excel before joining the company for an internship
Office workers who know the basics of Excel but have difficulty applying it in practice
An office worker who is embarrassed to ask people around him about Excel
Office workers who want to get better at Excel and upgrade their skills
A job seeker who has Excel certification but doesn't know the practical skills
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)
All
40 lectures ∙ (5hr 16min)
Course Materials:
All
6 reviews
4.2
6 reviews
Reviews 15
∙
Average Rating 2.9
Reviews 9
∙
Average Rating 4.8
Reviews 3
∙
Average Rating 4.3
Reviews 2
∙
Average Rating 5.0
5
After Corona, I have been taking Excel lectures here and there. Among them, I can say that your lectures are by far the best. The lectures go straight into my ears and I understand them well. Thank you.
Thank you~^^ I hope that learning Excel was helpful. If you encounter any problems while using Excel for work in the future, please ask questions even if they are not related to the lecture content. We will think about it together and help you.
Reviews 1
∙
Average Rating 4.0
$50.60
Check out other courses by the instructor!
Explore other courses in the same field!