Excel, the secret to “Lee” for “good” office workers!

Beginner
8 chapters · 7 hours 50 minutes
English · Japanese · Korean|Audio Korean

Check out what classmates have to say!

 101Awards 대상 수상

▶ ︎ 101 Awards Grand Prize


Hallo I'm Zali, the creator.


I Worked for 7 years at LF affiliate Tricicle Online MD Co., Ltd., and 2 other companies


prefecture. Offline classes (2018.09~)

10,000 students achieved, the highest number of reviews (1,000 reviews achieved)


2019

Attended Amway (Amway) in Korea

Korea Institute of Health and Medical Research Consulting

adidas (ADIDAS) Korea Consulting

Attended Seoul City Job Center

Attend the online shopping mall Sky Sky


2020

Attended Seoul National University Hospital Gangnam Center

Attended Kyungnam University

Attended the Korea Federation of Disabled People's Organizations

Attended Korea Export Promotion Association

Attended Gyeongnam Contents Korea Lab

Class 101 Online Instructor

Attended Kyung Hee University

Attended KB Securities


2021

Attended Jeju Special Autonomous Region Development Corporation

Attended Samsung Fire & Fire

Attended at Lotte Group companies (6-month contract)

Online attendance at Kyung Hee University

Attended Kyungnam University

Attended training for new employees of the Small and Medium Venture Enterprise Promotion Corporation

Foreign Nespresso attendance

Attended Park Systems

Attended Chungnam National University Hospital

Attended Seongnam Youth Support Center

Attended Lotte Chemical

Attended Jeju University


Renewal in 2022!

Practical Excel, I'll tell you the easiest way.

And how to use Excel well


I learned Excel from time to time while working for a company.

“You can use a function like this for this situation, and a function like that for other situations.”

As a result, the work is handled well, but

After that A newly received job, a job that must be created by oneselfIn Excel is a white grid paperIt looked like Roman. It was too difficult because it couldn't be applied.

Aren't all of you like that?



It's not a class that only teaches functions and functions,

It is an Excel class that can be directly incorporated and applied to practice!



In addition to teaching you the functions of Excel and basic medium/advanced functions that you must know in practice, this class not only teaches you the most important actual work situations, but also allows you to do the most important actual work situations on your own A class that knows how to apply and use ExcelI have prepared it.




Difficulties in actual work! Would you like to solve the problem below?


On the left and right Someone with a different passport numberIt's a situation where I need to find. Do you think we need a function that finds differences? though Even without complicated functions You can find the differences between the two files. That's sweet too 30 seconds It's only.



The correct answer =C5=F5 (This means that the value entered in cell C5 is the same as the value entered in cell F5.)

Isn't that so easy? You only need to check the FALSE value.

Excel basically has a structure called TRUE & FALSEIt consists of.

What is a typical Excel class Ask them to memorize the same functions and functions every time.

This is not the case with this class. So it's different.

I would like to inform you so that you can use Excel on your own.




As an example of the files I use in practice,

So that it can be applied directly to the business!


📍 BEFORE: Statistical data that can't be obtained at a glance


📍 AFTER: Intuitively understood chartsEven how to express it as!


It may have been difficult to learn Excel through books or internet searches, etc., but at that time, you probably experienced many frustrating situations where you didn't understand it, or didn't know if you didn't want to redo it or incorporate it.

In addition to being a lecturer, I am currently working on creating Excel consulting (actual company files) (adidas, Amway, etc.) It's not a course material designed to explain functions and functions Various files that appear in actual workI'll tell you about Excel through.




I am “Zali”, the most reviewed lecturer in the field of offline teaching platform Excel.


Hello, I'm Jali, an Excel instructor.

I learned about Excel when I entered the company.

And since I'm a fashion major, I just felt like Excel was even farther away.


At first Survival-typeWhen learning Excel with, according to the situation

I learned functions and functions.

“You can use this function in a situation like this, and that function in a situation like that.”

As a result, when you have to create your own Excel file from scratch in a new job

I felt like I had no idea what to do.

So I began to spend more time and effort studying Excel than others.


Have you heard it?

People who are good at Excel don't use a mouse or only use shortcuts.


It's not important to use only shortcuts to do Excel

⭐️ How to use shortcuts to speed up work

⭐️ How to use Excel to make the same graph paper work better


Isn't the Excel we really need a “practical Excel” like this?


It is not directly applicable to practice,

An Excel class that can be applied countless times in practice.


A class where you can not only do Excel well, but also do a better job through Excel.



From ribbon menu functions that reduce work time, to work-specific functions!


1. The basics of using Excel quickly: From ribbon menus to shortcuts

  • A ribbon menu function that is frequently used for work. (Home tab ~ View tab)
  • Excel shortcuts you must know to speed up work
  • Excel skill for entering data into multiple cells at once

2. Functions to get you started step by step

  • Words you need to know before learning functions (functions/formulas/relative references/absolute references)
  • Excel skills that speed up work “at least 5 times”
  • Most used functions (SUM ~ IF ~ VLOOKUP ~ SUMIF ~, etc.)

3. In Excel, judgment ability is much more important than functions! Diagnosing what I need

  • How to excel what I think
  • Learn real Excel through working files

4. Excel skills to use differently from others

  • Functions written differently from others (IF/VLOOKUP ~, etc.)
  • A secret that can do everything without knowing a function if you are good at applying it

5. Let's create our own analysis data & various visualization Excel skills

  • Better formatting skills than “merge and center”
  • Visualization skills using cell formatting/charts

It is fully organized only with things that can be used directly in practice. After this lesson, you'll no longer need to ask the shooter for Excel while noticing it!

수강생후기

▶ ︎ Student reviews

Class Kit · Coaching Session


📧 1:1 coaching directly from Deoksu (3 sessions)

  • If you have any questions about Excel, such as the difficulties you had while creating Excel, please be sure to send it along with the file.
  • The more clearly you explain the situation you have created the Excel data and the purpose you want, the more accurate you will be able to guide you.
  • If you need a video explanation for the Excel material, we will also send you a video as an attachment.
  • Coaching is answered sequentially every Wednesday and Friday. You'll also receive a response within up to 7 days.

Curriculum

Creator

Exel Solutionist

Exel Solutionist

Hallo I'm Zali, the creator.


I Worked for 7 years at LF affiliate Tricicle Online MD Co., Ltd., and 2 other companies


prefecture. Offline classes (2018.09~)

10,000 students achieved, the highest number of reviews (1,000 reviews achieved)


2019

Attended Amway (Amway) in Korea

Korea Institute of Health and Medical Research Consulting

adidas (ADIDAS) Korea Consulting

Attended Seoul City Job Center

Attend the online shopping mall Sky Sky

Fast Campus Online Instructor


2020

Attended Seoul National University Hospital Gangnam Center

Attended Kyungnam University

Attended the Korea Federation of Disabled People's Organizations

Attended Korea Export Promotion Association

Attended Gyeongnam Contents Korea Lab

Class 101 Online Instructor

Attended Kyung Hee University

Attended KB Securities


2021

Attended Jeju Special Autonomous Region Development Corporation

Attended Samsung Fire & Fire

Attended at Lotte Group companies (6-month contract)

Online attendance at Kyung Hee University

Foreign Nespresso attendance

Attended Park Systems


Course inquiries: fragofh@naver.com

jally.ssaaeeem

jally.ssaaeeem

View similar classes you might also like

[Photoshop: Package] Youtube Thumbnail DesignDesign Tools  |  D.HARA

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