1/5

Pick only the core of basic Excel work and finish it in one day

Rookie
4 chapters · 3 hours 18 minutes
English · Japanese · Korean|Audio Korean

Skills You’ll Learn

Step 1: Grind the basics

Create tables to make them look good, and learn computational tasks using formulas

Step 2: Practical use

Learn in more depth through examples used in actual work.

Step 3: Data Management

Learn the whole story of data management and analysis.

수강생 후기

▶ Student reviews

This course is a basic training in Excel, and is necessary even for first-time users of Excel, but I definitely recommend it to those who have been using Excel for work and have never learned Excel in a systematic way.



Hello, I'm Kim Kyung-ja, the goddess of Excel.

<History>

  • (Current) Compipple CEO
  • Attended lectures at LG Electronics, Daewoo E&C, Shinsegae Food, Sampyo Foods, Korea Standards Association, Land Housing Corporation, National Civil Service Redevelopment Institute, Land, Infrastructure, Transport and Tourism Human Resources Development Institute, Korea Chamber of Commerce, Seoul National University, Central Education Center, etc., and developed a business innovation program using Excel VBA

<books>

  • <Excel Functions & Formulas> (Hanbit Media, 2021)
  • <Excel Practical Macros and VBA (Hanbit Media, 2020) >
  • <Excel Practical Data Utilization+Analysis (Hanbit Media, 2019) >
  • <Excel 2016 Basics+Practical Completion> (Books Holic, 2018)
  • <Excel Data Utilization+Analysis> (Hanbit Media, 2016)
  • <Excel 2016 Macro and VBA> (History of Information Culture, 2016)
  • <Excel 2013 Basic Practice Completion> (Books Holic Publishing, 2014)
  • <Excel 2010 Macro and VBA> (Youngjin.com, 2012)
  • <Excel 2010 Basic Practice Completion> (Books Holic, 2010)
  • <Excel 2007 Macro & VBA Basics+Practices> (Sungan-dang, 2009)

Since Excel has so many functions,

It's hard to fully understand all of the features.

In this course, you must know when working with Excel Select only the core functions of Excel practiceThis makes it easy and quick to learn.



How to use Excel is more important than knowing a lot about it.


✅ Step 1: Build the basics


✅ Step 2: Further learning through examples


✅ Step 3: Data management and extraction


The overall curriculum structure consists of drawing up a table to make it look good in the first step of basic preparation, and entering a formula to perform calculation work.

Next, in step 2, you will learn in more depth through examples used in actual work based on what you learned in step 1. If you know the functions of Excel, but don't know how to use it in real work, you can't apply it. This is a step towards solving such a problem.

In step 3, the learning focuses on sorting required for data management, filters to extract only necessary data, subtotals that can be aggregated by group, integration, and pivot tables.

Class Kit · Coaching Session


Curriculum

Creator

EXEL Lady Kim

EXEL Lady Kim

While working at LG Electronics LearningCenter, I have a relationship with IT education. Currently, I have been teaching and developing business innovation programs using Excel VBA for 20 years at LG Electronics, Daewoo E&C, Shinsegae Food, Sampyo Foods, Korea Standards Association, Land Housing Corporation, National Civil Service Redevelopment Institute, Korea Chamber of Commerce and Industry, Seoul National University, and Central Education Center. My books include <Excel Functions & Formules> (Hanbit Media, 2021), <Excel Practical Macro and VBA (Hanbit Media, 2020) >, <Excel Practical Data Utilization+Analysis (Hanbit Media, 2019) >, <Excel 2016 Basics+Practical Completion> (Booksholic, 2018), <Excel Data Utilization+Analysis> (Hanbit Media, 2016), <Excel 2016 Macro and VBA> (Information Culture History, 2016), <Excel 2013 Basic Practice Completion> (Booksholic Publishing, 2014), <Excel 2010 Macro and VBA> (Youngjin.com, 2012) There are <Excel 2010 Basic Practice Completion> (Books Holic, 2010), <Excel 2007 Macro & VBA Basics+Practice> (Sungan-dang, 2009).

onwings

onwings

View similar classes you might also like

From the basics of Excel to how to use itOffice Productivity  |  Michol

Notes on Copyright Protection

  • All videos and materials included in the class are protected intellectual property under relevant laws.
  • You may face legal action if you copy, distribute, transmit, modify or edit the videos or materials included in the class without permission.
CLASS 101, LLC.
1201 North Market St. Suite 111, Wilmington, DE, 19801
support@101.inc