Check out what classmates have to say!

Skills You’ll Learn

How to create your own shortcuts

An introduction to how to create “my own shortcuts” for frequently used functions for each individual

Using the VLOOKUP function properly

Introducing how to use it faster and more accurately in a different way

How to manage Excel with your own name declaration

Introducing how to manage many Excel areas under your own name

How to record automated macros in Excel

An introduction to how to record and use macros very easily

Learned by someone with an Excel ability

We will disclose all our know-how

많은 목차, 의욕저하, 수많은강의, 뭐부터?

▶ ︎ Too many tables of contents, loss of motivation, lots of lectures, what do you start with?

I wanted to do a good job at the company, so I bought a book at a bookstore and studied online, but it wasn't really helpful, and I was limited in asking senior and junior motivators in the company.

Therefore, the company began to analyze difficult Excel files directly. I made many functions and know-how my own It's been 8 years since then.

Analyzing Excel files for 8 years, I hope others don't have the same experienceI have a heart for it.

The many Excel know-how I've learned

If you listen according to the curriculum

Definitely a lot of help to the studentsI was sure it would be.

Does Excel just seem difficult?

간단한 예시, 노하우 전달

▶ ︎ Simple examples, know-how transfer

Excel automation!

It may sound like a distant story to all of you. though Conditional formattingIna simple macros It's not difficult to do even if you know a few things.

As a practice-oriented practitioner, I Your shooterIt will be. I'll turn Excel's fear into confidence.

Have faith that you can overcome it.

Each and every student through practical Excel lectures that reflect the value of my life To be able to overcome difficulties as easily as Excel work We're here to help.

1. Establishing basic skills

Basic shortcutsLet's start by creating shortcuts that you use frequently See formulaWhile learning Let's lay the basics!

_{Important featuresListen hotkeyLearn with Basic functionsAfter learning to hear}

As a reference function _{Incorporating into multiple functionsI'll try it:)}

2. Using advanced functions

- VLOOKUP, SUMPRODUCT, Offset, frequency, etc. Various advanced functionsI'm going to learn!

_{Some important functions, If you skip because it's difficult}

_{On this occasion MASTER Here's your chance to do it:)}

3. Know-how transfer

Learned in work life Excel know-howKeep mentioning what you hear so that it comes naturally into your head.

_{After all, Excel's know-how Work automationAble to do}

_{Best methodsThis is it. Don't miss them all and make them with your know-how :)}

4. Using macros

Complex macro functions without being complicated!

_{How to record macros It's very easy.}

_{With this method Automate repetitive tasksI can do it:)}

If you work with someone who can excel, you will improve your ability to work in Excel Looking for time to spare It will be a meaningful time to increase your precious time:)

Class Kit · Coaching Session

1:1 Excel coaching taught directly by an Excel expert (1 session)

You can ask a total of 1 question per coaching ticket.
For each question, we will write an appropriate answer and an example file in an Excel file and send it to you.
We can also help you with repetitive tasks in Excel or if you have something you want to improve.
However, I will solve it in the content of the Excel course. If it deviates from the course content, you can send a different questionnaire.
Coaching is answered sequentially based on the date the questions are received. This may take 3 to 10 days.
If not used within the period, no refund will be given.

Curriculum

Creator

Exel Expert

Hello:)

I'm a coach with Excel skills.

It was menbung when I came into the company and suddenly asked me to do Excel.

I really didn't know how to do Excel The level of requirements was high.

Going to a bookstore to buy books and studying online didn't help.

Asking senior and junior motivators in the company There was a limit.

So the company began to analyze difficult Excel files.

It's been 8 years since I made many functions and know-how my own.

While thinking about the hard work I experienced during the 8-year period, I desperately felt that others needed lectures that would reduce their difficulties and stress as much as possible.

I was convinced that if I listened to the many Excel know-how I had learned according to the curriculum, it would be of great help to the students.

Being able to overcome Have faith

I will help each and every student to overcome difficulties as easily as Excel work through practical Excel lectures that reflect the value of my life.