Easy and fast ready-to-use Excel for practitioners
Beginner
8 chapters ยท 6 hours 1 minutes
English ยท Japanese ยท Korean|Audio Korean
Check out what classmates have to say!
How good are you at handling Excel?
Do you know what function to use in the following situations?
๐ Come up with a solution in 10 seconds!
The resident registration number and business registration number are entered in column B. To remove hyphens from this data: What should I do?
๐ Find and replace functionDid you think of? Then you need this class!
If you replace the hyphen with a space, it's a strange number like the one belowIt is converted to. This is because Excel does not display numbers with 12 or more digits as exponents, and zeros that do not have valid leading digits.
๐ก The solution is the SUBSTITUE function!
In this case Substitute functionYou can easily get results by using. Since the result of a text function such as SUBTABTATE is also in text format, it is displayed as an exponent or all zeros where the preceding digit is invalid.
I need Excel at work, but the shooter doesn't tell me
Hello, on the YouTube channel and Naver Post 'Short course'This is Jeong-hee, who runs.
For office workers who do office work Excel is essentialIt's a tool I don't have enough to say.
When I go to a public institution/corporate training center, etc., the most common story of practitioners Said that he worked overtime because he didn't know how to use Excel wellIt was.
Vlookup, Countif...There are a lot of functions, but I don't know what they just need People
There is a lot of data to process, but it's only done by handThose who do
No matter how many lectures you listen to, I don't know how to use it in real work People
Join me in a reality Excel course for office workers Let's become an Excel competent person.
Structuring a practice-oriented curriculum!
Just Gather only the essentials you need and use what you've learned right into your workWe'll help you do it.
Simple arithmeticStarting with the work that requires this, Complex calculation results using functionsHow to obtain accurately and quickly
Summarize large amounts of data effectivelyDo it in various forms necessary for work Create diagrams and analytical chartsHow to do it
Aggregate data with pivot tables and create charts for reportingHow to do it
The work I used to work overtime for a week One or two Excel functions in 1 minute We'll tell you how to handle it.
You became infinitely smaller in front of Excel,
Don't worry about being in front of the monitor anymore
Let's solve it together!
Class Kit ยท Coaching Session
๐ 1:1 coaching to help you understand
โI know when I hear it, but I can't do it alone.โ Now I'll blow away those worries in one shot.
In each chapter, we will solve your own missions and provide commentary and coaching.
Apply chapter specific missions directly to the businessI'll try it. Coaching on business data processing/applicationYou can also get it.
What functions should be applied to the data used in practice, and what errors should not occur I'll let you know directly.
๐ฉ The package is subject to some changes, and we will be fully informed if there are any changes.
Curriculum
Creator
Hantip
Hallo This is a short course limited edition.
I mainly use it in online and offline office environments Practical Excel Course We are teaching how to write Hangul documents required for writing reports and PowerPoint for writing presentation materials.
Over the years, I naturally gained practical experience after meeting with students, listening to difficulties, devising ways to solve problems together, and thinking about solutions.
I want to communicate with more people here at CLASS 101, and I want to be a guide so that they can apply and use Excel in practice.
