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.

(5.0) 수강평 95개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

Excel
Excel
Excel
Excel

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

5.0

5.0

한상윤

100% 수강 후 작성

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% 수강 후 작성

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% 수강 후 작성

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.

강의상세_배울수있는것_타이틀

  • 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.

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • For those who dream of becoming a data analyst

  • People who frequently use Excel in their work

  • Anyone interested in data visualization

강의소개.지공자소개

6,633

수강생

680

수강평

162

답변

4.9

강의 평점

6

강의_other

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)

더보기

커리큘럼

전체

49개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

95개

5.0

95개의 수강평

  • jieunkim2334님의 프로필 이미지
    jieunkim2334

    수강평 1

    평균 평점 5.0

    5

    27% 수강 후 작성

    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!

    • onwings
      지식공유자

      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

  • sangyunhan55941736님의 프로필 이미지
    sangyunhan55941736

    수강평 1

    평균 평점 5.0

    5

    100% 수강 후 작성

    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.~

    • onwings
      지식공유자

      Thank you for the good review~^^

  • fotbalher0652님의 프로필 이미지
    fotbalher0652

    수강평 1

    평균 평점 5.0

    5

    100% 수강 후 작성

    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.

    • onwings
      지식공유자

      I think the best evaluation is that the lecture is practical and not boring~ㅎㅎ Thank you~^^

  • concepternola1801님의 프로필 이미지
    concepternola1801

    수강평 5

    평균 평점 5.0

    5

    100% 수강 후 작성

    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.

    • feelingerr1317님의 프로필 이미지
      feelingerr1317

      수강평 1

      평균 평점 5.0

      5

      100% 수강 후 작성

      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!!

      • onwings
        지식공유자

        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.

    onwings님의 다른 강의

    지식공유자님의 다른 강의를 만나보세요!

    비슷한 강의

    같은 분야의 다른 강의를 만나보세요!

    강의상세.할인문구

    $3,827.00

    29%

    $34.10