inflearn logo
Challenge
Ended

Excel Essentials! Complete Mastery of Must-Know Functions

🙋‍♀️ Have you ever had thoughts like these? "Functions! I understand them when I hear about them, but when I actually try to use them, I can't remember..." "How great would it be if they just came to mind exactly when I need them?" Excel functions are the most powerful tool for improving work efficiency. But it's also true that they can feel unfamiliar and complex. That's why we've prepared this! 📌 Course Introduction We've carefully selected only the Excel functions essential for practical work and explain them easily with examples. ✔ Basic essential functions like IF / VLOOKUP / SUMIF / COUNT / RANK.EQ ✔ Financial functions like FV / PMT, statistical functions like AVERAGEIF / COUNTIFS ✔ Examples focused on functions you can immediately apply in practical work Rather than just throwing function explanations at you and calling it done, we've structured it so you can follow along directly while looking at example files. Don't worry if you're an Excel beginner! We'll teach you slowly and step by step.

157명이 수강한

강의로 진행되는 챌린지!

Excel
MS-Office

28개 수업 학습

5회 미션 수행

라이브 2 회

dmsgml1030님과 함께해요!

476

Learners

55

Reviews

1

Answers

4.9

Rating

20

Courses



I am teaching office certification courses to help students preparing for employment with their self-development.

And I teach practical Excel classes for office workers to help them improve their job competencies

CEO of Eunhee-ssam Class

■ Professional Qualifications

Vocational Training Teacher Level 2 (General Administration & Office Work) Ministry of Employment and Labor

Vocational Training Instructor (Information Technology Operation & Management) Level 3 Ministry of Employment and Labor

Vocational Training Teacher Level 3 (General Administrative Affairs) Ministry of Employment and Labor

Computer Literacy Level 1 Korea Chamber of Commerce and Industry

ITQ Professional Training Instructor (PTI) Korea Productivity Center

ITQ Hangul A, Excel A, PowerPoint A, Internet A Korea Productivity Center

Computer Utilization Ability Level 2 Korea Chamber of Commerce and Industry

Industrial Engineer Information Processing Human Resources Development Service of Korea

■ Publications

85 Excel Functions to Pick and Use Like a Dictionary & Everything About Analysis Tasks (Bookk 2020)

■ Teaching Experience

Taught OA and ITQ certification courses at the Daechi 4-dong Information Education Center in Gangnam-gu as a member of GIT Academy, commissioned by Gangnam-gu Office 2009.03

Lectured on OA and ITQ certifications for people with disabilities and seniors at Gunpo Welfare Center for the Disabled, March 2011

Conducted OA lectures at the Geumcheon-gu Office Computer Training Center as part of Hanbit Computing, entrusted by Geumcheon-gu Office, 2012.03

Taught OA and ITQ certification courses for people with disabilities and seniors at Seodaemun Welfare Center for the Disabled 2013.03

Taught Computer Literacy Level 2 and ITQ OA Master courses for office workers and the general public at the Hwaseong U&I Center (Women's Vision Center) 2015.01

Taught Computer Literacy Level 2 and ITQ OA Master courses as part of the vocational training program for the unemployed at the Gyeonggi Vocational Education Center, 2015.03

Lectured Computer Literacy Level 1 and 2, and ITQ OA Master courses as vocational training programs for the unemployed at Green Computer Academy 2016.04

Obtained "A" grade in Office Administration Trainee Evaluation, Dec 2018

Awarded Star Instructor at Green Computer Academy 2020.10

Selling practical Excel and certification courses on Inflearn 2022.03

[Teacher Eunhee's Class] Launch of an online lecture site specializing in employment certifications, September 2022

[Mapo Youth Naru] Youth Employment Competency ITQ Excel Special Lecture



More


🙋‍♀ You've probably had thoughts like this, right?

"Functions! I understand them when I hear about them, but when I actually try to use them, I can't think of them…"
"How great would it be if they just came to mind at the right moment?"


"You know it's good to learn Excel functions, but when you actually try to use them, your mind goes blank and you feel lost about which ones to use - I'm sure everyone has had this experience at least once, right?

Excel isn't difficult up to the basic stages of entering data and applying formatting. However, what really saves time and increases efficiency is 'functions'.

Functions are very reliable tools that calculate and organize things for me, but many people give up because the rules seem confusing or too numerous.


This course is an essential class for those people.


It doesn't simply list how to use functions.

"Why it should be written this way", "Which function would be good to choose in this situation"

I've structured it with step-by-step explanations so that anyone can easily understand.

Additionally, this isn't just a lecture you listen to and forget, but is designed so you can learn by following along with practical examples after listening to the lectures, and make it 'your own' by solving given missions. It's structured as a challenge course where you can fill in your weak areas through Teacher Eunhee's professional feedback.


The 'Must-Know Functions Complete Mastery' challenge course consists of the following stages

  1. Learning functions while taking online classes and

  2. Complete and submit missions for each function

  3. You can accurately understand and use functions while receiving professional feedback.




How to complete missions

Function-specific missions are prepared below the last lecture for each function
Read the mission description, download the mission attachment file, solve it according to the instructions, and submit it


By the time the challenge course comes to an end, functions that once felt vague will naturally become familiar,
and you'll be able to use them on your own when needed in real-world situations.



🎯 Recommended for these people

  • Someone who wastes time looking up functions every time they create reports and analysis materials

  • Someone who can do simple cell input and sorting but isn't confident with functions

  • Those who want to properly utilize Excel to reduce work time

  • Those who want to not just learn but immediately apply it to real work



🌿 Course Features

✔ Step-by-step explanations that even beginners can understand
✔ Principle-centered approach rather than fragmented knowledge
✔ Repetitive learning through challenge missions to solve directly at each stage
✔ Q&A board support for direct communication with the instructor



This lecture aims to help you recall 'exactly when you need it' those functions that you've always found confusing despite using Excel every day.

When you're preparing for work, creating reports, or organizing data, I'll help you so that your hands move naturally without having to worry "Which function should I use?"

Also, rather than just looking and moving on, by directly following along and solving problems, I'll help you develop the ability to freely apply what you learn to your own work situations.


✅ Prerequisites Guide

If you've never used Excel before, it would be good to first learn the basics like data entry, formatting, and sorting.

However, if you found functions overwhelming, you can learn all the rules and usage in this course.

Anyone can follow along if they can perform basic operations.


🎁 Course Benefits

  • Students can ask questions anytime during the course → The instructor will answer directly

  • When you submit function-specific missions 3 or more times or write a course review, we'll provide you with the "Excel Tips PDF for Improving Work Efficiency (100 pages)" e-book along with practice examples.



When you master functions, Excel truly transforms.
Repetitive tasks are reduced, data is organized at a glance, and reports become much cleaner.
Most importantly, work efficiency improves, giving you more free time.

Through this challenge course, let go of the mindset that 'Excel is scary because functions are difficult' and transform into a cool Excel user who naturally pulls out what they need at the right moment.


No pressure, but definitely.

We support your growth. 🌱


8월

31일

챌린지 시작일

2025년 8월 31일 PM 03:00

챌린지 종료일

2025년 10월 24일 PM 02:59

챌린지 커리큘럼

All

35 lectures ∙ (7hr 39min)

Course Materials:

Lecture resources
챌린지 전용 수업
Live

챌린지에서 배워요

  • You won't be intimidated just by looking at function names

  • Functions that can be used immediately in practice become organized in your mind.

  • You'll naturally learn by following along with the explanations.

  • Work speed increases by more than 2x!

Recommended for
these people

Who is this course right for?

  • Excel beginners who get headaches just from looking at function descriptions

  • For those who want to quickly learn only the functions that are essential for practical work

  • Professionals who want to develop practical skills through hands-on examples

  • - Those who need confidence in Excel

Need to know before starting?

  • Even knowing just data entry, cell selection, and basic formatting is sufficient.

Reviews

All

2 reviews

5.0

2 reviews

  • karabiner1107님의 프로필 이미지
    karabiner1107

    Reviews 15

    Average Rating 4.9

    5

    100% enrolled

    I wanted to organize Excel functions and this was the perfect course for that. I especially liked being able to review once more through the challenge missions and live lectures, and thank you for the easy-to-understand explanations.

    • dmsgml1030
      Instructor

      I'm so glad that the Excel function summary was helpful for what you needed! Thank you for staying with us through the challenge missions and live lectures until the very end ✨

  • tututu924251님의 프로필 이미지
    tututu924251

    Reviews 2

    Average Rating 5.0

    Edited

    5

    100% enrolled

    The instructor approaches topics logically and explains them in detail in an easy-to-understand way. And you are so meticulous, and even during challenges, you provide such good feedback and emphasize important points very well. Thank you 😊

    • dmsgml1030
      Instructor

      Thank you for leaving such a precious review 🙏 The Function Complete Mastery Challenge focused not just on simply knowing function concepts, but on delivering 'in an easy-to-understand way' how they can be utilized in real-world practice. I feel great satisfaction knowing that the explanations were well conveyed and helpful to you. Moving forward, I will continue to repay you with even more substantial lectures, step by step, with examples that can be directly applied to real work. I support you in completing your function skills by staying with us until the end!

이 강의의 지난 수강평

취소 및 환불 규정
챌린지는 지식공유자가 설정한 수업 최소 정원이 충족되지 않을 경우, 폐강 안내가 고지되며 결제 내역이 자동취소됩니다.

dmsgml1030's other courses

Check out other courses by the instructor!

$29.70