Skills You’ll Learn
▶ 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.
Curriculum
Creator
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