ITQ Excel Certification to be completed over the weekend

ITQ Excel National Certification Key Summary Lecture to be Obtained in Two Days of Weekend! 4 Mock Exams and Special Lecture on Functions Provided Separately!

(4.7) 수강평 3개

강의소개.상단개요.수강생.short

난이도 입문

수강기한 무제한

MS-Office
MS-Office
Excel
Excel
ITQ
ITQ
MS-Office
MS-Office
Excel
Excel
ITQ
ITQ

강의상세_배울수있는것_타이틀

  • How to use Excel in practice

  • ITQ Excel Certification Exam Questions Function

ITQ MASTER certified

Direct lecture from the former director of a computer training center!

I have been teaching ITQ certification for over 10 years, and for 2 years, I have run my own computer training center, teaching a variety of classes, including elementary school students, classes for housewives in their 50s, classes for computer illiterate people in their 60s, classes for re-employment, classes for college students, and classes for working people.

This "Weekend-Finish" lecture series is based on these experiences, and is designed to concisely summarize the most essential parts so that students can quickly obtain an A-level ITQ Excel certification .

We create and teach mock exam guides ourselves!

  • The skills tested on the certification exam are fixed! This is reflected in the questions, and comparisons with the latest past exam questions provided on the official website provide an opportunity to learn the skills more accurately.

  • Studying quickly and accurately is key! Since the goal is to obtain a certification, the course is structured to help you quickly and accurately master only the skills that will appear on the exam.

  • To help students experience the entire exam process, we've prepared a complete, unedited solution! We've prepared a separate video for your reference, from starting the exam using the mock test program to solving the problems and submitting your answers.

Learn about these things

Format & Function

Compared to other subjects, Excel requires a bit of preparatory work to create a format that matches the exam paper. This is referred to as "basic settings" in the lecture. We first thoroughly familiarize ourselves with this, and then thoroughly study everything from table creation to formatting. Next, we'll cover function application, but this part is structured in conjunction with a special lecture, allowing students to adjust their own difficulty level.

Advanced Filters & Target Finder

The second task consists of a fixed Advanced Filter problem, and the remaining one is a table-based or Target Value Finding problem. The Target Value Finding problem, in particular, requires the use of functions, making it relatively difficult. Therefore, while you should utilize the special function lecture to familiarize yourself with the function's usage, you should also understand the purpose of the Target Value Finding function itself.

Subtotals & PivotTables

The third task involves using the sort and subtotal functions or the pivot table function. These problems emphasize not only the method of using the functions, but also the order and rules in which they are applied.

chart graph

Using the first worksheet, you'll learn how to select a range of cells to use as source data and automatically create a chart on a new sheet. By learning this feature, you'll master the art of solving items (1) through (3) of the fourth worksheet problem without making any mistakes.

Things to note before taking the course

Practice environment

  • Tool used: MS-Office Excel program

  • PC specifications: PC with basic specifications capable of Internet access
    Please make sure to use a computer that is capable of taking the actual ITQ Excel certification exam!

Learning Materials

  • ITQ Excel Mock Exam Paper 4 Sets

  • Mock exam answer file

  • Function special lecture materials


Player Knowledge and Precautions

  • No prior knowledge is required.

  • Anyone who can type in Korean and English can take the class and aim to obtain the certification.

  • Usually, even at academies, it is explained that (recommended age) PowerPoint can be acquired by elementary school 4th graders or higher, Korean language can be acquired by elementary school 6th graders or higher, and Excel can be acquired by middle and high school students or higher.

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • If you want to get started with Excel for office work

  • If you are new to Excel functions,

  • If your goal is to obtain ITQ Excel certification in a short period of time

  • If you need a nationally recognized qualification that can be obtained in a short period of time

강의소개.지공자소개

4,586

수강생

172

수강평

30

답변

4.9

강의 평점

7

강의_other

ErumCoding

Let's code our dreams together! 🚀

더보기

커리큘럼

전체

26개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

3개

4.7

3개의 수강평

  • terry19r8567님의 프로필 이미지
    terry19r8567

    수강평 1

    평균 평점 5.0

    5

    27% 수강 후 작성

    • sun21657502님의 프로필 이미지
      sun21657502

      수강평 1

      평균 평점 5.0

      5

      31% 수강 후 작성

      • woocheolpark1060님의 프로필 이미지
        woocheolpark1060

        수강평 6

        평균 평점 4.3

        4

        100% 수강 후 작성

        It was an informative education.

        erumcoding님의 다른 강의

        지식공유자님의 다른 강의를 만나보세요!

        비슷한 강의

        같은 분야의 다른 강의를 만나보세요!

        강의상세.할인문구

        $6.60

        25%

        $8.80