한번에 끝내는 워드프로세서 자격증 취득(필기+실기)
박쌤컴퓨터
한글 네오 프로그램을 이용하여, 워드프로세서 자격증 취득증을 위한 자격증 강의합니다. 필기와 실기를 이 강좌로 끝내세요. 최신 유형의 문제를 분석하여 시험에 완벽 대비합니다.
입문
워드프로세서, 한글
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! 😊
What you will gain after the course
Excel data entry and editing skills
Formula and Function Skills
Chart and Data Visualization Skills
Data Analysis and Processing Skills
Document Automation Skill (Macro)
💻 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
526
Learners
39
Reviews
7
Answers
4.7
Rating
9
Courses
25년간의 온오프라인 강의 경험으로 최소의 비용으로 최대의 효과를 얻을수 있도록
끊임없이 노력하는 컴퓨터강사입니다.
한국학원총연합회 표창장 수상국제 컴퓨터학원 강사
그린컴퓨터학원 강사(정보처리, 컴퓨터활용, 모스)
더조은 컴퓨터학원(C언어, 정보처리, 모스)
동덕여자대학교 MOS 강의
국제 비지니스 교육(C/C++강의)
에듀펜 동영상강의(정보처리, 컴퓨터활용 강의
길벗출판사 (정보처리 온라인강의)
배울학 (컴퓨터활용능력 온라인 강의)
자격사항
컴활1급, 정보처리기사, 워드1급, 정보기기운용기능사, 전자계산기기능사, 전산회계 자격증 취득
Curriculum
All
70 lectures ∙ (30hr 17min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
1 reviews
$26.40
ds8828455's other courses
Check out other courses by the instructor!
![[한글NEO] 한번에 끝내는 문서작성 & ITQ 한글 자격증 취득강의 썸네일](https://cdn.inflearn.com/public/courses/327670/cover/7ba4422b-6ffe-4224-b281-536e363bba71/327670-eng.png?f=avif&w=420)
Similar courses
Explore other courses in the same field!
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
