Skills You’ll Learn
Data transformation techniques to shorten business hours
Learn useful honey tips for quickly editing and processing external data.
Key techniques required for use in equations and functions
Learn the core functions of using functions required for data analysis.
Project example 1
Edit the purchasers DB and complete the transaction statement with a function
Project example 2
Compare two data lists to manage training history and create an aggregation table
Project example 3
Create a departmental analysis table by processing corporate card usage history
Project example 4
Daily Revenue Analysis Report+ Create a Chart
Project example 5
Create an automated analysis table to view only the selected quarter's results
Excel big data analysis using power queries
Learn the basic concepts of Excel power queries and learn data transformation/collection functions
▶ Lectures using contextual examples used in actual workplaces
This course is not just a training that explains the functions of Excel, but it is a course that uses Excel examples used in actual workplaces to learn what functions should be incorporated into each situation to perform the fastest and most efficient work.
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)
It captures the scene of a lecture I've seen and heard firsthand for 20 years.
I've been interacting with Excel practitioners in the field for the past 20 years while giving lectures Practical examples and questions from studentsYou can assemble examples and learn advanced Excel techniques through those examples.
I'll tell you everything about Excel used in practice.
✔️ Inconvenient moments while using Excel
✔️ Tasks that take a lot of time to work with Excel
✔️ Those who need data analysis that required automation
We will help everyone become an Excel master through this class.
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
