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!