Name: 321 System, 3 Weeks to Complete! Komhwal Level 2 Practical with Excel - Roadmap to Pass in 1 Go
Price: 33000 KRW

321 System, 3 Weeks to Complete! Komhwal Level 2 Practical with Excel - Roadmap to Pass in 1 Go

"Computer Proficiency Level 2 Practical Test, Master Excel in One Month!" This course is designed to allow you to easily and systematically learn all the essential content for the Computer Proficiency Level 2 practical test, focusing on Excel. You can quickly acquire the skills to pass through key functions immediately applicable in practice and practical problem-solving processes. Key Features: From Basics to Core: Complete coverage from basic Excel usage to key functions tested in the practical exam Practical Problem Solving: Reflects the latest test trends, learn by selecting high-frequency problems Maximizing Efficiency: Learn only essential functions intensively to save time Kind Description: Structure makes it easy for even beginners unfamiliar with computers to follow Do you want to finish preparing for the Computer Proficiency Level 2 practical test within a month? With this course, passing is definitely not difficult! 😊

💻 Information on the Level 2 Computer Proficiency Practical Exam

The Level 2 Computer Proficiency Practical Exam uses the MS Office 2021 version, and consists of four task-type problems over a total of 40 minutes .
The test will be held at each regional chamber of commerce, and the test fee is approximately 25,000 won .

📝 Test Structure and Question Types

1. Basic work (20 points)

One question will be asked among data entry, cell formatting, conditional formatting, filtering, and sorting.
Includes adjusting cell width, filling cell color, inserting special characters, writing notes, etc.
Basic Excel Operation Skills Assessment

2. Calculation task (40 points)

Five function utilization problems
Main functions:
- Database functions: DSUM, DAVERAGE
- Conditional functions: SUMIF, SUMIFS
- Rounding functions: ROUND, ROUNDUP, ROUNDDOWN
- Lookup functions: VLOOKUP, HLOOKUP
- String functions: LEFT, RIGHT, MID
- Others: RANK.EQ, CHOOSE, IF, etc.
The scope of function questions is wide, so learning by priority is necessary.

3. Analysis work (20 points)

Two questions on pivot tables, scenarios, subtotals, data integration, and goal seeking.
Data Analysis Skills Assessment

4. Other work (20 points)

Writing macros, creating charts, and editing problems
Assessing automation and visualization capabilities

⏰ Examination Process and Passing Criteria

Test time: 40 minutes
Passing Criteria: 70 points or higher out of 100
Problem structure:
- Basic Task 3 Problems
- 5 calculation tasks
- Analysis task 2 questions
- Other work 2 problems
The order of problem solving varies depending on individual strategy.
It is important to solve the problem accurately within the time limit.

📅 Exam Registration and Preparation Tips

How to apply: Korea Chamber of Commerce and Industry Qualification Evaluation Division website or mobile app 'Kocham Pass'
The test is offered on a regular basis, so you can choose the date and time you want.
Examination fee: approximately 25,000 won (written/practical each)
How to study:
- Repeated study of past exam questions 🔄
- Function-first learning 🎯
- Practice solving problems within the actual time ⏳
The Secret to Passing: Improve Accuracy and Time Management Skills

🎯 Summary

Computer skills level 2 practical test

From basic Excel tasks to function calculations, data analysis, macros, and chart creation.
Solve 4 types of problems in 40 minutes
Pass if you score 70 points or higher!

If you consistently practice with past exam questions, you'll be closer to passing! 🚀

Recommended for
these people

Who is this course right for?

Beginner aiming for Computer Proficiency Level 2 certificate
Office workers and job seekers needing certifications for employment or promotion
Regular person wanting to upskill in Excel for efficiency

25년간의 온오프라인 강의 경험으로 최소의 비용으로 최대의 효과를 얻을수 있도록
끊임없이 노력하는 컴퓨터강사입니다.

한국학원총연합회 표창장 수상국제 컴퓨터학원 강사

그린컴퓨터학원 강사(정보처리, 컴퓨터활용, 모스)

더조은 컴퓨터학원(C언어, 정보처리, 모스)

동덕여자대학교 MOS 강의

국제 비지니스 교육(C/C++강의)

에듀펜 동영상강의(정보처리, 컴퓨터활용 강의

길벗출판사 (정보처리 온라인강의)
배울학 (컴퓨터활용능력 온라인 강의)

자격사항
컴활1급, 정보처리기사, 워드1급, 정보기기운용기능사, 전자계산기기능사, 전산회계 자격증 취득

321 System, 3 Weeks to Complete! Komhwal Level 2 Practical with Excel - Roadmap to Pass in 1 Go