Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice

Through this course, learners will be able to acquire the skills necessary to obtain a Computer Application Skills certification. This course is structured according to the examination standards for obtaining the Computer Application Skills certification. You can learn and apply fundamental knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice)

(4.6) 5 reviews

4,208 learners

Level Basic

Course period 12 months

Excel
Excel
MS-Office
MS-Office
Computer Specialist in Spreadsheet & Database
Computer Specialist in Spreadsheet & Database
Excel
Excel
MS-Office
MS-Office
Computer Specialist in Spreadsheet & Database
Computer Specialist in Spreadsheet & Database
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

Reviews from Early Learners

Reviews from Early Learners

4.6

5.0

everick9

11% enrolled

Thank you~!

5.0

할수있다

100% enrolled

Thank you, I listened carefully

5.0

jin4348

100% enrolled

Thank you for the great lecture~ ^^

What you will gain after the course

  • 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 usefulit

8,278,846

Learners

6,391

Reviews

4.6

Rating

309

Courses

I will help you grow through useful IT lectures.

Curriculum

All

27 lectures ∙ (12hr 42min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

4.6

5 reviews

  • jin1015님의 프로필 이미지
    jin1015

    Reviews 58

    Average Rating 4.8

    5

    100% enrolled

    Thank you for the great lecture~ ^^

    • hyde31633589님의 프로필 이미지
      hyde31633589

      Reviews 349

      Average Rating 5.0

      5

      100% enrolled

      Thank you, I listened carefully

      • everick93569님의 프로필 이미지
        everick93569

        Reviews 317

        Average Rating 4.9

        5

        11% enrolled

        Thank you~!

        • na908152380님의 프로필 이미지
          na908152380

          Reviews 24

          Average Rating 4.2

          4

          100% enrolled

          It is easy to understand because the explanation is based on the problem. There is a lot of content that is very helpful.

          • bombtj6195님의 프로필 이미지
            bombtj6195

            Reviews 4

            Average Rating 4.5

            4

            100% enrolled

            Oh, it's a class without questions and answers. It's good for practicing along.

            usefulit's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            $42.90