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

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 !

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 💬

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