강의

멘토링

커뮤니티

Career

/

etc. (Career)

Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General

Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)

(5.0) 6 reviews

4,084 learners

  • usefulit
Excel
MS-Office
VBA
Computer Specialist in Spreadsheet & Database

Reviews from Early Learners

What you will gain after the course

  • Enter and edit spreadsheets

  • Using Spreadsheet Formulas

  • Spreadsheet Data Management

Attention job seekers!
Develop your computer skills and apply for a job 👨‍💻

📢 Please check before taking the class!

  • This course does not offer Q&A sessions with knowledge sharing experts regarding the course content. Please keep this in mind when registering for the course.

To acquire computer skills
If you want to challenge yourself! 📖

Computer Proficiency Level 1 & 2 Written Exam - General Spreadsheet 📐

This course is designed to help you obtain a computer proficiency certification, and is structured to reflect actual exam criteria. Learn and apply the basic knowledge for each computer proficiency subject to achieve certification!

Computer Proficiency Test Information 💻

Acceptance criteria

  • Written Exam: 40 points or more per subject out of 100 and an average of 60 points or more
  • Practical: 70 points or higher out of 100 (Level 1 requires 70 points or higher in both subjects)

Practical program

  • MS Office 2016

Test Registration & Other Details

  • Korea Chamber of Commerce and Industry Qualification Evaluation Division website 👉 Go to

What you'll learn 📚

Enter and edit

  • Manage and save worksheets
  • Data, Input, Shortcuts, Data Types
  • File Options, Paste, Cells, Insert, Delete
  • Cell formatting, date formatting, conditional formatting
  • Fill, Sheet Tab, Save Method

Using formulas

  • Operator, cell reference, formula error
  • Rounding, date functions, math functions
  • IF function, rank.eq, reference function
  • (Level 1) offset, database functions, present value functions
  • Formula error message, vlookup function

Data Management, Macros

  • (Level 1) Arrays, array formulas, array constants
  • Sort, filter, advanced filter, external data
  • Query join, subtotal, goal seek, scenario, print
  • Charts, sparklines, trend lines
  • msgbox, inputbox, macro, vba/vbe, programming, basic configuration
  • (Level 1) Objects, Methods, Events

Database General Level 1/2 Mock Exam

  • Filter, Sort, Scenario (Level 1/Level 2)
  • Macros, Scenarios, Advanced Filters (Level 1/Level 2)
Data management (external data, query joins, subtotals)
Macros and Programming (msgbox, inputbox, macros)

Computer skills that are easy, light, and informative!

  • ✅ Everything from theory to problem solving is included in one place.
  • ✅ Review your theoretical knowledge by solving practice problems for each section.
  • ✅ We offer mock exams filled with past exam questions. Use them for a final check before your actual exam!

Recommended for
these people

Who is this course right for?

  • Anyone who wants to obtain a computer skills certificate

  • Anyone who wants to learn how to use computers for work

Hello
This is

8,277,764

Learners

6,285

Reviews

4.6

Rating

309

Courses

유용한 IT 강의를 통해 여러분의 성장을 돕겠습니다.

Curriculum

All

24 lectures ∙ (10hr 30min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

6 reviews

5.0

6 reviews

  • everick93569님의 프로필 이미지
    everick93569

    Reviews 317

    Average Rating 4.9

    5

    13% enrolled

    ありがとう!!!!!!

    • hyde31633589님의 프로필 이미지
      hyde31633589

      Reviews 349

      Average Rating 5.0

      5

      100% enrolled

      ありがとう、よく聞きました

      • dibin49925710님의 프로필 이미지
        dibin49925710

        Reviews 1

        Average Rating 5.0

        5

        83% enrolled

        わかりやすく、詳しく説明してくれていいです。

        • jin1015님의 프로필 이미지
          jin1015

          Reviews 58

          Average Rating 4.8

          5

          100% enrolled

          良い講義ありがとうございます〜

          • ks1119choi1404님의 프로필 이미지
            ks1119choi1404

            Reviews 6

            Average Rating 5.0

            5

            100% enrolled

            詳細な説明よかった

            $42.90

            usefulit's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!