1/6

Differentiated Excel data analysis and chart visualization unique to professionals

Beginner
10 chapters · 5 hours 42 minutes
English · Japanese · Korean|Audio Korean

Skills You’ll Learn

RawData conversion and processing tips

Many useful Excel tips to know and tips for editing downloaded raw data

Useful tips for using formulas and functions

A solution to trivial but ankle grabbing equations and functions

Tips for using pivot tables

An all-in-one data analysis technique with a pivot table

Techniques for visualizing data using charts

Various ways to create and edit charts

Project examples

Analysis of special bonus payments by dividing tenure and retirement by department

Project examples

Submit a claim Create an analysis report using raw data

Project examples

Find the lowest unit price by product name and standard and create a unit price comparison table

실제 업무 현장에서 사용되는 상황별 예제를 통한 엑셀 데이터 분석 & 차트 시각화 강의

▶ 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.




Class Kit · Coaching Session

PC with Excel 2013 or higher

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

Data analysis & visualization starting with ExcelOffice Productivity  |  Donghoon Lee

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