[Double work efficiency] Practical Excel lectures from basic to advanced
Beginner
6 chapters
English · Japanese · Korean|Audio Korean
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.
