강의

멘토링

로드맵

Inflearn brand logo image
Career

/

etc. (Career)

Computer Proficiency Level 1,2 Practical - Spreadsheet Practice (2021 Revised)

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. It is a course for obtaining a computer proficiency certificate, and it is structured in accordance with the examination criteria. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate. (Computer Proficiency Level 1, 2 Practical - Spreadsheet Practice (2021 Revised))

(4.6) 5 reviews

4,204 learners

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

Reviews from Early Learners

What you will learn!

  • Pivot Table

  • Spreadsheet Conditional Formatting

  • Spreadsheet formulas

  • Spreadsheet Functions

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 Levels 1 and 2 Practical - Spreadsheet Practice 📐

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
  • Data Validation
  • filter
  • Conditional formatting
  • Pivot Table, Data Table
  • (Level 1) External data, advanced pivot tables, procedures
  • Data management (subtotals, goal seeking, scenarios)
  • Charts, Macros
  • Formulas - Arithmetic operations, precedence, absolute references
  • Mathematical functions, statistical functions, logical functions
  • Round, RoundDown, RoundUp
  • Date functions, string functions, logical functions
  • Find and reference functions, DATABASE functions, and statistical functions
  • (Level 1) IF, OFFSET, MATCH, FV, PMT, array formulas, user-defined functions
  • Level 2 Mock Exam: Cell Formatting, Conditional Formatting, Functions
  • Level 2 Mock Exam: Subtotals, Integration, Charts, Cell Format, Sorting, Scenarios, Macros
  • Level 1 Mock Exam: Advanced Filters, Conditional Formatting, and Functions
  • Level 1 Mock Exam: Pivot Tables, Subtotals, Charts
data table
FV function, PMT function, array formula 1

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,256,333

Learners

6,111

Reviews

4.6

Rating

296

Courses

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

Curriculum

All

27 lectures ∙ (12hr 42min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

4.6

5 reviews

  • everick9님의 프로필 이미지
    everick9

    Reviews 315

    Average Rating 4.9

    5

    11% enrolled

    감사합니다~!

    • 할수있다님의 프로필 이미지
      할수있다

      Reviews 349

      Average Rating 5.0

      5

      100% enrolled

      감사합니다 잘 들었습니다

      • na90815님의 프로필 이미지
        na90815

        Reviews 24

        Average Rating 4.2

        4

        100% enrolled

        문제 기반으로 설명을 잘해주셔서 이해가 잘됩니다. 크게 도움되는 내용들이 많아요

        • jin4348님의 프로필 이미지
          jin4348

          Reviews 57

          Average Rating 4.8

          5

          100% enrolled

          훌륭한 강의 감사합니다~ ^^

          • bombtj님의 프로필 이미지
            bombtj

            Reviews 4

            Average Rating 4.5

            4

            100% enrolled

            아 질의 응답 없는 수업이네요. 따라 연습하기는 좋습니다.

            $42.90

            usefulit's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!