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.
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!
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!
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
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 .
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.
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,233
Learners
592
Reviews
138
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
16 lectures ∙ (3hr 18min)
Course Materials:
All
58 reviews
4.9
58 reviews
Reviews 1
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 5
∙
Average Rating 4.4
5
Thật sự rất tuyệt vời. Khả năng truyền đạt nằm trong số ít những bài giảng tôi từng nghe. Lần này tôi đã đăng ký bài giảng này và bài giảng 'Tăng tốc công việc 100 lần', lẽ ra tôi nên đăng ký cả các bài giảng mới nhất khác nữa 😭. Mặc dù chuyên ngành là tin học nhưng tôi không quen dùng Excel nên đã đăng ký, tôi sẽ nghe hết trong dịp nghỉ lễ.
Reviews 1
∙
Average Rating 5.0
Reviews 2
∙
Average Rating 5.0
$22.00
Check out other courses by the instructor!
Explore other courses in the same field!
![[Đạt ITQ Excel A chỉ trong một lần] Hoàn thành sau 3 ngày강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
![[Tập] Excel + Python (cơ bản)강의 썸네일](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?f=avif&w=420)
![[Dành cho người mới bắt đầu] Trực quan hóa dữ liệu bắt đầu với Power BI강의 썸네일](https://cdn.inflearn.com/public/courses/327055/cover/455b54c1-3e63-439b-9b60-5d12e12bc303/PowerBI-001)
![[Tự động hóa công việc bằng MS RPA miễn phí] Power Automate Desktop Essentials강의 썸네일](https://cdn.inflearn.com/public/courses/329655/cover/8364da63-535b-4613-9b02-3dcdfc21791d/329655-eng.png?f=avif&w=420)
![[Sửa đổi năm 2024] Đây là tự động hóa Hangul thực sự [Cơ bản]강의 썸네일](https://cdn.inflearn.com/public/courses/335093/cover/830eee3a-faa8-4d1b-be61-67bbbe75de9f/335093.png?f=avif&w=420)
