BEST

Excel data utilization and analysis know-how that makes work 100 times faster

Name: Excel data utilization and analysis know-how that makes work 100 times faster
Price: 44000 KRW
Rating: 4.9 (313 reviews)

This course is not a training course that explains the functions of Excel, but a course that uses Excel examples used in actual work settings to learn which functions to apply in each situation to perform tasks most quickly and efficiently.

(4.9) 313 reviews

2,137 learners

Level Basic

Course period Unlimited

onwings

Excel

MS-Office

Excel

MS-Office

Reviews from Early Learners

4.9

5.0

정세권

100% enrolled

If you follow along one by one, it will be a great help. My original Excel skills were not that great... but my Excel skills have definitely improved. I have gained a lot. I plan to listen to it again to learn it properly to reinforce it a bit more. I recommend it.

5.0

슝슝슝

100% enrolled

Regardless of your job, it explains only the essentials that you need to know in an easy way! I highly recommend it! I like this lecture because it teaches you the 'know-how' rather than the 'hard work' of data management. Please take an Excel lecture from a professional instructor like this! A person who was famous for being good at Excel at work became famous as an Excel YouTuber and created a lecture to sell it, but I was so disappointed when I took that lecture. It was a lecture that tried to teach you too much at once. It was as if he was saying, "I know how to do all this, I know all these functions." He even teaches you the functions that are only necessary for specific jobs.. I recommend this to those who don't want to know all the functions and features of Excel.

5.0

이영화

100% enrolled

As an intern and a job seeker, I need to get a computer skills certificate. I remember a famous lecture that I attended to study computer skills. This Excel lecture is not an Excel lecture for theory, but a lecture for practical practice based on practical practice. I was amazed the whole time I was watching it. I think I will come back to listen to it again even after I get a job. A famous lecture that will give wings to your work.

What you will gain after the course

Edit RAW data downloaded from the system 100x faster
Acquire functional application techniques mainly used in writing data analysis reports.
Create quick and efficient reports using pivot tables
Create automated analysis tables that allow you to view only selected performance from a large list of data
Compare two lists, display matching items, and create a summary table
Managing Excel Big Data Using Power Query

Excel has become such an essential program that, through consistent updates, over 80% of employees at Korea's top 100 companies use it . But how many workers can truly say they're proficient at using Excel ? Knowing how to use Excel is important, but knowing how to use it is even more crucial . If you can complete a task that takes someone else two hours in under 10 minutes, then you're a true Excel pro .

This course is not a training course that explains the functions of Excel, but a course that uses Excel examples used in actual work sites to learn which functions to incorporate in each situation to perform work most quickly and efficiently .

Educational content

Practical example

Recommended for
these people

Who is this course right for?

People with basic knowledge of Excel, Excel practitioners

Need to know before starting?

Prior knowledge of creating simple tables or entering formulas in Excel

Hello
This is

6,606

Learners

677

Reviews

162

Answers

4.9

Rating

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)

Curriculum

All

42 lectures ∙ (5hr 11min)

Course Materials:

Lecture resources

Section 1.

1 lectures ∙ (2min)

1. Course Overview
02:08

Section 2. 1. Course Introduction

3 lectures ∙ (10min)

Section 3. 2. Data Transformation Techniques that Shorten Work Hours

6 lectures ∙ (55min)

5. Fill Blank Cells Simultaneously
07:50
6. Batch change by replacing unnecessary characters
09:00
7. Separating data and incorrect format conversion
12:43
8. Consolidate lines into one
07:22
9. Batch edit and process list downloaded from ERP
09:35
10. Quickly change Big Data list format
09:22

Section 4. Key techniques for using formulas and functions

4 lectures ∙ (28min)

Section 5. Project (Example) 1: Complete the transaction history table using a function after editing the supplier DB

5 lectures ∙ (30min)

Section 6. Project (Example) 2: Compare two data lists to manage training history and create a summary table

3 lectures ∙ (31min)

Section 7. Project (Example) 3: Process Corporate Card Usage Details to Create Departmental Analysis Report

2 lectures ∙ (19min)

Section 8. Project (Example) 4: Creating Annual Transaction Partner Analysis Table from Internet Download Data

3 lectures ∙ (17min)

Section 9. Project (Example) 5: Writing a Daily Sales Analysis Report by Day of the Week

4 lectures ∙ (18min)

Section 10. Project (Example) 6: Creating an Automated Analysis Table to View Only Selected Quarter Performance

3 lectures ∙ (20min)

Section 11. Power Query for Big Data Utilization and Analysis

8 lectures ∙ (1hr 17min)

Published:

Last updated:

Reviews

All

313 reviews

4.9

313 reviews

goo3book0144
Reviews 5
∙
Average Rating 5.0
5
100% enrolled
If you follow along one by one, it will be a great help. My original Excel skills were not that great... but my Excel skills have definitely improved. I have gained a lot. I plan to listen to it again to learn it properly to reinforce it a bit more. I recommend it.
- onwings
  Instructor
  I'm glad it was helpful~ haha Thank you for your hard work.
lypuppy3726
Reviews 16
∙
Average Rating 3.9
5
100% enrolled
Regardless of your job, it explains only the essentials that you need to know in an easy way! I highly recommend it! I like this lecture because it teaches you the 'know-how' rather than the 'hard work' of data management. Please take an Excel lecture from a professional instructor like this! A person who was famous for being good at Excel at work became famous as an Excel YouTuber and created a lecture to sell it, but I was so disappointed when I took that lecture. It was a lecture that tried to teach you too much at once. It was as if he was saying, "I know how to do all this, I know all these functions." He even teaches you the functions that are only necessary for specific jobs.. I recommend this to those who don't want to know all the functions and features of Excel.
dldudghk104964
Reviews 1
∙
Average Rating 5.0
5
100% enrolled
As an intern and a job seeker, I need to get a computer skills certificate. I remember a famous lecture that I attended to study computer skills. This Excel lecture is not an Excel lecture for theory, but a lecture for practical practice based on practical practice. I was amazed the whole time I was watching it. I think I will come back to listen to it again even after I get a job. A famous lecture that will give wings to your work.
kmookie
Reviews 1
∙
Average Rating 5.0
5
100% enrolled
I listened to up to lecture 13. When I was frustrated with Excel, I searched the green window and YouTube to get by. I also bought the Pa**Cam*s lecture, but for some reason, the explanation didn't go into my head. But this lecture is completely focused on practical work, so it goes right into my head. It's so great that I can apply it right after listening to the lecture!!
- onwings
  Instructor
  Thank you for your good evaluation~^^ I am glad that the content related to my work is helpful to me. Thank you~^^
jun17
Reviews 1
∙
Average Rating 5.0
5
31% enrolled
It's good for learning and practicing because the core concepts are explained easily and well! I forgot many Excel features I used while doing marketing work for a year because I didn't use them. Feeling like I needed to reorganize, after taking the 3-hour core lecture, I'm now taking the data management lecture that makes things 100 times faster. Afterwards, I plan to try learning the 8 practical examples lectures or visualization expressions while reviewing at least twice! Thank you:)

$34.10

onwings's other courses

Check out other courses by the instructor!

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!

Intermediate

Business Productivity, Excel, VBA

Complete mastery of Excel macros and VBA from basics to practical use

onwings

Useful tips for decorating Korean reports

onwings

Korean tips that you couldn't use because you didn't know them, not because they were difficult! A course that selects only useful Korean functions!

Intermediate

Hancom Office

Useful tips for decorating Korean reports

onwings

Excel Basics: Only the core practical skills are selected and finished in 3 hours

onwings

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.

Beginner

Excel, MS-Office

Excel Basics: Only the core practical skills are selected and finished in 3 hours

onwings

Excel for Office Workers - Master Excel with 8 Practical Projects

onwings

Learn Excel most efficiently in a short period of time by creating an Excel report used at work in a project format.

Intermediate

Excel, Excel PowerQuery, MS-Office

Excel for Office Workers - Master Excel with 8 Practical Projects

onwings

Differentiated Excel data analysis and chart visualization exclusively for professionals

onwings

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.

Basic

Excel

Differentiated Excel data analysis and chart visualization exclusively for professionals

onwings

Similar courses

Explore other courses in the same field!

Effective business capacity enhancement, Python business data analysis expert course

Masocampus

Coding Excel Data in Python?! It's Not Hard~ Becoming a Leading Worker is Just a Matter of Time!

Basic

Python, Excel, Excel Power Pivot

Effective business capacity enhancement, Python business data analysis expert course

Masocampus

Differentiated Excel data analysis and chart visualization exclusively for professionals

onwings

Basic

Excel

Differentiated Excel data analysis and chart visualization exclusively for professionals

onwings

Computer Literacy Written Exam, Easy Course for Absolute Beginners

ds8828455

Computer Proficiency written exam is no longer difficult! We've organized only the core points so anyone can easily understand. With this course, passing in a short period is entirely possible. Start right now!

Beginner

Computer Specialist in Spreadsheet & Database, Business Productivity, Excel

Computer Literacy Written Exam, Easy Course for Absolute Beginners

ds8828455

Automating VBA tasks using Excel

Kyeongrok Kim

Excel VBA helps you use Excel faster and more efficiently. Now, learn VBA to spend your free time at work. For web data collection, please refer to this course: https://www.inflearn.com/course/python-crawling#

Basic

Excel, MS-Office, VBA

Automating VBA tasks using Excel

Kyeongrok Kim

[Work Automation Using Free MS RPA] Power Automate Desktop Basic

omas

We will practice automating repetitive tasks using Power Automate Desktop, a free RPA tool from MS. Through this process, we will learn to understand automation and apply it to our actual work.

Basic

Power Automate, MS-Office

[Work Automation Using Free MS RPA] Power Automate Desktop Basic

omas

Mastering AI Assistant NotebookLM: 10x Your Efficiency in Reports, Meetings, and Data Analysis at Work

iexceller

Through this course, students will learn NotebookLM's core features step-by-step and discover how to delegate repetitive workplace tasks like report writing, meeting minutes organization, and data analysis to an AI assistant. Beyond simple conceptual learning, the course provides actual work routines and checklists, enabling students to gain practical skills that can be immediately applied to their work right after completing the course.

Beginner

AI, Business Productivity, PowerPoint

Mastering AI Assistant NotebookLM: 10x Your Efficiency in Reports, Meetings, and Data Analysis at Work

iexceller

Master Excel 2019 Macro VBA from the Basics

comt

Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

Basic

Excel, VBA, Business Productivity

Master Excel 2019 Macro VBA from the Basics

comt

Data Science Introductory Bootcamp

Masocampus

Even if you don't know how to code, Excel is enough! This course covers everything from statistics to machine learning and Power Query, and even non-majors can use Excel to analyze data.

Beginner

Excel, Machine Learning(ML)

Data Science Introductory Bootcamp

Masocampus

[First in Korea] ChatGPT × Word Practical Application: Document Automation Made Easy for Everyone

iexceller

First in Korea! A course on automating Word business documents with ChatGPT. Easily create various questionnaires, work reports, meeting minutes, and contracts, then immediately apply them to your work through hands-on practice.

Basic

MS-Office, Business Productivity, ChatGPT

[First in Korea] ChatGPT × Word Practical Application: Document Automation Made Easy for Everyone

iexceller

Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General

usefulit

Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)

Beginner

Excel, MS-Office, VBA

Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General

usefulit

Efficient AI Utilization That Companies Want - Practical Data Processing Secrets Conquered with Structured Prompts

Masocampus

AI Excel that automates perfectly for your work without company security concerns. From data preprocessing to visualization in just a few minutes, no coding knowledge required!

Beginner

Excel, AI, ChatGPT

Efficient AI Utilization That Companies Want - Practical Data Processing Secrets Conquered with Structured Prompts

Masocampus

Master Excel Automation for Work Efficiency with ChatGPT

365ENM

Through the synergy of Excel and generative AI (ChatGPT), this practical, hands-on training covers the entire spectrum including data aggregation, cleansing, visualization, report writing, template automation, code-free schedule creation, VBA automation, and Google Sheets integration, designed to enable learners from Excel beginners to intermediate users to develop skills that can be immediately applied in real-world work through step-by-step learning.

Beginner

Generative AI, ChatGPT, Excel

Master Excel Automation for Work Efficiency with ChatGPT

365ENM

Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice

usefulit

Through this course, learners will be able to acquire the skills necessary to obtain a Computer Application Skills certification. This course is structured according to the examination standards for obtaining the Computer Application Skills certification. You can learn and apply fundamental knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice)

Basic

Excel, MS-Office, Computer Specialist in Spreadsheet & Database

Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice

usefulit

[Pass ITQ Excel A in One Go] in 3 days

dmsgml1030

Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

Basic

ITQ, Excel, MS-Office

[Pass ITQ Excel A in One Go] in 3 days

dmsgml1030

Analyzing and predicting marketing data with Excel

groschool

A class on analyzing customer/sales data with Excel, even without R or Python!

Basic

Excel, Performance Marketing

Analyzing and predicting marketing data with Excel

groschool

Basic Statistics with Excel

statisticsplaybook

Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

Basic

Excel, Statistics

Basic Statistics with Excel

statisticsplaybook

Data Classes for High-Performing MDs

mdunnie

Data Analysis that Determines Online MD Performance! Learn essential data analysis and strategy formulation techniques necessary for MDs to maximize sales and profit in the e-commerce market.

Beginner

Data literacy, Excel, Google Sheets

Data Classes for High-Performing MDs

mdunnie

ITQ Powerpoint Certification to be completed over the weekend

erumcoding

ITQ PowerPoint national certification key summary lecture that can be obtained by utilizing two days of the weekend! 4 mock exams and real-time mock exam solution videos provided

Beginner

MS-Office, PowerPoint, ITQ

ITQ Powerpoint Certification to be completed over the weekend

erumcoding

Excel data utilization and analysis know-how that makes work 100 times faster

Reviews from Early Learners

4.9

What you will gain after the course

Educational content

Practical example

Recommended for these people

HelloThis is .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

Curriculum

Reviews

onwings's other courses

Similar courses

Recommended for
these people

Hello
This is