101Awards 대상 수상

▶ ︎ 101 Awards Grand Prize

Hallo I'm Zali, the creator.

Edit Image Info

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

Edit Image Info

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!

Edit Image Info

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?

Edit Image Info

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.

Edit Image Info

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

Edit Image Info

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

Edit Image Info

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!

Edit Image Info

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

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

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