Skills You’ll Learn
▶ Lectures on Excel data analysis & chart visualization through contextual examples used in actual workplaces
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)
Excel is an essential application, not an option, for office workers.
More than using Excel well and not being able to do a good job without it, it is now also the standard for determining how comfortable I work and how hard I work.
If you are a practitioner who uses Excel, many of you may have thought that it would have been nice if you learned about these functions a little earlier when they learned a new function.
▶ Provision of project-type working examples
People who know how to apply and use it rather than know a lot of functions are people who use Excel a lot.
As a result, rather than learning all the Excel functions, receiving some know-how from an Excel expert is much more helpful in the work.
This course does not explain the functions of Excel, but rather explains what functions and functions of Excel should be used to solve tasks most quickly and efficiently in this case through examples used in the actual workplace, so it is a course that satisfies 100% sense of presence.
✅ First, I will explain how to quickly and accurately edit raw data downloaded from the system.
✅ Next, create the desired analysis table using functions and pivot tables in the edited data list.
✅ Finally, complete the report by applying a user display format, conditional formatting, and a chart to visualize the report.
If you are an office worker who wants to analyze Excel data while reducing work hours and improving efficiency, you will be able to find a solution through this class.
PC with Excel 2013 or higher
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