This course provides 100% hands-on experience by explaining which functions and features of Excel can be used to solve tasks most quickly and efficiently in these cases through examples used in actual workplaces.
Improve your Excel skills
Acquire data processing and visualization skills
Learn Excel tips and features that you can immediately apply to your real-world projects.
Excel is not an optional application for office workers, but an essential one. Excel's proficiency goes beyond simply determining how well or poorly you perform your work. It now determines how easy or difficult your work is. Many Excel users, when learning a new feature, have probably found themselves wishing they'd discovered it sooner.
Excel's most effective users are those who know how to apply and use it, rather than those who simply know a wealth of features. Therefore, rather than learning every single feature, it's far more beneficial to learn a few tips from an Excel expert. This course doesn't simply explain Excel's features; it uses real-world examples to analyze Excel data and demonstrates which Excel features and functions can be used to solve tasks most quickly and efficiently. This course delivers a 100% hands-on experience.
If you are an office worker who wants to analyze Excel data while reducing work hours and increasing efficiency, you will find a solution through this course.
- First, we will explain how to quickly and accurately edit RawData downloaded from the system.
- Once the data list has been edited, use functions and pivot tables to create the desired analysis table. Finally, apply custom display formats, conditional formatting, and charts to visualize the report.
Kim Kyung-ja
Comppeople CEO, IT professional instructor, http://blog.naver.com/onwings
While working at the LG Electronics Learning Center, I developed a connection with IT education and am currently teaching for 20 years at LG Electronics, the Korea Standards Association, Korea Land and Housing Corporation, the National Civil Service Human Resources Development Institute, the Land, Infrastructure and Transport Human Resources Development Institute, the Korea Chamber of Commerce and Industry, Seoul National University, and the Central Training Institute, developing business innovation programs utilizing Excel VBA.
Who is this course right for?
For those who dream of becoming a data analyst
People who frequently use Excel in their work
Anyone interested in data visualization
6,307
Learners
616
Reviews
155
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
49 lectures ∙ (5hr 50min)
Course Materials:
All
91 reviews
5.0
91 reviews
Reviews 1
∙
Average Rating 5.0
5
A lecture that can make you an expert in Excel!! All I knew about Excel was the sum function and simple formulas, but I learned a lot through this lecture. In particular, I was able to practice problem-solving methods several times in one lecture, and practice again through the project lecture, so I could embody the instructor's skills. Thank you for the great lecture. I want to listen to it again.~
Thank you for the good review~^^
Reviews 1
∙
Average Rating 5.0
5
I highly recommend this lecture, which is 100% practical!! I listened to the lecture very well. The explanations were smooth, and it was organized efficiently without unnecessary parts, so I didn't get bored.
I think the best evaluation is that the lecture is practical and not boring~ㅎㅎ Thank you~^^
Reviews 5
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
5
When I first started, I thought I would only listen to the first lecture since it was the beginning, but I ended up listening to the entire second section in no time! In fact, when I watch Excel lectures, the functions are explained well, but there are many experiences where it is not immediately applicable to practical use. I think that the explanation is concise and the content is organized in a way that is consistent with practical use. I am looking forward to learning the functions that I have been using vaguely and through trial and error properly through this opportunity and reducing wasted time. I think I am addicted to the instructor's unique '~입니다' tone of voice *_*! Great lecture instructor!
I was touched~^^ I can feel that you put your heart into every single letter of your review. (❁´◡`❁) And, I didn't know, but when I listened to the video I recorded, I saw that you say ~ a lot when you give online lectures. Haha
Reviews 1
∙
Average Rating 5.0
5
The explanation is also slow and repetitive and good!! The explanation is also slow and repetitive and the curriculum is good!! I've listened to almost 80% of it now and my work speed has improved a lot~~ This is a really good course for beginners to intermediate level Excel data editing I recommend it!!
It's great news that your work speed has improved~ I think it's a good idea to take the class repeatedly so that you don't forget what you've learned.
Limited time deal ends in 5 days
$26.40
22%
$34.10
Check out other courses by the instructor!
Explore other courses in the same field!
![[Episode] Excel + Python (Basic)강의 썸네일](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?f=avif&w=420)
![[Pass ITQ Excel A in One Go] in 3 days강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
