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!

Edit Image Info

_{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!

Edit Image Info

Edit Image Info _{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.

Edit Image Info

_{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!

Edit Image Info

_{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:)

[Double work efficiency] Practical Excel lectures from basic to advanced

[Double work efficiency] Practical Excel lectures from basic to advanced