Check out what classmates have to say!
▶ ︎ 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
📧 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
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