Differentiated Excel data analysis and chart visualization exclusively for professionals
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.
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.~
5.0
박지웅
100% enrolled
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.
5.0
미소
100% enrolled
There are so many practical tips that you can't learn anywhere else, and I wonder what I would have done if I hadn't taken this course. Thank you for creating such a valuable course.
What you will gain after the course
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 data analysis and chart visualization unique to professionals
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.
Things to learn
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.
Helpful people
Anyone who wants to freely manipulate data and easily create desired reports
Someone who spends all day editing data downloaded from the system
Those who need hands-on training on editing and analyzing raw data and creating visualization reports
Those who know the basic functions of Excel but feel they lack the ability to apply them to work
Those who want to learn intermediate/advanced functions, pivot tables, and charts.
People who find the method of learning one by one by reading books frustrating
Note
Prepare a PC with Excel 2010 or later installed
It is based on basic knowledge of Excel.
Introduction of knowledge sharers
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.
Recommended for these people
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
Hello This is
6,606
Learners
677
Reviews
162
Answers
4.9
Rating
6
Courses
Kim Kyung-ja / CEO of Compeople, Adjunct Professor at Yeonsung University, Excel Goddess (http://blog.naver.com/onwings)
While working at the LG Electronics Learning Center, I began my career in IT education. Currently, I deliver lectures at organizations such as Samsung Group, Kia Group, Udemy, the Financial Supervisory Service, Kim & Chang, and the National Human Resources Development Institute. I am the CEO of Compeople, a company specializing in IT and information technology training, and I also serve as an adjunct professor at Yeonsung University.
- Excel Data Utilization and Analysis for the Workplace (Hanbit Media, 2025) - Surviving with Excel at the Workplace (Hanbit Media, 2023) - Excel Practical Functions + Formulas (Hanbit Media, 2021) - Excel Practical Macros and VBA (Hanbit Media, 2020) - Excel Practical Data Utilization + Analysis (Hanbit Media, 2019) - Excel 2016 Basic + Practical Completion (Booksholic, 2018) - Practical Lecture on Excel Functions for Professionals (Hanbit Media, 2017) - Excel 2016 Macros and VBA for Empowering Workplace Tasks (Jungbo Munhwasa, 2016) - Excel Data Utilization + Analysis Immediately Applicable at Work (Hanbit Media, 2016) - Excel 2013 Basic Practical Completion (Booksholic, 2014) - Keynote & Numbers Step-by-Step (Gilbut, 2014) - Excel 2010 Macros and VBA (Youngjin.com, 2012) - Excel 2010 Basic Practical Completion (Booksholic, 2011) - Excel 2007 Macros & VBA Basic + Practical (Sungan-dang, 2009) - Excel 2007 Basic + Practical (Sungan-dang, 2007) - Strong Practical Excel Macros and VBA (Cyber Publishing, 2005)
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.~
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.
There are so many practical tips that you can't learn anywhere else, and I wonder what I would have done if I hadn't taken this course. Thank you for creating such a valuable course.
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
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!!
sangyunhan55941736
![Work Automation [Everything About Excel Analysis]講義サムネイル](https://cdn.inflearn.com/public/courses/329293/cover/dffc3baf-1c4d-4130-867b-628a4fd7b042/데이터분석(인프런).jpg?f=avif&w=420)
![[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)
