강의

멘토링

커뮤니티

Productivity

/

Office

Do you want to quit your job? If so, you should take the [Excel Function Dictionary] course.

As you learn how to use functions with detailed explanations and practical examples, you will experience that functions become fun and easy to use, that your work efficiency will increase as you apply functions to your work, and that functions will no longer seem difficult, making Excel easier.

(4.9) 11 reviews

146 learners

Level Basic

Course period Unlimited

  • dmsgml1030
Excel
Excel
MS-Office
MS-Office
Excel
Excel
MS-Office
MS-Office

Reviews from Early Learners

What you will gain after the course

  • You can know exactly about Excel function rules.

  • Excel functions can be used appropriately

  • You can feel confident in Excel

Do you want to leave work early?

What is the reason why you can't leave work on time?

I don't know the function.....

Are you just memorizing Excel functions?
It's much easier if you understand and use it... 😚

Excel functions, just the moment you need them 📃

Whether you're a professional or a student, everyone uses Excel extensively for their own needs. The basics of Excel—entering data in worksheets, formatting cells, sorting, and editing data—are easier than you might think. However , many people struggle with Excel because they don't know which functions to use in the various forms they use at work, or because they struggle to understand the rules . This course will help you gain a solid understanding of functions and build your confidence in using them! Understand the rules and use them effectively, becoming a powerful Excel user !

This course's unique features ✨

  • The arguments for the functions are explained in Korean, making it easy to understand each function.
  • I created this lecture so that anyone can easily understand it by explaining it with examples .
  • Knowing which functions to use and where to use them will make Excel a breeze! It'll actually be easier.

I recommend this to these people 🙋‍♀️

I'm not confident because Excel functions are so difficult.

I don't know what the function arguments mean.

I don't know where or how to use the function.

I want to know more diverse Excel functions.


What you'll learn 🗂️

  • Date/Time Functions
    • Learn about the YEAR/MONTH/DAY/DATE/DAYS/WEEKDAY/WORKDAY/NETWORKDAYS/YEARFRAC/TIME/HOUR/MINUTE/SECOND functions and learn them through examples.
  • Logical functions
    • Learn about IF/AND/OR/IFERROR functions and practice them through examples.
  • mathematical functions
    • Learn about the ROUND/ROUNDUP/ROUNDDOWN/SUM/SUMIF/SUMPRODUCT/QUOTIENT/MOD functions and learn them through examples.
  • Text functions
    • Learn about the LEFT/RIGHT/MID/TRIM/FIND/SEARCH/REPLACE/TEXT/VALUE/REPT functions and master them through examples.
  • statistical functions
    • Learn about the COUNT/COUNTA/COUNTIF/AVERAGEIF/RANK.EQ/MAX/MIN/LARGE/SMALL functions and master them through examples.
  • Find Reference Function
    • Learn about the VLOOKUP/CHOOSE/INDEX/MATCH functions and master them through examples.
  • Information function
    • Learn about the ISBLANK/ISEVEN/ISTEXT functions and learn through examples.

Expected Questions Q&A 💬

Q. Is this a course that non-majors can also take?

Yes. Excel is a widely used program for all types of work, so it would be useful for anyone, regardless of major or non-major, to learn it.

Q. Why should I learn Excel functions?

Learning functions in Excel will allow you to use them appropriately at work, increasing your work efficiency and helping you leave work on time.

Q. Is there anything I need to prepare before attending the lecture?

Please prepare MSOFFICE EXCEL 2016 or higher. Some functions may not be available in older versions.

Q. What level of content is covered in the class?

Since it covers functions from easy to intermediate and advanced, if you follow the course from the beginning, you will learn all the functions without difficulty.


Introducing the Knowledge Sharer ✒️

History

I have been teaching Office Administration (OA) programs for over 10 years, specializing in office programs. I currently serve as a full-time instructor in the Office Administration program at a vocational training institute. I was awarded an A-grade instructor in the Office Administration program category of the NCS Vocational Training Completion Evaluation for two consecutive years, in 2018 and 2019.

The subjects I specialize in are Excel Practical Training, ITQ Master (Hangul, Excel, PowerPoint) course, and Computer Utilization Skills Level 1 and 2 course.

Qualification Acquisition

  • Information Processing Industry Engineer
  • Computer Proficiency Level 1 and 2
  • PTI Professional Instructor (ITQ Specialist)
  • Vocational Skills Training Instructor (Information Technology Operations Management)
  • Vocational Skills Training Instructor (General Affairs) Level 3

Recommended for
these people

Who is this course right for?

  • - For those who want to know about Excel functions

  • - People who want to know about various functions other than frequently used functions

  • - People who want to overcome function anxiety

  • - Anyone who needs confidence in Excel

Need to know before starting?

  • - Excel Basics

Hello
This is

422

Learners

40

Reviews

1

Answers

4.9

Rating

17

Courses

 

취업을 준비하는 학생들에게 자기계발에 도움을 주는 사무자격증을 강의하고 있습니다

그리고 직무 역량을 향상시키기 위해 직장인 대상 실무엑셀 강의를 합니다

은희쌤 클래스 대표

■ 전문 자격

직업훈련교사2급(일반총무사무) 고용노동부

직업훈련교사(정보기술운용관리)3급 고용노동부

직업훈련교사3급(일반총무사무) 고용노동부

컴퓨터활용능력 1급 대한상공회의소

ITQ정보기술전문강사(PTI) 한국생산성본부

ITQ 한글 A, 엑셀 A, 파워포인트 A, 인터넷 A 한국생산성본부

컴퓨터활용능력 2급 한국상공회의소

정보처리산업기사 한국산업인력관리공단

■ 저서

사전처럼 쏙쏙 뽑아쓰는 엑셀함수 85선 & 분석작업의 모든것(부크크 2020)

■ 강의 이력

강남구청에서 위탁한 GIT아카데미 소속으로 강남구 대치4동 정보화교실에서 OA, ITQ자격증 강의 2009.03

군포장애인복지관에서 장애인, 어르신 대상으로 OA, ITQ자격증 강의 2011.03

금천구청에서 위탁한 한빛전산 소속으로 금천구청 전산교육장에서 OA 강의 2012.03

서대문장애인복지관에서 장애인, 어르신 대상으로 OA, ITQ자격증 강의 2013.03

화성유앤아이센터(여성비젼센터)에서 컴퓨터활용능력2급, ITQ OA 마스터 과정을 직장인, 일반인 대상으로 강의 2015.01

경기직업교육센터에서 실업자 직업훈련과정으로 컴퓨터활용능력 2급, ITQ OA 마스터과정 강의 2015.03

그린컴퓨터아카데미에서 실업자 직업훈련과정으로 컴퓨터활용능력 1급, 2급, ITQ OA 마스터과정 강의 2016.04

사무행정부문 이수자 평가 "A" 취득 2018. 12

그린컴퓨터아카데미 스타 강사 수상 2020.10

인프런에서 실무엑셀, 자격증 강의 판매 2022.03

[은희쌤 클래스] 취업 자격증 전문 인강사이트 개설 2022.09

[마포청년나루] 청년 취업 역량 ITQ 엑셀 특강



Curriculum

All

26 lectures ∙ (5hr 53min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

11 reviews

4.9

11 reviews

  • jja05110380님의 프로필 이미지
    jja05110380

    Reviews 4

    Average Rating 5.0

    5

    100% enrolled

    I liked that it was basically organized into functions that are frequently used in daily life.

    • dmsgml1030
      Instructor

      Yes^-^ Thank you. If you have any questions about functions in Excel, please feel free to ask. I will answer sincerely.

  • yg34277561님의 프로필 이미지
    yg34277561

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    Thank you for organizing only the salty and strong things I need

    • dmsgml1030
      Instructor

      Hello, Natural Monument. Thank you for listening to the lecture until the end. ^^. If you have any questions at any time, please ask and I will give you a quick answer. ~~

  • kbj2525님의 프로필 이미지
    kbj2525

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    It was a great class~!

    • dmsgml1030
      Instructor

      Hello kbj Thank you for helping me with the function dictionary lecture If you have any questions about functions or Excel in the future, please feel free to ask. I will do my best to help you (If your question is long or you want a detailed answer, you can send it to me by email dmsgml-1030@hanmail.net) Be careful of your health during the changing seasons.

  • dahamkim07127006님의 프로필 이미지
    dahamkim07127006

    Reviews 1

    Average Rating 5.0

    5

    62% enrolled

    Thank you for the great lecture!

    • dmsgml1030
      Instructor

      Hello, Kim Da-ham Thank you for listening to the function dictionary lecture until the end If you have any questions about functions, please ask at any time I will do my best to help you Thank you

  • sh1005park6311님의 프로필 이미지
    sh1005park6311

    Reviews 9

    Average Rating 4.8

    5

    100% enrolled

    thank you

    • dmsgml1030
      Instructor

      Hello, Mr. Park Sung-hoo. Thank you for listening to the function dictionary lecture. If you have any questions about functions, please ask me anytime. I will do my best to help you. And please send me a review to dmsgml-1030@hanmail.net with the message, "I wrote a review." Then, as promised in the news, I will send you the e-book PDF of [85 Excel functions that are easy to use like a dictionary]. Thank you.

Limited time deal ends in 4 days

$19,250.00

30%

$22.00

dmsgml1030's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!